FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
As a number processing software, Ms. Excel has several number formats that can be adapted to the data to be added, one of which is the ‘currency’ format used for ____
A
Text
B
Fraction
C
Currency
D
Decimal numbers
E
Date and Time
Explanation: 

Detailed explanation-1: -You can add between 200 and 250 custom number formats, depending on the language version of Excel that is installed on your computer. For more information about custom formats, see Create or delete a custom number format. You can apply different formats to numbers to change how they appear.

Detailed explanation-2: -Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want. Note: If you want to display a monetary value without a currency symbol, you can click None.

Detailed explanation-3: -You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number. The number format does not affect the cell value that Excel uses to perform calculations. The actual value is displayed in the formula bar. Excel provides several built-in number formats.

There is 1 question to complete.
Previous
Next