Financial
Logical
Text
Mathematical
Date & Time
100
Excel displays this when you copy one range of cells to another.
What is the Auto Fill Options button?
100
This button allows you to pick from a gallery of styles for the active cell.
What is the Cell Styles button?
100
A chart used to illustrate changes in data over time.
What is a Line chart?
100
Used to find answers to questions and display information about various topics in Excel.
What is Excel Help?
100
Area on the Status Bar that shows a total, average, or other information about the numbers in a range.
What is the Auto Calculate area?
200
As in algebra, you can use these in a formula to override the order of operations in Excel.
What are parentheses?
200
Symbols or signs telling Excel to perform a specific operation or calculation.
What are arithmetic operators?
200
To change the angle of text in a cell from 1 to 90 degrees.
What is rotate?
200
Excel displays #REF! to indicate this type of error.
What is a cell reference error?
200
Instructs the paste operation in Excel to keep the same cell reference as it copies a formula from one cell to another.
What is absolute referencing?
300
Key that selects the cell at the beginning of a row with the active cell.
What is the Home key?
300
Text and graphics that prints at the top of each page of a worksheet.
What is a header?
300
Shortcut to toggle between the values and the formulas version of a worksheet.
What is Ctrl + ` (Accent Mark)?
300
The order Excel reads a formula.
What is left to right?
300
You can use this shortcut to check the spelling of your worksheet.
What is F7?
400
Chart used to show the contribution of each piece of data to the whole.
What is a Pie chart?
400
Provides a simple way to show trends and variation in a range of data within a single cell.
What is a Sparkline chart?
400
When more than one arithmetic operator is present in a formula, Excel follows this to perform the calculation.
What is the order of operations?
400
Use this function to assign a value to a cell based on a logical test.
What is the IF function?
400
Symbol used to indicate an absolute or mixed cell reference.
What is the dollar sign ($)?
500
An IF function within an IF function.
What is a nested IF?
500
When a number that the function returns is not constant.
What is a Volatile function?
500
Using touch or the mouse to move or copy cells.
What is Drag and Drop?
500
To have Excel determine the value of a cell on which the formula depends.
What is Goal Seeking?
500
Instructs the paste operation in Excel to adjust the cell reference in a formula as it copies it to the destination area.
What is relative cell referencing?
M
e
n
u