Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Expert Module 2 Vocab
Test Description: Excel Expert Module 2 Vocab
Instructions: Answer all questions to get your test result.
1) 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
column index number
B
array function
C
expression
D
function
2) 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
iteration
C
expresssion
D
array function
3) A mathematical term; for example, =200 (greater than or equal to 200) or 100 (less than 100).
A
expression
B
column index
C
function arguments
D
array function
4) Function Arguments The dialog box that helps you build a formula.
A
iteration
B
function arguments
C
table array
D
lookup value
5) The repeated recalculation of a worksheet until a specific value is reached.
A
lookup value
B
array function
C
expression
D
Iteration
6) Refers to the value you want to find.
A
table array
B
lookup value
C
array function
D
iteration
7) The table, range, or list of cells that contains the value you want to find.
A
table array
B
lookup value
C
expression
D
array function
8) The formatted appearance of cells associated with specified criteria.
A
grouped data
B
data consolidation
C
conditional formatting
D
formula
9) Excel functions and parameters used to perform calculations.
A
grouped data
B
data consolidation
C
formula
D
conditional formatting
10) An outline of data that users can expand or collapse to quickly display summary rows or columns.
A
conditional formatting
B
formula
C
data consolidation
D
grouped data
*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?