FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To access other date formatting options, select the Number Format drop-down menu and choose ____ Number Formats .
A
More
B
Date
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format.

Detailed explanation-2: -Excel has a large number of additional formatting options, and while there are useful shortcuts on the “Home” tab on the toolbar, the most comprehensive list of options can be found by right-clicking on your selected cell or cells and selecting “Format Cells…” from the drop-down menu (see screen capture, below).

Detailed explanation-3: -On the Home tab, in the Number group, click the Dialog Box Launcher next to Number. You can also press CTRL+1 to open the Format Cells dialog box. In the Category list, click Date or Time.

There is 1 question to complete.