# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you copy a formula that contains an absolute reference to a new location, the reference ____
 A is updated automatically B does not change C becomes bold D has a dotted outline in its cell
Explanation:

Detailed explanation-1: -When you copy a formula containing an absolute reference, the cell reference in the copied formula does not change, regardless of where you copy the formula. An absolute cell reference appears with a dollar sign before both the column letter and the row number, such as \$B\$4.

Detailed explanation-2: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign (\$) before the column and row.

Detailed explanation-3: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign (\$) before the cell and column references. For example, when you copy the formula =\$A\$2+\$B\$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.

Detailed explanation-4: -An absolute reference in Excel is a reference that cannot be changed when copied, so you won’t see changes in rows or columns when you copy them. Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign.

Detailed explanation-5: -Usually the CELL REFERENCES will CHANGE! If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left.

There is 1 question to complete.