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

use………………………….….…….2

becomes easy to read, understand, process and

Tools used to format a data:

Number Formatting:…………………………………………………………….. ½

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

spreadsheet……………………….….½

values and as well as some special formats to a

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. …………………………………………………..………………….½