DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following data types should be selected if we are going to enter data in “currency” format?
|
|
Fraction
|
|
|
Currency
|
|
|
Percentage
|
|
|
Number
|
Explanation:
Detailed explanation-1: -If you choose data type CURR, you must enter a currency. You can use the possible entries function to display the currencies that are allowed.
Detailed explanation-2: -When you apply the Currency format to a number, the currency symbol appears right next to the first digit in the cell. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.
Detailed explanation-3: -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.
There is 1 question to complete.