Description
EUP1501 Assignment 4 2025
EUP1501
Semester 2 2025
Formative Assessment 4
Total Grade: 45
This practical assessment is designed to evaluate students’ proficiency in Microsoft Excel by testing their ability to apply key functions, formulas, and data analysis tools to solve real-world problems and manage datasets effectively.
Read the instructions carefully.
Ms Excel (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 Region | Units Sold | Unit Price | Total Revenue | Profit Margin (%) | Profit Amount |
| 1 | HTC Vive Cosmos Elite | North America | 500 | 1200 | 25 | ||
| 2 | HTC Vive XR Elite | Europe | 300 | 800 | 30 | ||
| 3 | Varjo Aero | Asia | 700 | 1000 | 28 | ||
| 4 | Skydio 2 | South America | 250 | 1500 | 32 | ||
| 5 | Pimax 8K X | Africa | 180 | 1100 | 27 | ||
| 6 | Sum | ||||||
| 7 | Average | ||||||
| 8 | Max | ||||||
| 9 | Min |
Tasks:
- Apply bold headers and change the font size to 12pt. [2]
- Calculate Total Revenue for all drone models using the formula
Reviews
There are no reviews yet.