Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
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?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
You need to create a formula that does not change when it is copied to cell E2. Which formula should you create?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
If you have a cell in your spreadsheet that contains a formula such as =(BudgetUS!B3), what does the BudgetUS represent?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
Which of the formulas is the correct way to calculate the value of A7 taken from the value of C12?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
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?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
If you type =Sum(B7+D7) into a cell, which of the following best describes what you have entered?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
Copy using the Fill Handle
Absolute
Cell reference and cell location are outlined in matching colors
=$E$1+15
Worksheet Reference
External Reference
=C12-A7
Formula
Check it!
Match it!
Match it!