DATABASE FUNDAMENTALS
BASICS OF BIG DATA
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
No
|
|
Relative
|
|
Static
|
|
Absolute
|
Detailed explanation-1: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill.
Detailed explanation-2: -Press F2 to enter the edit mode. Input your formula in one cell, and press Ctrl + Enter instead of Enter. That’s it! The formula will get copied to all of the selected cells, and Excel will adjust relative cell references accordingly.
Detailed explanation-3: -By default, all cell references are relative references. 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-4: -The correct answer is Relative Reference. With relative cell referencing, when we copy a formula from one area of the worksheet to another, it records the position of the cell relative to the cell that originally contained the formula. This is the default mode of referencing in a spreadsheet.
Detailed explanation-5: -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.