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