Class IX – Information Technology (Code 402)

Learning Outcomes

• Understand cell references.
• Differentiate between Relative, Absolute and Mixed References.
• Apply references correctly in formulas.
• Use AutoFill with different reference types.
• Develop accurate spreadsheet calculations.

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

1. Which type of reference changes automatically when copied?
   1. Absolute Reference
   2. Relative Reference
   3. Mixed Reference
   4. Fixed Reference
2. Which of the following is an absolute reference?
   1. A1
   2. $A$1
   3. A$1
   4. $A1
3. Which symbol is used to lock a row or column?
   1. #
   2. @
   3. $
   4. %
4. Which reference keeps only the row fixed?
   1. A1
   2. $A1
   3. A$1
   4. $A$1
5. Which feature copies formulas to adjacent cells?
   1. Wrap Text
   2. Fill Handle
   3. Merge Cells
   4. Chart Wizard

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

1. A __________________ is the address of a cell used in a formula.
2. The reference $A$1 is a __________________ reference.
3. The reference A1 is a __________________ reference.
4. The symbol used in absolute references is __________________.
5. The __________________ copies formulas automatically to neighbouring cells.

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

1. Relative references remain fixed when copied. ________
2. Absolute references always point to the same cell. ________
3. Mixed references fix either the row or the column. ________
4. $A1 fixes both the row and the column. ________
5. AutoFill is useful for copying formulas. ________

Section D : Match the Following (5 Marks)

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

1. What is a cell reference?
2. Differentiate between Relative and Absolute References.
3. What is a Mixed Reference? Give one example.
4. Why is absolute referencing useful?
5. Explain the purpose of the Fill Handle.

Section F : Practical Activity (10 Marks)

Create the following worksheet.

Tasks:

• Store the GST rate in a separate cell (for example, F1).
• Use an Absolute Reference ($F$1) to calculate GST.
• Copy the formula using the Fill Handle.
• Observe how the references change.
• Save the file as GST_Calculator.ods.

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

1. Why should the GST rate be stored in a separate cell instead of typing 18% in every formula?


2. A company changes its GST rate from 18% to 12%. Explain how using an absolute reference makes updating the worksheet easier.

Section H : Activity

Create a salary sheet using the following headings:

Use an Absolute Reference for the Bonus Rate and copy the formula for all employees.

Teacher's Assessment

Self Reflection

Tick (✓) the statements that apply to you.

☐ I can identify Relative References.

☐ I can use Absolute References.

☐ I can understand Mixed References.

☐ I can copy formulas using the Fill Handle.

☐ I need more practice with cell referencing.