Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Which of the following are valid Microsoft Excel functions?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
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?
Worksheet Reference
formulas
=$B$1+25
NOW
AVERAGE, MAX, and MIN
Active Sheets
Defined Names
Formula Auditing
Check it!