Write and explain any three different types of number formats available in MS Excel?
Answers
Answer:
Explanation:
Format Description
Fixed Point Number with a fixed number of digits after the decimal point
Integer A whole number with no decimals shown
Date Show number (days since 1 Jan 1900) as a date and/or time (see below for format options)
Boolean Display 0 as False , and any other number as True
Answer:
Format
Description
General
The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way you type them. However, if the cell is not wide enough to show the entire number, the General format rounds the numbers with decimals. The General number format also uses scientific (exponential) notation for large numbers (12 or more digits).
Number
Used for the general display of numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.
Currency
Used for general monetary values and displays the default currency symbol with numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.