USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
true
|
|
false
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.
Detailed explanation-2: -A cell reference with only one dollar sign before either the column of the row is called mixed cell reference.
Detailed explanation-3: -A cell reference with only one dollar sign before either the column or the row is called a MIXED CELL REFERNCE.
Detailed explanation-4: -Absolute cell references In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “$” – for example, $A$1 is an absolute reference to cell A1. Wherever the formula is copied or moved, it always refers to cell A1.
Detailed explanation-5: -In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other. A dollar symbol ($) is used before the coordinates to correct them. For instance, $D$2 is an absolute reference to cell D2.