FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Setting the currency for data in the form of money is done in the group ____
A
Numbering
B
Calculation
C
Window
D
Alignment
Explanation: 

Detailed explanation-1: -On the Home tab, click the Dialog Box Launcher next to Number. 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.

Detailed explanation-2: -In a query Open the query in Design View. Right-click the date field, and then click Properties. In the Property Sheet, select the format you want from the Format property list.

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.

Detailed explanation-4: -United States (U.S.) currency is formatted with a decimal point (.) as a separator between the dollars and cents. Some countries use a comma (, ) instead of a decimal to indicate that separation.

There is 1 question to complete.
Previous
Next