Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Module 5 Vocabulary
Test Description: Excel Module 5 vocabulary
Instructions: Answer all questions to get your test result.
1) A mathematical equation that performs calculations on values in a worksheet.
A
operator
B
formula
C
value
D
constant
2) A representation in Excel that can be a number, a cell address, a date, text, or range of cells.
A
constant
B
formula
C
value
D
operator
3) A number or text value that is entered directly into a cell.
A
constant
B
formula
C
operator
D
value
4) An Indicator used to specify the type of calculation to take place, such as add (+), subtract (-), multiply (*), or divide (/).
A
constant
B
formula
C
value
D
operator
5) A pre-built command in Excel that performs mathematical operations such as automatically adding up a range of cells, or reviewing values to be used in calculations.
A
constant
B
function
C
operator
D
value
6) A standard mathematical process used to determine which operator to calculate first when evaluating a formula.
A
order of operations
B
formula
C
value
D
constant
7) Identifies a cell’s location within a worksheet.
A
cell reference
B
named range
C
absolute cell reference
D
relative cell reference
8) A cell or range reference in a formula that changes based upon the relation to the cell containing the formula.
A
relative cell reference
B
cell reference
C
absolute cell reference
D
function
9) A cell reference in a formula that refers to a specific cell or range regardless of where the formula is located in the worksheet.
A
operator
B
mixed cell reference
C
function
D
absolute cell reference
10) A cell or range in a formula that uses both a relative and absolute reference.
A
named range
B
constant
C
mixed cell reference
D
function
11) A single cell or group of cells in an Excel worksheet with a designated name.
A
named range
B
value
C
operator
D
constant
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?