FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which tab in the Format Cells dialog box can you create a Custom format?
A
Border
B
Font
C
Number
D
Fill
Explanation: 

Detailed explanation-1: -In the Format Cells dialog box, under Category, click Custom. In the Type list, select the built-in format that most resembles the one that you want to create. For example, 0.00. The number format that you select appears in the Type box.

Detailed explanation-2: -Alignment Tab. You can position text and numbers, change the orientation and specify text control in cells by using the Alignment tab in the Format Cells dialog box.

Detailed explanation-3: -To see all available number formats, click the Dialog Box Launcher next to Number on the Home tab in the Number group. The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way you type them.

Detailed explanation-4: -The Number tab allows you to select the number formatting options, such as decimal spaces, currency symbol, time format, zip code format, and so on. Select the desired category you would like to format, such as Date, from the Category list.

There is 1 question to complete.