Question

Explain any 5 data formats available in excel

Answer 1

$\huge{\underline{\mathtt{\red{A}\pink{N}\green{S}\blue{W}\purple{E}\orange{R}}}}$

accounting- they line up the currency symbols and decimal points in a column. date- they display date and time serial numbers as data values. time- time formats display date and time serial numbers as date values. percentage- they multiply 100 with the cel value and display it in the form of %.

Answer 2

l

$\huge{\underline{\mathtt{\red{A}\pink{N}\green{S}\blue{W}\purple{E}\orange{R}}}}$

accounting- they line up the currency symbols and decimal points in a column. date- they display date and time serial numbers as data values. time- time formats display date and time serial numbers as date values. percentage- they multiply 100 with the cel value and display it in the form of %.