Class IX – Information Technology (Code 402)

Learning Outcomes

• Understand formulas and functions.
• Apply arithmetic operators.
• Use SUM(), AVERAGE(), MAX(), MIN() and COUNT().
• Create a student marksheet.
• Use AutoFill to copy formulas.

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

1. Every spreadsheet formula begins with:
   1. #
   2. =
   3. @
   4. $
2. Which function calculates the total?
   1. AVERAGE()
   2. MAX()
   3. SUM()
   4. COUNT()
3. Which function returns the highest value?
   1. MIN()
   2. SUM()
   3. MAX()
   4. COUNT()
4. Which function counts numeric values?
   1. COUNT()
   2. SUM()
   3. MAX()
   4. AVERAGE()
5. The small square used to copy formulas is called the:
   1. Name Box
   2. Formula Bar
   3. Fill Handle
   4. Status Bar

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

1. A predefined formula is called a __________________.
2. The __________________ function calculates the average.
3. The __________________ function finds the smallest value.
4. Every formula begins with the __________________ sign.
5. The __________________ feature copies formulas automatically.

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

1. Functions are predefined formulas. ________
2. SUM() finds the highest value. ________
3. MAX() returns the largest number. ________
4. AutoFill can copy formulas automatically. ________
5. COUNT() counts only numeric values. ________

Section D : Match the Following (5 Marks)

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

1. What is a formula?
2. What is a function?
3. Differentiate between a formula and a function.
4. Write the purpose of SUM(), MAX() and COUNT().
5. What is AutoFill? Why is it useful?

Section F : Practical Activity (10 Marks)

Enter the following data in LibreOffice Calc.

Tasks:

• Calculate Total using =SUM(B2:E2)
• Calculate Average using =AVERAGE(B2:E2)
• Find Highest Marks using =MAX(B2:E2)
• Find Lowest Marks using =MIN(B2:E2)
• Count the number of subjects using =COUNT(B2:E2)
• Copy formulas using AutoFill.
• Save the file as Student_Marksheet.ods.

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

1. Why is it better to use SUM() instead of typing =B2+C2+D2+E2?


2. If a student's marks change after correction, how does using formulas make updating the marksheet easier?

Section H : Activity

Create a spreadsheet showing the monthly expenditure of your family.

Calculate the total monthly expenditure using the SUM() function.

Teacher's Assessment

Self Reflection

Tick (✓) the statements that apply to you.

☐ I can write spreadsheet formulas.

☐ I can use SUM() and AVERAGE().

☐ I can use MAX(), MIN() and COUNT().

☐ I can use AutoFill correctly.

☐ I need more practice with spreadsheet functions.