To pick the final cell on a worksheet or in an Excel list that contains data or formatting, press Ctrl+End.
Despite the fact that dates and times are actually recorded as a standard number called the date serial number, we may style dates and times in Excel in a variety of ways to show them exactly how we want.
To meet our demands, we can design our own unique date and time formats. Let's look at it. The cell(s) that contain the dates that you want to format are selected.
The Format Cells dialog box will appear after pressing CTRL+1 or right-clicking and selecting Format Cells. Choose "Date" from the list of categories on the Number tab. This opens the 'Type' list where you can choose from a list of default date formats. The Time category is the same.
To know more about Excel click here:
https://brainly.com/question/3441128
#SPJ4
