Practice AVERAGE - 2.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 is the syntax for the AVERAGE function?

💡 Hint: Think about how functions are usually written in spreadsheets.

Question 2

Easy

What would =AVERAGE(C1:C5) calculate?

💡 Hint: Remember, 'C1:C5' refers to all cells in that range.

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 AVERAGE function calculate?

  • Sum of numbers
  • Arithmetic mean
  • Median
  • Mode

💡 Hint: Think about what 'average' usually means in statistics.

Question 2

True or False: The AVERAGE function considers blank cells in calculations.

  • True
  • False

💡 Hint: Consider how averages are calculated only from the numbers present.

Solve 1 more question and get performance evaluation

Challenge Problems

Push your limits with challenges.

Question 1

You have the following numbers in a dataset: 5, 10, 15, 20, 1, and 50. Calculate the average, discuss how the number 50 affects the average.

💡 Hint: Consider what happens when you remove outliers.

Question 2

In a survey, the following ratings were received: 1, 4, 4, 4, 5, 2, 3. What does the average indicate about satisfaction levels?

💡 Hint: Sum all scores and divide by how many were given.

Challenge and get performance evaluation