DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
relative reference
|
|
|
absolute reference
|
|
|
comparative reference
|
|
|
virtual reference
|
Detailed explanation-1: -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: -These are called “relative” cell references, since they change relative to where you copy the formula.
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: -A relative cell reference in a formula will not change when the formula is copied. By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference.
Detailed explanation-5: -An absolute reference in Excel refers to a reference that is “locked” so that rows and columns won’t change when copied. Unlike a relative reference, an absolute reference refers to an actual fixed location on a worksheet. Absolute references are used when you want to fix a cell location.