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?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
Gabriel needs to create a formula that does not change when it is copied to cell B2/. Which formula should he create?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
John's workbooks includes 3 worksheets. Which option should he choose to print them?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
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?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
When copying values in Excel which feature automatically adjusts cell references for the new copy location?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
Jim would like to print only the cell range A1:F20. What page setup option should he change?
print entire workbook
relative reference
=B4*C4
=$b$1+25
average
print area
=b4-c4
formulas
Check it!