DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sparklines
|
|
|
Number Formatting
|
|
|
Styles
|
|
|
Conditional Formatting
|
Detailed explanation-1: -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-2: -Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press Ctrl+Shift+$. Like the Currency format, the Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of numbers in a column.
Detailed explanation-3: -The Currency format refers to a built-in number format of MS Excel used particularly for currencies like prices. It adds a currency sign before the entered values within the formatted cells. The currency format is most commonly used for denoting general monetary values in Excel cells.
Detailed explanation-4: -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).