Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
Tyler created a monthly sales workbook that contains the formula = (January!B3). 'January' is an example of a/an:
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
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?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
Relative reference
Copy using the Fill Handle
=B4-C4
external reference.
=$B$1+25
named range.
Cell reference and cell location are outlined in matching colors
Absolute
Check it!