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
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
