Class IX – Information Technology (Code 402)

Learning Outcomes

• Apply formatting to spreadsheet data.
• Change font style, size and colour.
• Apply alignment and borders.
• Adjust row height and column width.
• Use Merge Cells and Wrap Text.
• Apply number formatting.

Section A : Multiple Choice Questions (1 × 5 = 5 Marks)

1. Which option is used to combine multiple cells into one?
   1. AutoFill
   2. Merge Cells
   3. Wrap Text
   4. Sort
2. Which formatting option displays long text on multiple lines within a cell?
   1. Merge Cells
   2. Bold
   3. Wrap Text
   4. AutoSum
3. Which formatting is commonly used for monetary values?
   1. Date
   2. Percentage
   3. Currency
   4. Time
4. Which feature automatically adjusts the width of a column?
   1. AutoFit
   2. Merge
   3. Fill Handle
   4. Alignment
5. Which formatting tool makes text darker?
   1. Italic
   2. Underline
   3. Bold
   4. Strikeout

Section B : Fill in the Blanks (1 × 5 = 5 Marks)

1. __________________ improves the appearance of a worksheet.
2. The __________________ option combines several cells into one.
3. The __________________ option adjusts long text within a cell.
4. __________________ formatting is used to display money values.
5. __________________ separates data clearly in a worksheet.

Section C : True or False (1 × 5 = 5 Marks)

1. Formatting improves readability. ________
2. Merge Cells is generally used for worksheet titles. ________
3. Wrap Text deletes extra text from a cell. ________
4. Borders help organize data. ________
5. Column width cannot be changed. ________

Section D : Match the Following (5 Marks)

Section E : Short Answer Questions (2 × 5 = 10 Marks)

1. Why is formatting important in a spreadsheet?
2. What is the purpose of Merge Cells?
3. Explain Wrap Text with an example.
4. Differentiate between row height and column width.
5. Name any four formatting features available in LibreOffice Calc.

Section F : Practical Activity (10 Marks)

Create the following worksheet.

Tasks:

• Merge and centre the worksheet title.
• Apply bold formatting to headings.
• Increase heading font size.
• Apply background colour to headings.
• Centre-align all marks.
• Apply borders to the table.
• Adjust row height and column width.
• Format the Average column to two decimal places.
• Save the file as Formatted_Marksheet.ods.

Section G : HOTS (Higher Order Thinking Skills) (5 Marks)

1. Why should headings be formatted differently from the data in a worksheet?


2. A spreadsheet contains a large amount of data. Explain how formatting helps users read and understand the information more easily.

Section H : Activity

Create a monthly electricity bill worksheet using the following headings:

Format the worksheet professionally using colours, borders, alignment and currency format.

Teacher's Assessment

Self Reflection

Tick (✓) the statements that apply to you.

☐ I can format worksheet headings.

☐ I can apply borders and colours.

☐ I can merge and centre cells.

☐ I can adjust row height and column width.

☐ I need more practice with worksheet formatting.