163k views
0 votes
Halley's Comet Worksheet, Change the formatting of cell C3 to display the date 07-28-2061.

a. Format > Date > 07-28-2061

b. Format > Custom > dd-mm-yyyy

c. Format > Date > 28-07-2061

d. Format > Custom > mm-dd-yyyy

1 Answer

4 votes

Final answer:

To display the date 07-28-2061 in a spreadsheet cell, use the custom format option b. Format > Custom > mm-dd-yyyy.

Step-by-step explanation:

The correct option for changing the formatting of cell C3 to display the date 07-28-2061 in a spreadsheet is b. Format > Custom > mm-dd-yyyy. This custom format allows you to specify exactly how the date should be displayed, with 'mm' representing the month, 'dd' representing the day, and 'yyyy' representing the four-digit year. Therefore, the date '07-28-2061' will be formatted with the month first, followed by the day, and then the year.

To change the formatting of cell C3 to display the date 07-28-2061, you would choose option b. Format > Custom > dd-mm-yyyy. This option allows you to customize the date format to show the day, month, and year in the desired order. By selecting this option, you can input the date as 07-28-2061 and the cell will display it accordingly.

User Dnsko
by
7.1k points