Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
PMT, PV, and FV are functions found in which Function Library category?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
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
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Kash is working with a large, complex worksheet and would like to to see what is going on in different cells in different parts of the workbook. What built-in tool would Kash use to make monitoring various cell values much simpler?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Which Excel feature keeps track of defined ranges and cell addresses?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
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?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Which symbol refers to a field name in a table that has already been named?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Michelle is trying to review all formulas in her worksheet for accuracy. If the active cell is A2, which command will help identify the cells that are affected by A2?
Name Manager
TODAY
Trace Dependents
FieldName
Watch Window
Financial
Goal Seek
Check it!