Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a(n):
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=B4-C4
named range
external reference.
=$B$1+25
external reference
Absolute
=B4*C4
Relative reference
Check it!
Match it!
Match it!