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?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
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?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
How is a cell reference in a formula and its corresponding location in a worksheet identified?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a(n):
named range
=$B$1+25
Copy using the Fill Handle
formulas
Absolute
Worksheet Reference
Cell reference and cell location are outlined in matching colors
=B4-C4
Check it!