Excel ch. 1

Question 1

Workbook

Answer 1

An excel document that stores your data

Question 2

Worksheet/ Spreadsheet

Answer 2

Formatted with rows and columns that intersect at a cell

Question 3

Cell

Answer 3

Intersection of a column and row

Question 4

F12

Answer 4

Save as box

Question 5

Cell reference

Answer 5

Identifies cell

Question 6

Active cell

Answer 6

The cell that has data being displayed in the name box

Question 7

Auto complete

Answer 7

Excel fills the rest of the characters within a column

Question 8

Fill handle

Answer 8

Small square of the bottom right corner of an active cell

Question 9

Formula

Answer 9

An equation that performs mathematical calculations on values and other cells and then places the result in the cell containing the formula

Question 10

Function

Answer 10

A pre-written formula that looks at one or more values, performs an operation, and then returns a value

Question 11

Underline Value

Answer 11

Is where the formula is displayed in the formula bar

Question 12

Reference Cell

Answer 12

Has a blue border

Question 13

Sparklines

Answer 13

Tiny chars embeeded in a cell that gives a visual trend summary alongside your data

Question 14

Charts

Answer 14

Provide a graphic representation of data in a worksheet

Question 15

Display Value

Answer 15

The results of a formula calculation in a cell

Question 16

Constant Value

Answer 16

Text or numbers or a formula

Question 17

Text Value

Answer 17

Provide information about number values in other worksheet cells

Question 18

Text Value is also known as a…

Answer 18

Label