Project: Sales, Inventory & Calculation Workbook

Part A — Product Sales

Product	Quantity	Price	Total
Keyboard	10	800
Mouse	20	500
Monitor	5	8500
Printer	3	12000
Webcam	8	2500

Calculate:

Total per product

=B2*C2

Grand Total

=SUM(D2:D6)

Grand Total using SUMPRODUCT

=SUMPRODUCT(B2:B6,C2:C6)

Part B — Rounding Analysis

Calculate:

• Original amount
• Rounded amount
• Rounded up
• Rounded down
• Integer value

Use:

=ROUND()

=ROUNDUP()

=ROUNDDOWN()

=INT()

Part C — Random Data Generator

Generate:

• Random marks
• Random quantities
• Random employee numbers

Use:

=RANDBETWEEN(1,100)

Part D — Trigonometry Calculator

Create:

Angle	SIN	COS	TAN
30°
45°
60°

Final Challenge

Create a professional Math & Calculation Workbook containing:

• Sales calculation
• Inventory valuation
• Rounding analysis
• Random data generator
• Mathematical calculations
• Trigonometry calculator