Explain - 'Number formatting', 'Percentages' and 'Dates' as data formatting tools.

Number formatting

Number formatting includes adding percent symbols (%), commas(,), decimal places,

and currency sign ($,<etc.), date, time, scientific values and as well as some special

formats to a spreadsheet. The type of number format can be determined once the data

is entered into the cell.

Percentages

If we enter a value representing a percentage as a whole number followed by

percentage sign without any decimal places. Excel assigns to the cell the

percentage format that follows this pattern along with the entry.

Dates

If we enter a date (dates are values, too) that follows one of the built-in Excel

th number formats, such as $\displaystyle 26$-$\displaystyle 04$-$\displaystyle 2021$ or $\displaystyle 26$ April – $\displaystyle 2021$ the program assigns a

Date format that follows the pattern of the date.