Multiple choice technology

What is the shortcut usedin this Scenario? "Apply the date format with no decimal places"

  1. Ctrl+Shift+D

  2. Ctrl+Shift+T

  3. Ctrl+Shift+3

  4. Ctrl+D

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

Ctrl+Shift+3 applies the date format with day-month-year (or your system's default date format) in Excel. This shortcut converts numbers to dates without decimal places. Ctrl+Shift+# would also work since # shares the same key as 3.