Final Flashcards Preview

Micro Comp Final > Final > Flashcards

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

The box at the far-left end of the formula bar that you can use to create and navigate to named ranges

Name box