Question

How many data formats are available in excel name all of them?

Answer 1

Answer:there are 11 types of data formats which are available in excel. They are :

1. Number

2. Currency

3. Date and time

4. Percentage

5. Text formate

6. Label

7. Values

8. Formulas

9. General

10. Accounting

11. Fraction

Explanation:If you like my answer plzz mark aa brilliant

Answer 2

Answer:

there are 11 types of data formats available in excel. they are:

1. number- number is used generally for the display of numbers.
2. currency- this is used generally for monetary formats.
3. accounting- they line up the currency symbols and decimal points in a column.
4. date- they display date and time serial numbers as data values.
5. time- time formats display date and time serial numbers as date values.
6. percentage- they multiply 100 with the cel value and display it in the form of %.
7. fraction- they display the cell value in the form of fractions.
8. scientific- the cell values are displayed scientifically.
9. text - text format cells are treated as text even when the number is in the cell. the cell is displayed exactly as entered.
10. special - special formats are useful for tracking list and database values.
11. custom - type the number format code, using one of the existing codes as a starting point.