USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You must start each formula by typing the equal sign (=). When you change the value in a cell that is referenced in a formula, you must re-enter the formula to make sure it also changes. You can click a cell or select a range to enter its address in the formula. Formulas and functions are NOT case sensitive.
Detailed explanation-2: -These are called “relative” cell references, since they change relative to where you copy the formula. 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.
Detailed explanation-3: -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.