Basic Statistical Functions Practice in Excel Questions with Solutions

Introduction

Excel functions make it easier to summarize and analyze large amounts of data. In this chapter, you will practice SUM, AVERAGE, MIN, MAX, and COUNT using different real-world datasets. Each question focuses on a different use case so you can check whether you understand when and how to use these functions. These exercises are suitable for learners who already know basic Excel formulas and want more practical practice. Basic Statistical Functions Practice in Excel questions with solutions to help you understand the concepts.

Question 1: Calculate Total Monthly Sales

Problem Statement

A shop records its sales for six months. Calculate the total sales using the SUM function.

Excel Data

Solution

In cell B8, enter:

=SUM(B2:B7)

Expected Output

Total Sales = 328000

Question 2: Calculate Average Student Marks

Problem Statement

A teacher has recorded the marks of eight students. Calculate the average marks using the AVERAGE function.

Excel Data

Solution

In cell B10, enter:

=AVERAGE(B2:B9)

Expected Output

Average Marks = 80.75

Question 3: Find the Highest and Lowest Product Price

Problem Statement

A store has several products. Find the highest price and lowest price using MAX and MIN.

Excel Data

Solution

To find the highest price, enter:

=MAX(B2:B7)

To find the lowest price, enter:

=MIN(B2:B7)

Expected Output

Highest Price = ₹55,000

Lowest Price = ₹550

Question 4: Analyze Employee Salaries

Problem Statement

An organization wants to analyze employee salaries. Calculate:

• Total salary
• Average salary
• Highest salary
• Lowest salary

Excel Data

Solution

Total Salary

=SUM(B2:B7)

Average Salary

=AVERAGE(B2:B7)

Highest Salary

=MAX(B2:B7)

Lowest Salary

=MIN(B2:B7)

Expected Output

Question 5: Count the Number of Students with Marks

Problem Statement

A school has a list containing student names and marks. Use the COUNT function to determine how many students have numeric marks entered.

Excel Data

Solution

In the result cell, enter:

=COUNT(B2:B9)

Expected Output

Number of students with marks = 7

COUNT counts cells containing numbers. The blank cell is not counted.

Question 6: Analyze Monthly Website Visitors

Problem Statement

A website owner records visitors for seven months. Calculate the total visitors, average visitors, highest monthly visitors and lowest monthly visitors.

Excel Data

Solution

Total Visitors

=SUM(B2:B8)

Average Visitors

=AVERAGE(B2:B8)

Highest Visitors

=MAX(B2:B8)

Lowest Visitors

=MIN(B2:B8)

Expected Output

Question 7: Calculate Sales Performance for Multiple Products

Problem Statement

A salesperson has sold different products. Calculate the total quantity sold, average quantity, highest quantity and lowest quantity.

Excel Data

Solution

Total Quantity

=SUM(B2:B8)

Average Quantity

=AVERAGE(B2:B8)

Highest Quantity

=MAX(B2:B8)

Lowest Quantity

=MIN(B2:B8)

Expected Output

Question 8: Analyze Exam Scores from Multiple Subjects

Problem Statement

A student has received marks in six subjects. Calculate the total marks, average marks, highest subject score and lowest subject score.

Excel Data

Solution

Total Marks

=SUM(B2:B7)

Average Marks

=AVERAGE(B2:B7)

Highest Marks

=MAX(B2:B7)

Lowest Marks

=MIN(B2:B7)

Expected Output

Question 9: Analyze a Sales Dataset with Blank Cells

Problem Statement

A sales report contains some blank cells because sales data was not recorded for certain days. Calculate:

• Total recorded sales
• Average recorded sales
• Highest recorded sale
• Lowest recorded sale
• Number of days with recorded sales

Excel Data

Solution

Total Sales

=SUM(B2:B8)

Average Sales

=AVERAGE(B2:B8)

Highest Sale

=MAX(B2:B8)

Lowest Sale

=MIN(B2:B8)

Number of Recorded Sales

=COUNT(B2:B8)

Expected Output

The blank cells are ignored by these functions.

Question 10: Create a Performance Summary

Problem Statement

You are given the quarterly sales of five employees. Create a summary showing total sales, average sales, highest quarterly sale and lowest quarterly sale.

Excel Data

For each employee, calculate:

• Total Annual Sales
• Average Quarterly Sales
• Highest Quarterly Sale
• Lowest Quarterly Sale

Solution

Add four columns after Q4:

For Rahul in row 2:

Total Sales

=SUM(B2:E2)

Average Quarterly Sales

=AVERAGE(B2:E2)

Highest Quarterly Sale

=MAX(B2:E2)

Lowest Quarterly Sale

=MIN(B2:E2)

Copy all four formulas down for the remaining employees.

Expected Output

This question combines all five functions in a practical reporting task.

Key Takeaways

• SUM adds numeric values.
• AVERAGE calculates the arithmetic mean of numeric values.
• MIN returns the smallest numeric value.
• MAX returns the largest numeric value.
• COUNT counts cells containing numbers.
• These functions can work with a range such as B2:B10.
• Blank cells are generally ignored by SUM, AVERAGE, MIN, MAX, and COUNT.
• You can use these functions across rows as well as columns.
• Multiple functions can be combined to create a useful summary report.
• These basic functions are frequently used before moving to conditional functions such as COUNTIF, SUMIF, and AVERAGEIF.

FAQs

1. What is the SUM function in Excel?

The SUM function adds numbers from individual cells or a range of cells.

=SUM(B2:B10)

2. What does the AVERAGE function do in Excel?

AVERAGE calculates the arithmetic mean of the numeric values in the selected range.

=AVERAGE(B2:B10)

3. What is the difference between MIN and MAX?

MIN returns the smallest number in a range, while MAX returns the largest number.

4. What does COUNT do in Excel?

COUNT counts the number of cells containing numeric values in a selected range.

5. Does COUNT count text?

No. COUNT counts numeric values. Text entries are not included.

6. Do blank cells affect the AVERAGE function?

Blank cells within the referenced range are ignored by AVERAGE, so they do not count as zero.

7. Can I use SUM and AVERAGE across rows?

Yes. For example:

=SUM(B2:E2)

calculates the total across a row, while:

=AVERAGE(B2:E2)

calculates its average.

8. Can these functions be used with an Excel Table?

Yes. SUM, AVERAGE, MIN, MAX, and COUNT can be used with normal cell references as well as Excel Table data.

9. What happens if a range contains text and numbers?

Functions such as SUM, AVERAGE, MIN, MAX, and COUNT generally ignore text values that are stored directly in the referenced range.

10. Why should I learn these functions before COUNTIF and SUMIF?

These functions provide the foundation for Excel data analysis. Once you understand how to summarize an entire range, conditional functions such as COUNTIF and SUMIF become easier to understand.

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Rishabh Kumar