, EUP1501 Assignment 4 (COMPLETE ANSWERS)
Semester 2 2025 - DUE 19 September 2025 ; 100%
TRUSTED Complete, trusted solutions and
explanations.
Start Guide for MS Excel Assessment
Open a new blank workbook in Microsoft Excel.
Save early: File → Save As → choose folder → name the file
Surname-StudentNumber.xlsx (example if your surname is
Brown and student number is 2324567: Brown-
2324567.xlsx).
(Note: the question also shows the example 2324567_Brown; if
your instructor wants that format use it instead.)
Do not convert the file to PDF.
1) Enter the headers and dataset (exact cells)
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 5 data rows (cells A2 → H6). Put numbers exactly as
below; leave F (Total Revenue) and H (Profit Amount) blank for now
(we will enter formulas in the next steps).
Semester 2 2025 - DUE 19 September 2025 ; 100%
TRUSTED Complete, trusted solutions and
explanations.
Start Guide for MS Excel Assessment
Open a new blank workbook in Microsoft Excel.
Save early: File → Save As → choose folder → name the file
Surname-StudentNumber.xlsx (example if your surname is
Brown and student number is 2324567: Brown-
2324567.xlsx).
(Note: the question also shows the example 2324567_Brown; if
your instructor wants that format use it instead.)
Do not convert the file to PDF.
1) Enter the headers and dataset (exact cells)
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 5 data rows (cells A2 → H6). Put numbers exactly as
below; leave F (Total Revenue) and H (Profit Amount) blank for now
(we will enter formulas in the next steps).
