What is data formatting? What tools are used to format a data? Explain.

Data formatting means arranging or organising data into a specific structure so that it

becomes easy to read, understand, process and use

Tools used to format a data:

Number Formatting:

It includes adding percentage symbols, commas (,), decimal places etc., date, time, scientific

values and as well as some special formats to a spreadsheet

Currency:

If we enter a financial value complete with currency sign and two decimal places.

Percentage: :

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

sign without any decimal places, Excel assigns to the cells the percentage format that follows

this pattern along with the entry.

Dates: :

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

such as $\displaystyle 16$-$\displaystyle 04$-$\displaystyle 2025$ or $\displaystyle 16$-Apr-$\displaystyle 2025$, the program assigns a date format that follows the

pattern of the date.