USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
scatter reference
|
|
absolute cell reference
|
|
mixed cell reference
|
|
relative cell reference
|
Detailed explanation-1: -If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same. Place a “$” before a row number if you want that to always stay the same.
Detailed explanation-2: -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-3: -By default, every cell in Excel has a relative reference. In relative references, type “=A1+A2” in cell A3, copy and paste the formula in cell B3, and the formula automatically changes to “=B1+B2.” In absolute references, the cell address does not change when the formula is copied.