EUP1501 Assignment 3 Semester 1 Memo | Due April 2025 [COMPLETE ANSWERS];100% CORRECT AND TRUSTED SOLUTIONS

,EUP1501 Assignment 3 Semester 1 Memo | Due April
2025[COMPLETE ANSWERS];100% CORRECT AND
TRUSTED SOLUTIONS

SECTION A: Excel Task – Drone Sales Dataset (45 marks)


🔷 Step 1: Create the Dataset Table (Structure)
Start by opening Microsoft Excel and following these steps:
1. Open a new blank workbook.
2. In Row 1, enter the following headers into Columns A to
H:

A B C D E FG H
Profit
Drone Sales Units Unit Total Profit
No Margin
Model Region Sold Price Revenue Amount
(%)

3. Underneath, enter the data for each drone model from row
2 to row 6 (rows 2–6 for entries, 7–10 for summary
functions).
Note: You will only fill in known values initially. Some
columns will be calculated later (Total Revenue and Profit
Amount).

, Profit
Drone Sales Units Unit Total Profit
No Margin
Model Region Sold Price Revenue Amount
(%)
DJI
North enter enter enter
1 Phantom (formula) (formula)
America value value value
4
Parrot enter enter enter
2 Europe (formula) (formula)
Anafi value value value
DJI
3 Mavic Asia 7000 1000 (formula) 28 (formula)
Air 2
South enter enter enter
4 Skydio 2 (formula) (formula)
America value value value
Autel enter enter enter
5 Africa (formula) (formula)
Evo II value value value

For testing purposes, you can populate dummy values for
missing “Units Sold”, “Unit Price”, and “Profit Margin (%)” in
rows 2, 4, and 5 if not specified.



🔷 Step 2: Apply Bold Headers and Font Size 12pt (2 marks)
1. Select Row 1 (A1:H1).
2. Go to the Home tab.
3. Click the Bold icon.
4. Change the font size to 12pt from the dropdown.

✅ This enhances readability and standardizes the table format.