DATABASE FUNDAMENTALS
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 .
|
More
|
|
Date
|
|
Either A or B
|
|
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.