Question

Why is text formatting necessary in a spreadsheet ? Mention any two ways of formatting content in a spreadsheet.

Hint:

Formatting changes how data looks, not the data. Think of font changes and cell changes.

Answer 1

Step 1: Understand text formatting:
Text formatting means changing how the data in a spreadsheet looks, without changing the data itself. It covers font, colour, alignment, borders and number style.

Step 2: Why formatting is necessary:
1. It makes the data easy to read and understand.
2. It highlights important figures such as totals or headings.
3. It gives the sheet a neat and professional look, so it can be printed or shared.
4. It helps the reader compare values and find errors quickly.

Step 3: Two ways of formatting content:
1. Font formatting: use bold, italic or underline, and change the font style, size or colour of the text.
2. Cell formatting: apply borders, background colour, text alignment (left, centre, right) or a number format such as currency or percentage.

Final Answer:
Formatting makes a spreadsheet clear, neat and easy to read. Two ways are font formatting (bold, size, colour) and cell formatting (borders, shading, alignment).