How do you apply currency formatting to a cell?

How do you apply currency formatting to a cell?

• A. Home tab -> Number group -> Currency
• B. Home tab -> Font group -> Currency
• C. Data tab -> Number -> Currency
• D. View tab -> Number group -> Currency

Answer: (A)

Currency formatting changes how a value is displayed by showing a currency symbol and two decimal places, making monetary values easy to read. In Excel, you apply this by going to the Home tab, in the Number group, and selecting Currency. This immediately formats the selected cells. For more control, you can click the launcher in the Number group or open Format Cells and choose Currency to set the symbol, decimals, and negative-number style. A quick way is the keyboard shortcut Ctrl+Shift+$ to apply currency format. The Font, Data, and View tab paths don’t provide currency formatting options, so they won’t apply this display style.

Currency formatting changes how a value is displayed by showing a currency symbol and two decimal places, making monetary values easy to read. In Excel, you apply this by going to the Home tab, in the Number group, and selecting Currency. This immediately formats the selected cells. For more control, you can click the launcher in the Number group or open Format Cells and choose Currency to set the symbol, decimals, and negative-number style. A quick way is the keyboard shortcut Ctrl+Shift+$ to apply currency format. The Font, Data, and View tab paths don’t provide currency formatting options, so they won’t apply this display style.