Question

What is formatting in spreadsheets ? Give any two examples.

Hint:

Formatting changes how data looks, not what it says. Name two such tools, like bold or number format.

Answer 1

Step 1: Meaning of formatting:
Formatting in a spreadsheet means changing how the data looks, without changing the data itself.
It makes the sheet neat, easy to read and ready to print.

Step 2: What formatting can change:
It can change the font, size and colour of text, the cell colour, borders, alignment and the way numbers are shown.
The values stored in the cells stay the same.

Step 3: Two examples:
1. Bold and font colour: the heading row is made bold and coloured so it stands out.
2. Number format: 5000 can be shown as Rs. 5,000.00 (currency) or 0.25 as 25% (percentage).

Final Answer:
Formatting is the process of changing the appearance of data in a spreadsheet. Examples: making text bold and applying currency format to numbers.