How many data formats are available in Excel? Name some of them.

Asked 25-Mar-2022
Viewed 603 times

0

1 Answer


0

How many data formats are available in Excel? Name some of them.
  • Microsoft Excel supports eleven different data formats for data storage. Example:
  • Number — This type of data is saved as a number.
  • Currency - Stores information in the form of money.
  • Date - Dates are used to store data.
  • Percentage — This type of data is stored as a percentage.
  • Text Formats — Saves information as a string of characters.
  • Existing Excel workbook or worksheet with the.xls extension.
  • Existing Excel workbook or worksheet with the.xlsx extension.
  • Text file with the extension.csv that contains comma-separated values.
  • Text file, usually with the extension.txt or.asc.
  • This is the most popular and default form of extension in Microsoft Office spreadsheets.


Read More: What does a red triangle at the top right of a cell indicate in excel?