DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Absolute
|
|
|
Mixed
|
|
|
Relative
|
|
|
Stationary
|
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.