ask me plz...
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
a serial value to the date
numerical
Format / Cells / Date
date
You do not. Excel does not record the change date of an individual cell.
The amount of formulas that can be done in Excel is infinite.
Formatting. There are many ways of formatting dates in Excel.
A date series is used to fill a series with dates. The date can be increased by either a day, a week, a month or a year each time. This is one of the Fill Series options Excel provides.
Double click on the Date column header.
It gives you the number of the month from a date.
When reporting data or to get a better idea of what direction your company is heading, a graph is the easiest way to get a quick understanding of the data in front of you. Create a graph onto your Excel spreadsheet using three data sources, the date, total amount due, and total amount due greater than 60 days.