DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What kinds of formats can we apply in Excel when working with money?
|
|
Money and Decimals
|
|
|
Currency and Accounting
|
|
|
Accounting and Number
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.
Detailed explanation-2: -Difference between Currency and Accounting Format The Currency format aligns the currency sign at the left edge of the value in the cell. The Accounting format aligns the currency sign at the left edge of the cell, nearest to the border. We can choose to align values in left, right, or center.
There is 1 question to complete.