Laura has been entering dates in worksheets using the Long Date format. Her manager sends her an email asking her to change all the dates from the Long Date format to the Short Date format. Laura can make the changes by:
A)holding the Alt key while clicking the cells with dates in them and clicking the Consolidate option in the Data tab.
B)making a new worksheet, changing the format, and copying the cells to the original worksheet.
C)using the Number Format box arrow in the Number group on the Home tab.
D)re-entering all the dates manually using slashes to divide the numbers.

Question

Quizplus · Accepted Answer

The Number Format box in the Number group on the Home tab allows users to change the format of dates, numbers, and other values in Excel without needing to re-enter the data manually or perform complex operations. Changing from Long Date to Short Date format can be easily done through this method.

Laura Has Been Entering Dates in Worksheets Using the Long