EUP1501 asssesmment 4 semester 2 2025..

THE BMZ ACADEMY




THE BMZ ACADEMY




053 8213




BMZ ACADEMY 061 262 1185/068 053 8213Page 1 of 6

, THE BMZ ACADEMY

EUP1501

Semester 2 2025

Formative Assessment 4

Total Grade: 45

Open a blank spreadsheet. Create the VR Headset Sales Dataset using the data provided below, and
complete the tasks: [5]

No Drone Model Sales Units Unit Price Total Profit Margin Profit
Region Sold Revenue (%) Amount
1 HTC Vive North 500 1200 25
Cosmos Elite America
2 HTC Vive XR Europe 300 800 30
Elite
3 Varjo Aero Asia 700 1000 28
4 Skydio 2 South 250 1500 32
America
5 Pimax 8K X Africa 180 1100 27
6 Sum
7 Average
8 Max
9 Min


Tasks:

1. Apply bold headers and change the font size to 12pt. [2]
2. Calculate Total Revenue for all drone models using the formula
• Total Revenue = Units Sold × Unit Price [5]
3. Calculate the Profit Amount for all drone models using the formula:
• Profit Amount = (Profit Margin / 100) × Total Revenue [5]
4. Format all currency values (Unit Price, Total Revenue, Profit Amount) as currency
(Use Rands, 2 decimal places). [5]
5. Apply conditional formatting to highlight sales regions where revenue exceeds
R50,000.00.
[4]
6. Adjust column width to ensure data visibility.
7. Apply SUM, AVERAGE, MAX, and MIN functions for Total Revenue and Profit Amount. [8]




2|Page BMZ ACADEMY 061 262 1185/068 053 8213