Retail Store Sales Tracker — FreshMart

FreshMart, a grocery retail chain, needs a junior data analyst to clean raw March sales data, compute business metrics, and build a visual summary for the weekly review. Students independently set up a structured dataset, apply ARRAYFORMULA, classify orders with nested IF logic, and present findings through a professional chart.

CONTEXT: FreshMart tracks daily sales across 15+ products. The store manager wants total revenue, order classification, and a category-wise chart for the weekly review meeting.

TASK 1 — DATASET: Create a 15-row table in tab 'Day1' with columns: Order ID, Product Name, Category (Grains/Oils/Dairy/Snacks), Qty Sold, Unit Price, Total Sale, Date of Sale (March 2025).

TASK 2 — ARRAYFORMULA: In column F, write a single =ARRAYFORMULA(D2:D*E2:E) to calculate Total Sale for all rows. No dragging allowed.

TASK 3 — SUMMARY METRICS: In cells I1:J6, calculate Total Revenue (SUM), Highest Single Sale (MAX), Lowest Single Sale (MIN), Average Order Value (AVERAGE), Orders above ₹1000 (COUNTIF), distinct category count.

TASK 4 — ORDER CLASSIFICATION: Column H — nested IF: 'High Value' if Total Sale > ₹1000, 'Medium' if ₹500-₹1000, 'Low' otherwise. Apply as ARRAYFORMULA.

TASK 5 — FORMATTING: Freeze row 1, bold headers, blue header background + white font, alternating row shading, currency columns formatted as ₹ Indian Rupee.

TASK 6 — CHART: Column chart showing Total Sales by Category. Add chart title 'March Sales by Category', label axes, apply clean colour theme.

BONUS: Add SPARKLINE in column I for each product using 3 weeks of dummy weekly sales in columns K, L, M.