Definition
Functions
Reference/Pointer
Formats
Buttons
100
Format
What is the cell that determines how the labels and values look?
100
ROUND
What is the function that rounds a value to a specified decimal place?
100
Z$6
What is an example of a mixed cell reference?
100
Conditional Formatting
What changes formatting of a cell that meets a certain rule?
100
italics button
What italicizes text?
200
Font Size
What is the physical size of the text?
200
AVERAGE
What is the function that adds that values in a range of cells then divides by the number of cells?
200
$Z$6
What is an example of an absolute cell reference?
200
Merge and Center button
What centers cell contents over multiple cells?
200
Bold button
What bolds text?
300
Point
What is equal to 1/72?
300
MIN
What is the function that finds the smallest number in a range?
300
Z6
What is an example of a relative cell reverence?
300
Spell button
What checks for apparent misspellings in a worksheet?
300
Underline button
What underlines text?
400
Font
What is the name for a collection of characters with a similar, specific design?
400
COUNT
What is the function that determines the number of cells in a range?
400
Copy pointer
What is the type of pointer that creates a duplicate of selected cells?
400
dollar signs
What adds dollar signs and two decimal places to selected data?
400
Left alignment
What aligns text at the left edge of the cell?
500
Font Styles
What are the formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet?
500
SUM
What is function that totals the value in a range of cells?
500
I-beam pointer
What is the type of pointer that allows you to edit cell contents in the active cell or formula bar?
500
CTRL home
What moves cell pointer to cell A1?
500
Right align
What aligns text at the right edge of the cell?
M
e
n
u