Multiple choice general knowledge

In excel, Shift+Ctrl+; is for ?

  1. Insert Date and Time

  2. Insert Date

  3. Insert Time

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Ctrl+Shift+; (semicolon) inserts the current time in Excel. The standard Ctrl+; inserts the current date, while Ctrl+Shift+: (which is the same as Ctrl+Shift+;) inserts the current time. Both are useful for timestamping data entries.

Keep practicing — related questions