It is important in terms of it correctly presenting the data you are showing. Particularly when it comes to numbers, it is important to know what the numbers represent. For example you may want to show a particular currency. You don't want the currency being shown as a different currecncy, or it being shown as an ordinary number.
The amount of decimal places shown is another important thing. For some kinds of things, where the values are always going to be whole numbers, there would be no need to show any decimal places. For other things you may want to show some. 2 decimal places is quite common, but you may want more than that for some values. Often you may want to use scientific notation.
Dates can actually be shown as numbers. Normally you would not want that to happen, so formatting is important there. The way you display dates is important, as you have to remember that different countries have dates displayed differently, often with the day and month swapped around. So if you have a date that is 02/05/09, in some countries it would be regarded as being the 2nd of May 2009, whereas in others it would be regarded as February the 5th 2009. So if it is likely that the data is going to be viewed in different countries, you may want to format the date to show the name of the month in it, which can be done. That will avoid confusion.
So there are lots of reasons for making sure the data in a spreadsheet is formatted correctly. It will make your use of the spreadsheet easier, and it will make it easier for others who see your work to interpret it correctly. That is very important.
It is not XML, Excel is a spreadsheet software. But you could save your worksheet as XML format as well as other formats like XLS, CSV, and many more.
An Excel worksheet or spreadsheet allows data to be easily summed and charted.
The way Microsoft designed Excel, the program has the ability to save files in HTML format. You just click the Save As option and select .html. MS Excel automatically creates the appropriate HTML code for you.
To use the entire box in Microsoft Excel 2007: click the Home tab, click Format in the Cells group and search for the current worksheet.
Create a blank worksheet.
The worksheet.
Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.
An Excel spreadsheet is referred to as a worksheet. A collection of worksheets is called a workbook.
Yes, a chart in Excel is created from data that has been selected in the worksheet.
A worksheet.
worksheet
worksheet