Excel Expert Module 2 Vocab Question Preview (ID: 58978)
Excel Expert Module 2 Vocab.
TEACHERS: click here for quick copy question ID numbers.
Array function A formula that calculates more than one variable at the same time. You must use Ctrl+Shift+Enter to complete an array function; the completed formula will be contained with braces ….
a) array function
b) column index number
c) expression
d) function
Column index number The position of the column within the table array. The row index number refers to the position of the row within the table array.
a) column index number
b) expresssion
c) array function
d) iteration
A mathematical term; for example, =200 (greater than or equal to 200) or 100 (less than 100).
a) expression
b) array function
c) column index
d) function arguments
Function Arguments The dialog box that helps you build a formula.
a) function arguments
b) iteration
c) lookup value
d) table array
The repeated recalculation of a worksheet until a specific value is reached.
a) Iteration
b) array function
c) expression
d) lookup value
Refers to the value you want to find.
a) lookup value
b) table array
c) array function
d) iteration
The table, range, or list of cells that contains the value you want to find.
a) table array
b) array function
c) expression
d) lookup value
The formatted appearance of cells associated with specified criteria.
a) conditional formatting
b) formula
c) grouped data
d) data consolidation
Excel functions and parameters used to perform calculations.
a) formula
b) conditional formatting
c) grouped data
d) data consolidation
An outline of data that users can expand or collapse to quickly display summary rows or columns.
a) grouped data
b) formula
c) conditional formatting
d) data consolidation
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: 58978 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: 58978 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register