Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
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?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
Defined Names
named range.
=B4*C4
functions
Relative reference
MAX
NOW
=$B$1+25
Check it!