, EUP1501 Assignment 4
Semester 2 2025
DUE 19 September 2025
Use this document as a guide and for references to answer your assignment
Step-by-step Excel instructions — exact,
detailed, and in the order your lecturer expects
Follow these steps exactly in Excel (desktop). I include exact cells, the formulas to
type, menu/ribbon actions, and the expected numeric results so you can check your
work.
0) Setup — open workbook
1. Open Microsoft Excel and start a Blank workbook.
1) Enter headers and data (cells A1:H6)
Type the headers in row 1 (cells A1 → H1):
A1: No
B1: Drone Model
C1: Sales Region
D1: Units Sold
E1: Unit Price
F1: Total Revenue
G1: Profit Margin (%)
H1: Profit Amount
Now enter the data rows exactly as below (rows 2 → 6):
Row 2:
A2: 1
B2: HTC Vive Cosmos Elite
Semester 2 2025
DUE 19 September 2025
Use this document as a guide and for references to answer your assignment
Step-by-step Excel instructions — exact,
detailed, and in the order your lecturer expects
Follow these steps exactly in Excel (desktop). I include exact cells, the formulas to
type, menu/ribbon actions, and the expected numeric results so you can check your
work.
0) Setup — open workbook
1. Open Microsoft Excel and start a Blank workbook.
1) Enter headers and data (cells A1:H6)
Type the headers in row 1 (cells A1 → H1):
A1: No
B1: Drone Model
C1: Sales Region
D1: Units Sold
E1: Unit Price
F1: Total Revenue
G1: Profit Margin (%)
H1: Profit Amount
Now enter the data rows exactly as below (rows 2 → 6):
Row 2:
A2: 1
B2: HTC Vive Cosmos Elite