This lesson combines all 12 functions.

Project 1 — Student Marks Sheet

Columns:

Student | English | Maths | Science | Total | Average | Highest | Lowest

Use:

  • SUM
  • AVERAGE
  • MAX
  • MIN
  • ROUND

Project 2 — Monthly Expense Sheet

Columns:

Date | Category | Description | Amount

Calculate:

  • Total Expense → SUM
  • Average Expense → AVERAGE
  • Highest Expense → MAX
  • Lowest Expense → MIN
  • Number of Expenses → COUNT

Project 3 — Salary Calculation

Columns:

Employee | Basic Salary | Allowance | Deduction | Net Salary

Calculate:

Net Salary = Basic + Allowance − Deduction

Then use:

  • SUM
  • AVERAGE
  • MIN
  • MAX
  • ROUND

Project 4 — Sales Calculation

Columns:

Product | Quantity | Price | Total Sales

Use:

=PRODUCT(B2,C2)

Then calculate:

  • Total Sales
  • Average Sales
  • Highest Sales
  • Lowest Sales

Use SUBTOTAL after applying filters.

Project 5 — Monthly Budget

Columns:

Category | Budget | Actual Expense | Difference

Example categories:

  • Food
  • Electricity
  • Education
  • Transport
  • Shopping
  • Internet

Calculate:

  • Total Budget
  • Total Expense
  • Average Expense
  • Highest Expense
  • Lowest Expense
  • Difference
PreviousNext