File Name

Subtotal_Practice.xlsx

Dataset

Order ID	City	Category	Product	Sales
O101	Hisar	Accessories	Mouse	5000
O102	Hisar	Hardware	Monitor	17000
O103	Hisar	Accessories	Webcam	10000
O104	Sirsa	Accessories	Keyboard	4000
O105	Sirsa	Hardware	Monitor	25500
O106	Sirsa	Hardware	Printer	12000
O107	Fatehabad	Accessories	Keyboard	4800
O108	Fatehabad	Hardware	Printer	24000
O109	Fatehabad	Accessories	Mouse	5500
O110	Sirsa	Accessories	Mouse	4000

Tasks

Task 1 — Sort

Sort the dataset by:

City → A to Z

Task 2 — City-wise Sum

Create Subtotal:

At each change in: City

Function: Sum

Add subtotal to: Sales

Task 3 — Average

Create a City-wise Average Sales report.

Task 4 — Count

Count the number of sales records for each city.

Task 5 — Maximum & Minimum

Find the highest and lowest sales in each city.

Task 6 — Outline

Use the outline buttons to display:

• Summary
• City details
• Complete records

Task 7 — Page Break

Enable:

Page break between groups

and review Print Preview.

Final Challenge

Create a Professional Regional Sales Subtotal Report containing:

City Summary

City	Total Sales	Average Sales	No. of Orders	Highest Sale	Lowest Sale
Fatehabad
Hisar
Sirsa

Then create an outline that allows the user to expand each city and view its individual transactions.