AVERAGE function in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to know the average sales amount per store for the last month.

📊 Data: You have a table listing each store's name and their total sales amount for the last month.

🎯 Deliverable: Create a summary that shows the average sales amount across all stores.

Sample Data

Store	Sales Amount
Store A	1200
Store B	1500
Store C	1100
Store D	1300
Store E	1400
Store F	1250
Store G	1350
Store H	1450

1

Step 1: Select a blank cell where you want to show the average sales amount.

Expected Result

The cell is ready to enter a formula.

2

Step 2: Type the formula to calculate the average of the sales amounts from all stores.

=AVERAGE(B2:B9)

Expected Result

The formula calculates the average sales amount from cells B2 to B9.

3

Step 3: Press Enter to see the result of the average sales amount.

Expected Result

The cell shows 1318.75, which is the average sales amount of all stores.

Final Result

Average Sales Amount
--------------------
       1318.75

✓The average sales amount per store last month was $1318.75.

✓This helps the manager understand the typical store performance.

Bonus Challenge

Calculate the average sales amount only for stores with sales above $1300.

Show Hint

Use the AVERAGEIF function with a condition like ">1300" on the sales amount range.