Class IX – Information Technology (Code 402)

Learning Outcomes

• Understand the concept of an electronic spreadsheet.
• Identify workbook, worksheet, rows, columns and cells.
• Recognize cell references.
• Create and save a spreadsheet.

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

1. Which of the following is a spreadsheet software?
   1. Paint
   2. LibreOffice Calc
   3. Notepad
   4. VLC Media Player
2. A worksheet consists of:
   1. Slides
   2. Rows and Columns
   3. Pages
   4. Frames
3. The intersection of a row and a column is called a:
   1. Workbook
   2. Cell
   3. Sheet
   4. Formula
4. Which bar displays the address of the active cell?
   1. Status Bar
   2. Name Box
   3. Menu Bar
   4. Scroll Bar
5. Which option is used to save a spreadsheet?
   1. Insert
   2. Edit
   3. File → Save
   4. View

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

1. A spreadsheet is made up of rows and __________________.
2. A __________________ contains one or more worksheets.
3. The address of a cell is called a __________________.
4. Rows are identified using __________________.
5. Columns are identified using __________________.

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

1. A workbook contains one worksheet only. ________
2. Cells are formed at the intersection of rows and columns. ________
3. LibreOffice Calc is a spreadsheet application. ________
4. Column labels are numbers. ________
5. You should save your work regularly. ________

Section D : Match the Following (5 Marks)

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

1. What is an electronic spreadsheet?


2. Differentiate between a workbook and a worksheet.


3. What is a cell?


4. What is a cell reference? Give two examples.


5. Write any four applications of spreadsheets.

Section F : Practical Activity (10 Marks)

Create the following spreadsheet using LibreOffice Calc.

Save the file as Student_Information.ods.

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

1. Why is it better to maintain students' records in a spreadsheet instead of writing them in a notebook?


2. A teacher wants to maintain the attendance records of 500 students. Explain why a spreadsheet is a better choice.

Section H : Activity

Create a spreadsheet containing the details of five members of your family using the following headings:

Teacher's Assessment

Self Reflection

Tick (✓) the statements that apply to you.

☐ I can identify rows and columns.

☐ I can identify cell references.

☐ I can create a spreadsheet.

☐ I can save a spreadsheet correctly.

☐ I need more practice.