FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following types of cell references should you use if you want the cell references in the formula to change to reflect the position of its copied location relative to its original location?
A
Absolute
B
Mixed
C
Relative
D
Stationary
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: -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-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).

Detailed explanation-4: -Relative, absolute and mixed cell references. There are three types of cell references in Excel: relative, absolute and mixed. When writing a formula for a single cell, you can go with any type.

Detailed explanation-5: -These cell references that adjust itself when the cell is copied are called relative cell references in Excel.

There is 1 question to complete.