# CBA CHS Excel Les 1-8 Final Test

## 119 terms · Final Excel Vocabulary Term

### Absolute cell reference

Does not change when copied or moved to a new cell (EX 90).

### Formula

The equation used to calculate values in a cell (EX 85).

### Manual calculation

Lets you determine when Excel calculates the formulas (EX 97).

### Mixed cell reference

Cell references that contain both relative and absolute references (EX 91).

### Operand

A constant (text or number) or cell reference used in a formula (EX 86).

### Operator

A symbol that indicates the type of calculation to perform on operands (EX 86).

### Order of evaluation

The sequence used to calculate the value of a formula (EX 87).

### Point-and-click method

Allows you to point and click each cell in a formula rather than typing cell references (EX 92).

### Relative cell reference

Adjusts to its new location when copied or moved (EX 90).

### Sum button

Makes adding long columns or rows of numbers simple to do (EX 93).

### Automatic page break

Excel inserts this whenever it runs out of room on a page (EX 69).

### Copy

Duplicates the cell's contents without affecting the original cell (EX 56).

### Cut

The selected cell contents are placed as an item on the Clipboard and are removed from their original location (EX 56).

### Fill

Copies a cells contents and/or formatting into an adjacent cell or range (EX 59).

### Fill handle

Appears in the lower-right corner of the active cell or range, and is used to fill cells (EX 59).

### Footer

Text that prints in the bottom margin of each page (EX 72).

### Freeze pane

You select rows and/or columns to remain visible on the screen as the rest of the worksheet scrolls (EX 63).

Text that prints in the top margin of each page (EX 72).

### Landscape orientation

Worksheets printed in this orientation are wider than they are long (EX 68).

### Manual page break

Insert this manually to start a new page (EX 69).

### Margins

Blank spaces around the top, bottom, and sides of a page (EX 68).

### Normal view

View used when entering and formatting data in a worksheet (EX 67).

### Office Clipboard (Clipboard)

A temporary storage area for up to 24 selections you copy or cut (EX 56).

### Page Break Preview

Shows you the location of page breaks and allows you to change them easily (EX 69).

### Page Layout view

View that is helpful when you prepare a worksheet for printing (EX 67).

### Paste

Places the last item from the Clipboard into the cell or range selected in the worksheet (EX 56).

### Portrait orientation

Worksheets printed in this orientation are longer than they are wide (EX 68).

### Print area

Consists of the cells and ranges designated for printing (EX 69).

### Print title

Designated rows and/or columns in a worksheet that print on each page (EX 71).

### Scale

Enables you to resize a worksheet to print on a specific number of pages (EX 70).

### Split

Divides the worksheet window into two or four panes that you can scroll independently (EX 64).

### Active cell

The cell in the worksheet in which you can type data (EX 6).

### Active worksheet

The worksheet that is displayed in the work area (EX 10).

### Cell

The intersection of a row and a column (EX 6).

### Cell reference

Identifies the cell, and is formed by combining the cell's column letter and row number (EX 6).

### Column

Appears vertically and is identified by letters at the top of the worksheet window (EX 6).

### Formula Bar

Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value (AC 6).

### Microsoft Office Excel 2007 (Excel)

The spreadsheet program in Microsoft Office 2007 (EX 4).

### Name Box

Cell reference area located below the Ribbon, displays the cell reference of the active cell (EX 6).

### Range

A group of selected cells (EX 11).

### Range reference

How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon (EX 11).

### Row

Appears horizontally and is identified by numbers on the left side of the worksheet window (EX 6).

### Sheet tab

Tab at the bottom of the worksheet window that displays the name of the worksheet (EX 6).

A grid of rows and columns in which you enter text, numbers, and the results of calculations (EX 4).

### Workbook

The file used to store worksheets (EX 4).

### Alignment

To change the alignment, select the cell and click an alignment button, such as Top Align, Bottom Align, and Center Align (EX 31).

### AutoFit

Determines the best width for a column or the best height for a row, based on its contents (EX 28).

### Border

A line around a cell's edges (EX 39).

### Cell style

A collection of formatting characteristics you apply to a cell or range of data (EX 44).

### Clear

Removes formatting applied to a cell or a range of cells (EX 45).

The column letter (EX 28).

### Editing mode

When you double-click the cell and place the insertion point within the cell contents, you are in this mode (EX 35).

### Font

The design of text (EX 35).

### Font size

Determines the height of characters as measured in points (EX 35).

### Font style

Using effects such as bold, italic, and underlining to add emphasis to a font (EX 35).

### Format Painter

Enables you to copy formatting from one worksheet cell to another without copying the cell's contents (EX 41).

### Indent

Shifted to the right (EX 31).

### Live Preview

Shows the results of the different formatting options you can choose (EX 35).

### Merge

Combine into one cell (EX 31).

### Number format

Change the way data looks in a cell (EX 40).

### Orientation

Changing the angle at which the data is displayed (EX 32).

### Points

A unit of measurement for font height (EX 35).

The row number (EX 28).

### Style

Combination of formatting characteristics such as alignment, font color, and borders (EX 44).

### Theme

Preset collection of design elements (EX 34).

### Truncate

Hidden from view (EX 34).

### Wrap text

When the row height adjusts automatically to include additional lines until all the text is visible (EX 34).

### Argument

The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand (EX 105).

### Date and time functions

Functions that are used to insert dates and times in a worksheet (EX 118).

### Financial functions

Functions used to analyze loans and investments (EX 114).

### Formula AutoComplete

As you begin to type a function name, this feature shows a list of functions below the active cell (EX 108).

### Function

Shorthand way to write an equation that performs a calculation (EX 105).

### Logical functions

Functions that display text or values if certain conditions exist (EX 117).

### Mathematical functions

Functions, such as the square root and rounding functions that manipulate quantitative data in a worksheet (EX 109-110).

### Statistical functions

Functions used to describe large quantities of data (EX 112).

### Text functions

Functions that are used to format and work with cell contents (EX 119).

### Trigonometric functions

Functions, such as the natural logarithm, that manipulate quantitative data in a worksheet (EX 109-110).

### Ascending sort

Data with letters arranged in alphabetical order (A to Z), data with numbers arranged from lowest to highest, and data with dates arranged from earliest to latest (EX 131).

### AutoFilter

Menu that displays a list of all the values that appear in that column along with additional criteria and color filtering options. (EX 134).

### Comment

A note attached to a cell that is usually used to explain or identify information contained in the cell (EX 154).

### Conditional formatting

Highlights worksheet data by changing the look of cells that meet a specified condition (EX 136).

### Descending sort

Arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest (EX 131).

### Filter

Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria (EX 134).

### Filter arrows

Appear in the lower-right corners of the column heading cells and are used to access the AutoFilter menu for that column (EX 134).

A cell in a worksheet that opens another file or page when you click it (EX 149).

### Object

Anything that appears on the screen that you can select and work with as a whole (EX 140).

### Picture

A digital photograph or other image file (EX 144).

Provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias (EX 155).

### SmartArt graphic

Enhance worksheets by providing a visual representation of information and ideas (EX 142).

### Sort

Rearranging the data in a more meaningful order (EX 131).

### Template

A predesigned workbook file that you can use as the basis or model for a new workbook (EX 146).

### 3-D reference

A reference to the same cell or range in multiple worksheets that you use in a formula (EX 169).

### Active sheet

The worksheet that appears in the workbook window (EX 164).

### Destination

The location where the data will appear after it is transferred (EX 169).

### Sheet tab

Appears at the bottom of the workbook window and identifies the worksheets within the workbook (EX 163).

### Source

The location the data is being transferred from (EX 169).

### Worksheet range

A group of adjacent worksheets (EX 169).

### Axis

A line that establishes a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis (EX 190).

### Chart

A graphical representation of data (EX 182).

### Chart area

The entire chart and all other chart elements (EX 190).

### Chart layout

Specifies which elements are included in a chart and where they are placed (EX 190).

### Chart sheet

A separate sheet in the workbook that stores a chart (EX 186).

### Chart style

Formats the chart based on the colors, fonts, and effects associated with the workbook's theme (EX 191).

### Column chart

Chart that uses bars of varying heights to illustrate values in a worksheet (EX 183).

### Data label

Text or numbers that provide additional information about a data marker (EX 190).

### Data marker

A symbol that represents a single data point or value from the corresponding worksheet cell (EX 190).

### Data series

A group of related information in a column or row of a worksheet that is plotted on the chart (EX 185).

### Data source

Chart data (EX 185).

### Data table

A grid that displays the data plotted in the chart (EX 190).

### Embedded chart

After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet (EX 186).

### Exploded pie chart

When you pull one or more slices away from the pie in a pie chart to distinguish them. (EX 193).

### Legend

A list that identifies patterns, symbols, or colors used in a chart (EX 190).

### Line chart

Chart that is similar to a column chart, but where columns are replaced by points connected by a line (EX 183).

### Pie chart

Chart that shows the relationship of a part to a whole (EX 184).

### Plot area

The graphical representation of all of the data series (EX 190).

### Scatter chart

Chart that shows the relationship between two categories of data. The data points are not connected by a line because they do not relate to each other the way they do in a line chart (EX 184).

### Selection box

A selected chart element is surrounded by a selection box (EX 190).

### Sizing handles

You resize a chart by dragging one of these (EX 186).