Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which Excel term refers to a selection of cells?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Which Excel term, denoted with square brackets, can be found in the header row of a table and refers to the set of all cells that comprise the named column in the table?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Which financial function allows Robyn to determine the amount she must pay each month on her car loan?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Which symbol refers to a field name in a table that has already been named?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
An Excel formula that is placed within another formula is referred to as:
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Perry is using multiple worksheets and would like to total the numbers into one summary worksheet. Which built-in Excel tool should Perry use to accomplish his goal quickly?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Which Excel feature keeps track of defined ranges and cell addresses?
Name Manager
Consolidate Data
FieldName
table_array
PMT
nested
range
Check it!
Match it!
Match it!