Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Doug wants to know how many gadgets he would have to sell to make $1,000,0000. Which Excel tool will help Doug find the answer?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Which Excel feature keeps track of defined ranges and cell addresses?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
PMT, PV, and FV are functions found in which Function Library category?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
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?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Michelle is trying to correct a formula error in cell B7. Which command will help her identify the cells that affect the value of B7?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Which symbol refers to a field name in a table that has already been named?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
table_array
TODAY
Name Manager
Consolidate Data
Financial
Goal Seek
Trace Precedents
Check it!