Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Pre-set settings that determine how Excel behaves when performing an action.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
The rules Excel follows to calculate any formula that contains two or more operators.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
Parentheses inside of parentheses within a formula.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
A cell reference that uses an absolute column or row reference, but not both.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
A number or text value entered directly into a formula.
constant
formula
relative cell reference
default settings
mixed cell reference
nested parenthesis
value
order of operations
Check it!
Match it!
Match it!