Functions in Spreadsheet Quiz - CBSE Class 11 ICT

Free practice quiz: Functions in Spreadsheet (CBSE Class 11 ICT). 19 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 11 ICT practice quiz has 19 multiple-choice questions on Functions in Spreadsheet, and 19 of them come with an explanation. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz online. No sign-up needed.

Sample questions

1. What is the purpose of the SUM function in a spreadsheet?

   1. To subtract numbers
   2. To multiply numbers
   3. To add numbers
   4. To divide numbers
   Show answer

   Answer: C. To add numbers

   The SUM function is used to calculate the total of a range of cells.

2. What function would you use to find the largest number in a range of cells?

   1. MIN
   2. AVERAGE
   3. MAX
   4. SUM
   Show answer

   Answer: C. MAX

   The MAX function returns the largest numeric value in a given range of cells.

3. What function would you use to find the smallest number in a range of cells?

   1. MAX
   2. AVERAGE
   3. MIN
   4. SUM
   Show answer

   Answer: C. MIN

   The MIN function returns the smallest numeric value in a range of cells.

4. What function is used to find the absolute value of a number?

   1. ABS
   2. SQRT
   3. POWER
   4. ROUND
   Show answer

   Answer: A. ABS

   The ABS function returns the absolute value (positive value) of a number.

5. What function would you use to determine the number of times a specific value appears in a range of cells?

   1. COUNTIF
   2. SUMIF
   3. AVERAGEIF
   4. VLOOKUP
   Show answer

   Answer: A. COUNTIF

   The COUNTIF function counts cells within a range that meet a given criterion.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which function calculates the average of a range of cells?
2. What does the COUNT function do?
3. How do you refer to a cell in a spreadsheet?
4. What is the result of the formula =SUM(A1:A5) if A1=10, A2=20, A3=30, A4=40, A5=50?
5. Explain the difference between the COUNT and COUNTA functions.
6. How would you use the IF function to display "Pass" if a student's score is greater than or equal to 50, and "Fail" otherwise?
7. What does the function =CONCATENATE(A1,B1) do if A1 = "Hello" and B1 = " World!"?
8. What is the purpose of the VLOOKUP function?
9. What function calculates the square root of a number?
10. Explain the difference between relative and absolute cell referencing.
11. How would you use the nested IF function to assign grades based on scores: A (90+), B (80-89), C (70-79), D (60-69), F (below 60)?
12. Describe a scenario where using the SUMIF function would be more efficient than using the SUM function alone.
13. Explain how to use the `INDEX` and `MATCH` functions together to achieve a lookup similar to `VLOOKUP`, but with more flexibility.
14. Create a formula to calculate the total cost of items based on quantity and price per item, using appropriate functions, handling potential errors (e.g., if quantity or price is not a number).

More quizzes

• Introduction to Electronic Spreadsheet▶ Play
• Data Visualization▶ Play

Browse all Electronic Spreadsheet quizzes

More to play