Computer Science, asked by Yashgupta3039, 11 months ago

The appearance of date and time on a worksheet depends on the dash applied to the cell

Answers

Answered by preetygirl97
29

Answer:

Although Excel always stores the serial number for dates and times, how a date displays in the worksheet depends on the format of its cell. ... Right click in the cell and select "Format Cells". On the Number tab, select Date or Time, and then choose one of the Types displayed in the right column.

Answered by gratefuljarette
7

The appearance of date and time on a worksheet depends on the format applied to the cell.

Explanation:

  • Excel stores date and time in the form of number which is called the date serial number. It is a regular number that has been formatted and looks like a date. Date serial number integer portion represents the day and the portion which is decimal represents the time.
  • Excel provides each date to a special numeric value. The date serial number column displays the date column value in their date serial equivalent. Time represents a decimal fraction. It follows at least h: m: m that is hour and minute.

Learn more about worksheet

How can you rename a worksheet? explain.

https://brainly.in/question/4801435

Can we print worksheet and related chart on same page

https://brainly.in/question/1565814

Similar questions