DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Dollar
|
|
|
Currency
|
|
|
Percent Style
|
|
|
Comma Style
|
Detailed explanation-1: -Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press Ctrl+Shift+$.
Detailed explanation-2: -Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.
Detailed explanation-3: -To have the currency symbol appear on the left of the cell rather than just to the left of the number, include for example, $* or â* followed by a space at the beginning of the number format. The example on the left uses the number format: “â* #, ##0; â*-#, ##0” (without the quotes).
Detailed explanation-4: -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.