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]
In order to create a single formula to copy to the other rows, use ____ references so the formula calculates the total for each item correctly.
A
relative
B
relational
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -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-2: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. 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: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.

There is 1 question to complete.
Previous
Next