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
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
How is a cell reference in a formula and its corresponding location in a worksheet identified?
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
=B4*C4
Copy using the Fill Handle
=$B$1+25
formulas
external reference.
Cell reference and cell location are outlined in matching colors
external reference
=B4-C4
Check it!
Match it!
Match it!