Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a/an:
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
Copy using the Fill Handle
=$B$1+25
AutoFit
named range.
Formulas
Relative reference
=D4*F4
=B4-C4
Check it!