answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Is Excel and AN XML?

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.


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.


What allows you to save worksheet in HTML format in excel?

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.


How do you use the entire box in Microsoft Excel 2007?

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.


What is the new of a new worksheet in Excel?

Create a blank worksheet.


What Portion of the Excel screen containing the gridlines is called?

The worksheet.


What cell does formulas and functions in Excel make use of?

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.


What is a spreadsheet referred to in Excel?

An Excel spreadsheet is referred to as a worksheet. A collection of worksheets is called a workbook.


Is Excel chart created from selected worksheet data?

Yes, a chart in Excel is created from data that has been selected in the worksheet.


What is the name of a page on Excel?

A worksheet.


What is like a notebook in excel?

worksheet


Is in excel like a notebook?

worksheet