Excel Module 5 Vocabulary Question Preview (ID: 58194)
Excel Module 5 Vocabulary.
TEACHERS: click here for quick copy question ID numbers.
A mathematical equation that performs calculations on values in a worksheet.
a) formula
b) value
c) constant
d) operator
A representation in Excel that can be a number, a cell address, a date, text, or range of cells.
a) value
b) formula
c) constant
d) operator
A number or text value that is entered directly into a cell.
a) constant
b) value
c) formula
d) operator
An Indicator used to specify the type of calculation to take place, such as add (+), subtract (-), multiply (*), or divide (/).
a) operator
b) formula
c) value
d) constant
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) function
b) operator
c) constant
d) value
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
Identifies a cell’s location within a worksheet.
a) cell reference
b) relative cell reference
c) absolute cell reference
d) named range
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
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) absolute cell reference
b) mixed cell reference
c) function
d) operator
A cell or range in a formula that uses both a relative and absolute reference.
a) mixed cell reference
b) named range
c) function
d) constant
A single cell or group of cells in an Excel worksheet with a designated name.
a) named range
b) constant
c) operator
d) value
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 58194 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 58194 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register