What will be the output of the MS Excel 2007 date formula ‘=DATE(2020,8,31)’ if the selected date format is 'xx-xx-xxxx'?

Correct option is A

The DATE(2020,8,31) formula in MS Excel 2007 creates a date value for August 31, 2020. The formula takes three arguments:
· 2020: The year.
· 8: The month (August).
· 31: The day.
When the selected date format is 'xx-xx-xxxx' (which represents day-month-year in this case), Excel will display the date as 31-08-2020, which corresponds to the day-month-year format.
Important Key Points:
1. DATE Function: The DATE function in Excel creates a valid date using year, month, and day as its arguments.
2. Date Formatting: Excel allows you to customize the date format, and in this case, 'xx-xx-xxxx' displays the date in day-month-year format.
Knowledge Booster:
· Date Formatting in Excel: You can change the date format by going to the Format Cells dialog box, selecting Date, and choosing from a variety of date formats, including month-day-year or day-month-year.
· Excel Date Storage: Excel stores dates as serial numbers, but it displays them in the format specified by the user or the system settings.