, EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester
2 2025 - DUE 19 September 2025; 100% correct solutions
and explanations.
📘 Detailed Step-by-Step Guide for MS Excel Assessment
Step 1: Creating the Dataset (The Foundation of Your Workbook)
Before doing any calculations, we first need to set up the data table properly.
This step is crucial because Excel works best when the data is structured clearly in
rows and columns.
Actions:
1. Open Microsoft Excel.
2. Go to File → New → Blank Workbook.
3. In the first row, starting from cell A1, type in the column headers exactly as
provided:
o No
o Drone Model
o Sales Region
o Units Sold
o Unit Price
o Total Revenue
o Profit Margin (%)
o Profit Amount
4. Underneath these headers, carefully type the data for each drone model,
ensuring accuracy. The table should look like this:
Profit
Sales Units Unit Total Profit
No Drone Model Margin
Region Sold Price Revenue Amount
(%)
HTC Vive North
1 500 1200 25
Cosmos Elite America
HTC Vive XR
2 Europe 300 800 30
Elite
3 Varjo Aero Asia 700 1000 28
2 2025 - DUE 19 September 2025; 100% correct solutions
and explanations.
📘 Detailed Step-by-Step Guide for MS Excel Assessment
Step 1: Creating the Dataset (The Foundation of Your Workbook)
Before doing any calculations, we first need to set up the data table properly.
This step is crucial because Excel works best when the data is structured clearly in
rows and columns.
Actions:
1. Open Microsoft Excel.
2. Go to File → New → Blank Workbook.
3. In the first row, starting from cell A1, type in the column headers exactly as
provided:
o No
o Drone Model
o Sales Region
o Units Sold
o Unit Price
o Total Revenue
o Profit Margin (%)
o Profit Amount
4. Underneath these headers, carefully type the data for each drone model,
ensuring accuracy. The table should look like this:
Profit
Sales Units Unit Total Profit
No Drone Model Margin
Region Sold Price Revenue Amount
(%)
HTC Vive North
1 500 1200 25
Cosmos Elite America
HTC Vive XR
2 Europe 300 800 30
Elite
3 Varjo Aero Asia 700 1000 28
