Question

19.How can you enter date and time together in a cell?​

Answer 1

Answer:

1. To insert the current date, press Ctrl+; (semi-colon).

2. To insert the current time, press Ctrl+Shift+; (semi-colon).

3. To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).