Multiple choice

Which of the following key combinations applies the date format with the day, month and year in MS Excel?

  1. Ctrl + Shift + :

  2. Ctrl + Shift + %

  3. Ctrl + Shift + $
  4. Ctrl + Shift + @

  5. Ctrl + Shift + #

Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Ctrl + Shift + # applies the date format with the day, month and year.