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.

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 quizzes

• Introduction to Electronic Spreadsheet
• Data Visualization

Browse all Electronic Spreadsheet quizzes