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(n) ____ reference is a cell address in a formula that WILL NOT change when you copy the formula to another location.
A
ABSOLUTE
B
BINARY
C
PARALLEL
D
NON BINARY
Explanation: 

Detailed explanation-1: -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-2: -Absolute references There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled.

Detailed explanation-3: -Moving a formula: When you move a formula, the cell references within the formula do not change no matter what type of cell reference that you use. Copying a formula: When you copy a formula, relative cell references will change.

Detailed explanation-4: -Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.

Detailed explanation-5: -Which type of reference does not change the cell address oncopying the formula to another cell? Relative Reference.

There is 1 question to complete.
Previous
Next