Flashcards in Final Deck (50)
Loading flashcards...
0
A cell address in a formula that will not change when you copy the formula to another location
Absolute reference
1
The cell contains the cell pointer. There is a dark outline around the active cell
Active cell
2
Feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula: AVERAGE, COUNT, MIN, MAX, or SUM
Auto calculate
3
A feature used to complete an entry based on previous entries made in the column containing the active cell
AutoComplete
4
A dot or symbol that marks an important line of information or designates items in a list
Bullets
5
The location of a cell in a worksheet as identified by its column letter and row number
Cell address
6
The intersection of a column and a row on a worksheet
Cell
7
Vertical series of cells in a table
Column
8
Personal business letter that you send with your resume when you apply for a job
Cover letter
9
A value, some text, or an expression that defines the type of content you want to see
Criterion
10
A style that displays dollar signs immediately preceding the number and includes a thousands separator
Currency format
11
A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells
Data bars
12
The action of using a mouse to drag a selection from its original location and drop it in a new location
Drag–and–drop editing
13
A dot followed by three or four characters at the end of a file name, used to indicate the file type
File extension
14
A black box on the lower-right corner of the selected cell or range that you used to fill (copy) A series or formula
Fill handles
15
Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify
Filter
16
The height of an uppercase letter in a font set
Font size
17
Text or graphics printed at the bottom of all pages in a document
Footer
18
An instruction Excel uses to calculate a result
Formula
19
A style of letter in which lines start flush with the left margin-that is without indents
Full – block
20
The name given to one of Excel's predefined formulas
Function name
21
Predefined formula that performs a specific calculation using the inputs you specify
Function
22
Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group
Grouping
23
The position of text across a line in relation to the left and right margins
Horizontal alignment
24
The method of operations used for inserting new text within existing text in a document
Insert mode
25
Text entered to identify the type of data contained in a row or column
Label
26
The amount of white space between lines of text in a paragraph
Line spacing
27
A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell
Merge and center
28
Combine multiple adjacent cells together to create one large cell
Merge
29
