Final

Question 0

The cell contains the cell pointer. There is a dark outline around the active cell

Answer 0

Active cell

Question 1

A cell address in a formula that will not change when you copy the formula to another location

Answer 1

Absolute reference

Question 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

Answer 2

Auto calculate

Question 3

A feature used to complete an entry based on previous entries made in the column containing the active cell

Answer 3

AutoComplete

Question 4

A dot or symbol that marks an important line of information or designates items in a list

Answer 4

Bullets

Question 5

The location of a cell in a worksheet as identified by its column letter and row number

Answer 5

Cell address

Question 6

The intersection of a column and a row on a worksheet

Answer 6

Cell

Question 7

Vertical series of cells in a table

Answer 7

Column

Question 8

Personal business letter that you send with your resume when you apply for a job

Answer 8

Cover letter

Question 9

A value, some text, or an expression that defines the type of content you want to see

Answer 9

Criterion

Question 10

A style that displays dollar signs immediately preceding the number and includes a thousands separator

Answer 10

Currency format

Question 11

A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells

Answer 11

Data bars

Question 12

The action of using a mouse to drag a selection from its original location and drop it in a new location

Answer 12

Drag–and–drop editing

Question 13

A dot followed by three or four characters at the end of a file name, used to indicate the file type

Answer 13

File extension

Question 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

Answer 14

Fill handles

Question 15

Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify

Answer 15

Filter

Question 16

The height of an uppercase letter in a font set

Answer 16

Font size

Question 17

Text or graphics printed at the bottom of all pages in a document

Answer 17

Footer

Question 18

An instruction Excel uses to calculate a result

Answer 18

Formula

Question 19

A style of letter in which lines start flush with the left margin-that is without indents

Answer 19

Full – block

Question 20

The name given to one of Excel’s predefined formulas

Answer 20

Function name

Question 21

Predefined formula that performs a specific calculation using the inputs you specify

Answer 21

Function

Question 22

Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group

Answer 22

Grouping

Question 23

The position of text across a line in relation to the left and right margins

Answer 23

Horizontal alignment

Question 24

The method of operations used for inserting new text within existing text in a document

Answer 24

Insert mode

Question 25

Text entered to identify the type of data contained in a row or column

Answer 25

Label

Question 26

The amount of white space between lines of text in a paragraph

Answer 26

Line spacing

Question 27

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

Answer 27

Merge and center

Question 28

Combine multiple adjacent cells together to create one large cell

Answer 28

Merge

Question 29

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

Answer 29

Name box

Question 30

To use a function as an argument within another function

Answer 30

Nest

Question 31

Not adjacent, or not next to, each other

Answer 31

Noncontiguous

Question 32

Characters such as paragraph marks and tab symbols that are not printed in a document but that can be displayed on the screen

Answer 32

Nonprinting characters

Question 33

A graphic, picture, chart, shape, text box, or other element that can be inserted in a document

Answer 33

Object

Question 34

An identifying label assigned to a group of cells

Answer 34

Range name

Question 35

A block of cells in an Excel worksheet

Answer 35

Range

Question 36

A document summarizing an individual's employment experience, education, and other information a potential employer needs to know

Answer 36

Resume

Question 37

To change the angle of the contents of a cell

Answer 37

Rotate

Question 38

A list of sequential numbers, dates, times, or text

Answer 38

Series

Question 39

Color or pattern used to fill the background of a cell

Answer 39

Shading

Question 40

Small symbols around the edges of a selected object that you used to resize the object. Corner handles are around and side handles are square

Answer 40

Sizing handles

Question 41

Arrange the rows in a table or list of data in a new order according to the entries in one or more columns

Answer 41

Sort

Question 42

Divide one cell into multiple cells, either to create columns or horizontally to create rows

Answer 42

Split

Question 43

The location on a horizontal line to which the insertion point advances when you press the tab key

Answer 43

Tab stop

Question 44

The measurement of the space the insertion point advances when you press the tab key

Answer 44

Tab

Question 45

Set of coordinated colors, fonts, and effects that can be applied to office 2013 documents

Answer 45

Theme

Question 46

A listing of words with synonyms and antonyms

Answer 46

Thesaurus

Question 47

A row you can display below a table to calculate data in the columns above using a function you choose

Answer 47

Total row

Question 48

A work area for entering and calculating data made up of columns and rows separated by grid lines

Answer 48

Worksheet

Question 49

A feature that causes long cell entries to appear on multiple lines within a cell

Answer 49

Wrap text