# www.TestsTestsTests.com ## Microsoft Excel FREE Resources Index Page Copying Formulas in Excel & using Relative & Absolute Cell References Test – Free Online Microsoft Excel 2010 Test – Formulas & Functions in Excel

# Copying Formulas in Excel & Using Relative & Absolute Cell References Test

## Free Online Microsoft Excel Tests Excel 2010 – Formulas & Functions in Excel

### * The Fill Handle Excel 2010 * Copying and Pasting Formulas in Excel * Drag and Drop in Excel * Absolute and Relative References in Excel 10 Question Multiple Choice Quiz with Answers and Answer Explanations

***GO TO THE TEST ANSWER EXPLANATIONS PAGE

### Copying Formulas in Excel & Using Relative & Absolute Cell References Test

1) The Fill Handle located at the bottom right-hand corner of a selected cell has multiple uses.  Which of the following is NOT a function of the Fill Handle?
a) Copy a formula from one cell into cells adjacent to it.
b) Copy formatting from one cell into cells adjacent to it.
c) Enlarge the section of a table containing values.
d) Automatically fill sequences such as days of the week, months or numerical values. 2) Study the screenshot above.  Which of the following options represent the actual contents of the selected cell (D4)?
a) The contents of D4 is =SUM(B4,C4).
b) The contents of D4 is \$166.00.
c) The contents of D4 is \$33.00.
d) The contents of D4 is D4.

3) Priya is reviewing a spreadsheet for a colleague.  She notes that part of all the formulas contain dollar symbols in the cell references, for example =A1*\$B\$ and starts deleting the dollar symbols.  Is that a good or bad idea and why?
a) Good idea.  The person who created the spreadsheet clearly made a typing error by including the dollar symbols.
b) Bad idea.  The dollar symbols are needed to format the calculated values of the formula with the correct currency symbol.
c) Bad idea.  The dollar symbols mark the references in the cells as Relative References. Removing these will cause the formula to calculate incorrect values.
d) Bad idea.  The dollar symbols mark the references in the cells as Absolute References. Removing these will cause the formula to calculate incorrect values.

4) Which of the following is NOT a necessary action when moving the contents of a cell to a different location using the Drag and Drop function?
a) Hover the mouse over the border of selected cell(s).
b) Select the cells you wish to move the selected contents to.
c) Click and hold down the left mouse button whilst dragging the cell(s) to their new position.
d) Select the cell(s) which contain the values you wish to move. 5) Study the screenshot above.  Miley copied values from a different worksheet and pasted it into column B of her expense sheet.  However, when she pastes it, the above errors appears.  What is happening and how can she fix it?
a) She used Relative References instead of Absolute References in her formulas.  If she changes to Absolute references the problem will be resolved.
b) She copied and pasted the incorrect cells. To prevent errors in copying and pasting cell values, she should use the Fill Handle.
c) She copied cell formulas instead of values.  She should copy and paste the cells again and select Paste Values from the Paste Menu.
d) She used Absolute References instead of Relative References in her formulas.  If she changes to Relative references the problem will be resolved. 6) Study the screenshot above.  Which of the following options correctly predict what the contents of cell D3 will be if the Fill Handle is used to copy down cell D2?
a) D3 will contain the formula:  =SUM(B3,C3).
b) D3 will contain the formula:  =SUM(B2,C2).
c) D3 will contain the formula:  =SUM(D2,C2).
d) D3 will contain an error message as the formula cannot be copied down without the references being made Absolute.

7) Which of the following options correctly represent a formula with Absolute References?
a) =(A\$1\$-B\$1\$)
b) =(A\$1-B\$1)
c) =(\$A1-\$B1)
d) =(\$A\$1-\$B\$1)

8) What is the shortcut for creating absolute references and how do you use it?
a) Select the cell reference you wish to make Absolute and press Ctrl+a on your keyboard.
b) Select the cell reference you wish to make Absolute and press Ctrl+F4 on your keyboard.
c) Select the cell reference you wish to make Absolute and press F4 on your keyboard.
d) Select the cell reference you wish to make Absolute and press Ctrl+\$ on your keyboard. 9) Study the screenshot above.  What will happen to the formula contained in D4:D10 should we move the contents of Cell B1 (1.05) to cell E25 on the worksheet?
a) The formula will update so that the last part of it will be *\$E\$25.
b) There will be no change to the formula or value of the cell.
c) The cells will return a #REF! error.
d) The formula will no longer calculate the correct values.

10) Copying formulas saves a lot of time.  Which of the following is a method for copying a formula?
a) Ctrl+c to copy the formula, Ctrl+v to paste the formula.
b) Drag the Fill Handle down, up, left or right to copy a formula.
c) Press the Copy button on the Ribbon to copy the formula and the Paste button on the Ribbon to Paste it.
d) All of the above options are correct.