Question

A date has been entered in a worksheet cell"e5". What number format you will apply to display the date in the given format

Answer 1

ms excel.
i

have

proud

Answer 2

Answer:

Short Date and Long Date number format you will apply to display the date in the given format

Explanation:

Excel stores dates as sequential numbers and it is only a cell's formatting that causes a number to be displayed as a date, time, or date and time.

Dates in Excel

All dates are stored as integers representing the number of days since January 1, 1900, which is stored as number 1, to December 31, 9999 stored as 2958465.

In this system:

2 is 2-Jan-1900

3 is 3-Jan-1900

42005 is 1-Jan-2015 (because it is 42,005 days after January 1, 1900)

• Dates are whole numbers
• Usually, when you insert a date in a cell it is displayed in the format dd/mm/yyyy.
• Now if you change the cell's format to Standard, the cell displays 42370.
• Dates can be displayed in different ways using the following 2 options (available in the Number Format dropdown in the main menu):
• Short Date
• Long Date

Learn more about date

https://brainly.in/question/43173204?referrer=searchResults

https://brainly.in/question/9182716?referrer=searchResults