5 Questions
How can you change the format of a date in Excel?
Select the cell containing the date, click on the Format drop-down button, and choose Format Cells option
What can be done to modify cell contents in Excel?
Replace cell contents or use Edit mode
Where can you find the options to change time format in Excel?
Category list on the Number tab in Format Cells dialog box
What happens when you type in new data in a cell in Excel?
The Cancel and Enter buttons become active on the left of the Formula Bar
How can you accept a new entry in a cell after typing in Excel?
Press either the Enter key or Enter button on the Formula Bar
This quiz tests your knowledge of formatting dates in Excel. It covers how to recognize and format different date formats, and how to change the display format of a date in Excel.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free