Entering date and time!

Question 1

How can you separate the date elements?

Answer 1

Select the cell and type the date and time. You can separate the date elements with a slash(/), hyphen(-), or use format, such as 14 Aug 05, as excel recognises and supports a wide variety of date formats.

Question 2

How to display the entered date in different formats?

Answer 2

To display the entered date in different formats, select the cell and click on the Format drop-down button in the Cells group on the Home tab and click on the Format Cells option. In the Format Cells dialog box, choose any format of date by clicking on the Date option in the Category list on the Number tab.

Question 3

Where can the characters and numbers typed in a worksheet be seen?

Answer 3

The characters and numbers typed in a worksheet can be seen both in the cell and in the Formula Bar.

Question 4

How to accept the entry of contents?

Answer 4

To accept the entry of contents, type the contents, and press either the Enter key or the Enter button present on the Formula Bar.

Question 5

Which 2 buttons become active after typing new data?

Answer 5

After typing the new data, the two buttons on the left side of the Formula Bar-Cancel and Enter-become active