Formulas
PEMDAS
Functions
References
Error!
100
When typing a formula, begin the formula with this sign.
What is the = (equals sign)
100
This is the operator for division that is used when writing a formula.
What is / (forward slash)
100
A function operates on this, which may consist of a constant, a cell reference, or another function.
What is an argument
100
To display cell references for a formula, perform this action on a cell containing a formula.
What is double-click the cell
100
A referenced cell no longer exists within a worksheet.
What is #REF!
200
As an alternative to the fill handle, use this button to copy a formula relatively in a worksheet.
What is Fill
200
This is the operator for multiplication that is used when writing a formula.
What is * (asterisk)
200
This function returns the largest value in a set of values.
What is MAX
200
To identify an absolute cell reference, type this symbol before the column and row.
What is $ (dollar sign)
200
A function name is not entered correctly.
What is a #Name??
300
This is the keyboard shortcut to display formulas in a worksheet.
What is Ctrl + ` (grave accent)
300
A formula’s order of operations can be modified with these.
What is parentheses
300
This function returns the current date and time.
What is NOW or Today
300
This key is used to cycle through various cell references
What is F4?
300
Excel inserts this symbol in a cell that may contain a possible error.
What is a dark green triangle
400
A value entered directly into the formula
What is a Constant?
400
The last operator evaluated in the order of operations
What is subtraction?
400
This function returns the smallest value in a set of values.
What is MIN
400
$E$16 is an example of what kind of cell reference
What is an Absolute Cell Reference
400
The name of a button that may pop up near the active cell.
What is a smart tag (Trace Error Button)?
500
The Show Formulas button is located in this group on this tab
What is the Formulas Tab in the Formula Auditing group?
500
The first operator evaluated in the order of operations
What is Negations (Negative numbers)
500
The process of calculating the formula in a cell
What is returning the result
500
$B3 is an example of what kind of cell reference
What is a Mixed Cell Reference?
500
An argument parameter has been left out of a function
What is #N/A?
M
e
n
u