The keyboard shortcut Ctrl + Shift + # is used in Microsoft Excel to apply the Date format to the selected cell or range of cells. This command formats the cell's content to display as a date in the dd-mmm-yy format. For example, if a cell contains the serial number 45000, applying this shortcut will change the display to 17-Jul-23. This is a quick method for formatting numerical data into a standard date representation without navigating through the Format Cells dialog box.

B. The shortcut to apply the Time format is Ctrl + Shift + @.

C. The shortcut to apply the Currency format is Ctrl + Shift + $.

D. The shortcut to apply the Number format (with two decimal places and a thousands separator) is Ctrl + Shift + !.

1. Microsoft Support. (n.d.). Keyboard shortcuts in Excel. Microsoft. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.

Reference Location: Under the section "Ctrl combination shortcut keys

" the table lists Ctrl+Shift+# with the description "Applies the Date format with the day

month

and year."

2. Indiana University. (2023

October 25). Excel keyboard shortcuts. University Information Technology Services Knowledge Base. Retrieved from https://kb.iu.edu/d/aacc.

Reference Location: In the "Formatting" section

the table entry for "Date format" specifies the shortcut Ctrl+Shift+#.

3. University of Wisconsin-Madison. (2020

July 20). Excel - Keyboard Shortcuts. Division of Information Technology (DoIT) KnowledgeBase. Retrieved from https://kb.wisc.edu/showcase/page.php?id=92544.

Reference Location: Under the "Formatting" subsection

the shortcut Ctrl+Shift+# is listed for applying the "Date format (dd-mm-yy)."