FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A cell reference that adjusts the cell identifier automatically if you insert or delete column or row or if you copy the formula to another cell
A
Relative cell reference
B
Absolute cell reference
C
Mixed cell reference
D
External reference
Explanation: 

Detailed explanation-1: -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-2: -Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Detailed explanation-3: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).

There is 1 question to complete.
Previous
Next