Vocabulary Excel Chapter 1

Chart Styles

. A Word feature that displays commands to apply a style and color scheme to a chart.

Fill handle

. The small black square in the lower right corner of a selected cell

Function

1. A relationship from one set (called the domain) to another set (called the range) that assigns to each element of the domain exactly one element of the range. 2. The action or actions that an item is designed to perform.

Cell Style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Merge and Center

A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell. Combine cells and center the contents.

Chart

A graphical representation of data A document that gives the holder the right to organize settlements in an area

Series

A group of things that come one after another in succession

legend

A list that identifies patterns, symbols, or colors used in a chart

Worksheet

A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data. Within a workbook, worksheets can share information, and calculations pertaining to several worksheets can be performed at one time. The default number of worksheets in a new workbook is three.

Auto fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells. The feature that enables Excel to create a series automatically.

Workbook

An Excel file with one or more worksheets. a collection of related worksheets An Excel file.

Spreadsheet

An application used to store and analyze data.

Sparklines

In Excel, a miniature chart embedded in the background of a single cell.

Operators

In problem solving, permissible moves that can be made toward a problem's solution. actions that take the problem from one state to another

Autofit

PowerPoint feature designed to reduce font size to fit text in the current placeholder. An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Comma Style

The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places

Row

The horizontal cells in one line of a spreadsheet. a horizontal group of cells in a worksheet identified by numbers

column heading

The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column.

Range

The maximum distance people are willing to travel to use a service. Distance between highest and lowest scores in a set of data.

Column Chart

a chart that uses bars of varying height to illustrate values in a worksheet Chart that uses bars of varying heights

AutoSum

a function that automatically adds the values in the cells directly above or to the left of the active cell A button that provides quick access to the SUM function

Row heading

a number at the far-left side of a row that can be clicked to select the entire row of cells The row number. The box to the left of each row containing a number

Active cell

a selected worksheet cell that is ready for data entry The active cell contains the cell pointer. There is a dark outline around the active cell. The cell displayed with a bold border.

Column

a vertical group of cells in a worksheet identified by letters Columns are the vertical divisions of a worksheet that are identified by letters.

Normal View

the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane

Accounting Number Format

the excel number format that applies a thousand inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell

Page Layout View

view that displays the worksheet as a printed page allows you to create or modify a worksheet while viewing how it will look in printed format