Keyboard Commands
Formulas & Formatting
Worksheet
Functions
Charts
100
The keyboard combination you press to apply bold.
What is CTRL+B?
100
The symbol you type to start all formulas.
What is the equal sign?
100
The intersection of a column and a row.
What is a cell?
100
The most commonly used function.
What is SUM?
100
Keyboard command to insert a chart.
What is F11?
200
The function key most commonly used to repeat the last command.
What is F4?
200
The most commonly used function.
What is SUM?
200
A vertical collection of cells.
What is a column?
200
Function that returns the smallest number in a set of values.
What is MIN?
200
A chart's key.
What is legend?
300
The keyboard combination to insert today's date.
What is Ctrl+;
300
A five-digit number that requires special formatting.
What is zip code?
300
A horizontal collection of cells.
What is a row?
300
Function that counts the number of empty cells in a specified range.
What is countblank?
300
The horizontal axis.
What is x?
400
The keyboard combination you press to see formulas and not cell values.
What is Ctrl+~?
400
Where the Function Library is found.
What is the Formulas tab?
400
This area displays values, formulas, the name box, and the enter and cancel buttons.
What is the Formula bar?
400
Returns the arithmetic mean of its arguments.
What is AVERAGE?
400
The vertical axis.
What is y?
500
The keyboard button combination that will undo your last action.
What is CTRL+Z?
500
Accounting
What is the number format that aligns currency symbols and decimal points?
500
A collection of worksheets.
What is a workbook?
500
Joins several text strings into one text string.
What is concatenate?
500
A graphical representation of data.
What is a chart?
M
e
n
u