USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT 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: -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-3: -Meaning & Significance of the Dollar Sign In Excel The dollar sign locks the column or row proceeding it. If you want to lock the column, add the dollar sign before it e.g. to lock the column in the reference B2, adding the dollar sign before the column letter makes it $B2.
Detailed explanation-4: -In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want. Note: If you want to display a monetary value without a currency symbol, you can click None.