Practice Commonly Used Functions - 2 | Chapter 2: Spreadsheet – Functions and Charts | ICSE Class 8 Computer Applications
K12 Students

Academics

AI-Powered learning for Grades 8–12, aligned with major Indian and international curricula.

Professionals

Professional Courses

Industry-relevant training in Business, Technology, and Design to help professionals and graduates upskill for real-world careers.

Games

Interactive Games

Fun, engaging games to boost memory, math fluency, typing speed, and English skills—perfect for learners of all ages.

Practice Questions

Test your understanding with targeted questions related to the topic.

Question 1

Easy

What does the SUM function do?

💡 Hint: Remember that it's about addition.

Question 2

Easy

How do you write the AVERAGE function for cells B1 to B5?

💡 Hint: Think of how you find an average in any math problem.

Practice 4 more questions and get performance evaluation

Interactive Quizzes

Engage in quick quizzes to reinforce what you've learned and check your comprehension.

Question 1

What does the SUM function do?

  • Adds values
  • Finds average
  • Counts entries
  • Checks conditions

💡 Hint: Think of it as addition in math.

Question 2

True or False: MIN returns the largest value in a set.

  • True
  • False

💡 Hint: Consider what 'minimum' means.

Solve 2 more questions and get performance evaluation

Challenge Problems

Push your limits with challenges.

Question 1

You have a list of sales in cells A1 to A15. Write a formula using SUM to find the total sales.

💡 Hint: Remember, you're adding values together!

Question 2

Using data in cells B1 to B10, write a formula using COUNT to find how many of these entries are numeric.

💡 Hint: This function is focused on counting numbers specifically.

Challenge and get performance evaluation