Question

What is the need of using different number formats

Answer 1

What are number formats?

Whenever you're working with a spreadsheet, it's a good idea to use appropriate number formats for your data. Number formats tell your spreadsheet exactly what type of data you're using, such as percentages (%), currency ($), times, dates, and so on.


Why use number formats?

Number formats don't just make your spreadsheet easier to read—they also make it easier to use. When you apply a number format, you're telling your spreadsheet exactly what kinds of values are stored in a cell. For example, the date format tells the spreadsheet that you're enteringspecific calendar dates. This allows the spreadsheet to better understand your data, which can help ensure that your data remains consistent and that your formulas are calculated correctly.

Applying number formats

Just like other types of formatting, such as changing the font color, you'll apply number formats by selecting cells and then choosing the desired formatting option. Every spreadsheet program allows you to add number formatting, but the process will vary depending on which application you're using:

Using number formats correctly

There's more to number formatting than selecting cells and applying a format. Spreadsheets can actually apply a lot of number formattingautomatically based on the way you enter data. This means you'll need to enter data in a way the program can understand, and then ensure that those cells are using the proper number format. For example, the image below shows how to use number formats correctly for dates, percentages, and times:

Hope It is similar to your question
if you like it please mark as brainlist