Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Angie is calculating her average sales for the past four months. If she uses '=AVERAGE(B1:B4)', this is an example of which type of entry?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Where is the Insert Function button found in Microsoft Excel?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Which is a prewritten formula that is built into Microsoft Excel?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
Formula bar
Functions
Function
AVERAGE
TODAY
Defined Names
Calculation
Formula Auditing
Check it!