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
A
Excel erases the original copy of the formula
B
Excel edits cell references in the newly copied formula
C
Excel adjusts absolute cell references
D
Excel doesn’t adjust relative cell references
Explanation: 

Detailed explanation-1: -The correct answer is Relative Reference. With relative cell referencing, when we copy a formula from one area of the worksheet to another, it records the position of the cell relative to the cell that originally contained the formula. This is the default mode of referencing in a spreadsheet.

Detailed explanation-2: -Unlike copying a formula, when you move a formula to another location in the same or another worksheet, the cell references in the formula don’t change, regardless of what type of cell reference you used.

Detailed explanation-3: -By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.

Detailed explanation-4: -When you copy a formula that contains a relative cell reference, that reference in the formula will change. As an example, if you copy the formula =B4*C4 from cell D4 to D5, the formula in D5 adjusts to the right by one column and becomes =B5*C5.

Detailed explanation-5: -When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location. In formulas, calculations in square brackets are calculated first. To enter data in a cell using examples already in your workbook, you can use the flash fill feature.

There is 1 question to complete.