Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which is a prewritten formula that is built into Microsoft Excel?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
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 Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Which are valid Microsoft Excel functions?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
Formula Auditing
Today
Calculation
Function
AVERAGE, MAX, and MIN
Defined Names
NOW
Functions
Check it!