Which option formats dates as Short Date in Excel?

Which option formats dates as Short Date in Excel?

• A. Long Date
• B. Custom
• C. Short Date
• D. Text

Answer: (C)

Excel uses built-in date formats to control how a date is displayed. The Short Date format shows a compact numeric representation of the date, like 12/31/2024, using separators and order based on your locale. This keeps the date as a real date value that you can still sort or perform calculations on. In contrast, Long Date displays the date in words (for example, December 31, 2024). The Custom option lets you define your own pattern (such as mm-dd-yyyy or dd/mm/yy), and Text converts the date to plain text, removing date recognition and arithmetic. So, when you want the date shown in the brief numeric form, you choose the Short Date option.

Excel uses built-in date formats to control how a date is displayed. The Short Date format shows a compact numeric representation of the date, like 12/31/2024, using separators and order based on your locale. This keeps the date as a real date value that you can still sort or perform calculations on. In contrast, Long Date displays the date in words (for example, December 31, 2024). The Custom option lets you define your own pattern (such as mm-dd-yyyy or dd/mm/yy), and Text converts the date to plain text, removing date recognition and arithmetic. So, when you want the date shown in the brief numeric form, you choose the Short Date option.