, EUP1501 Assignment 3 Semester 1 Memo (100%
COMPLETE ANSWERS) Semester 1 2025 DUE april 2025 ;
100% trusted, comprehensive and complete reliable solution
with clear explanation
Section A: Ms Excel (45) Open a blank spreadsheet. Create the
Drone Sales Dataset using the data provided below, and
complete the tasks: [4] No Drone Model Sales Region Units
Sold Unit Price Total Revenue Profit Margin (%) Profit Amount
1 DJI Phantom 4 North America 2 Parrot Anafi Europe 3 DJI
Mavic Air 2 Asia 7000 1000 28 4 Skydio 2 South America 5
Autel Evo II Africa 6 Sum 7 Average 8 Max 9 Min Tasks: 1.
Apply bold headers and change the font size to 12pt. [2] 2.
Calculate Total Revenue for all drone models using the formula
Total Revenue = Units Sold × Unit Price [5] 3. Calculate Profit
Amount for all drone models using the formula: Profit Amount
= (Profit Margin / 100) × Total Revenue [5] 4. Format all
currency values (Unit Price, Total Revenue, Profit Amount) as
currency (use rands, 2 decimal places). [5] 5. Apply conditional
formatting to highlight sales regions where revenue exceeds
R50,000.00. [5] 6. Adjust column widths to ensure data
visibility. 7. Apply SUM, AVERAGE, MAX, and MIN
functions for Total Revenue and Profit Amount. [8] 8. Generate
two charts for visualization purposes: A Bar Chart comparing
revenue across different sales regions. [3] A Pie Chart showing
the market share of each drone model (use “Drone model” and
“Profit Amount” columns). [3] 9. From the Home ribbon, use
“Format as Table” to select the style for the dataset (use any
purple style). Make sure you select the dataset before you start.
COMPLETE ANSWERS) Semester 1 2025 DUE april 2025 ;
100% trusted, comprehensive and complete reliable solution
with clear explanation
Section A: Ms Excel (45) Open a blank spreadsheet. Create the
Drone Sales Dataset using the data provided below, and
complete the tasks: [4] No Drone Model Sales Region Units
Sold Unit Price Total Revenue Profit Margin (%) Profit Amount
1 DJI Phantom 4 North America 2 Parrot Anafi Europe 3 DJI
Mavic Air 2 Asia 7000 1000 28 4 Skydio 2 South America 5
Autel Evo II Africa 6 Sum 7 Average 8 Max 9 Min Tasks: 1.
Apply bold headers and change the font size to 12pt. [2] 2.
Calculate Total Revenue for all drone models using the formula
Total Revenue = Units Sold × Unit Price [5] 3. Calculate Profit
Amount for all drone models using the formula: Profit Amount
= (Profit Margin / 100) × Total Revenue [5] 4. Format all
currency values (Unit Price, Total Revenue, Profit Amount) as
currency (use rands, 2 decimal places). [5] 5. Apply conditional
formatting to highlight sales regions where revenue exceeds
R50,000.00. [5] 6. Adjust column widths to ensure data
visibility. 7. Apply SUM, AVERAGE, MAX, and MIN
functions for Total Revenue and Profit Amount. [8] 8. Generate
two charts for visualization purposes: A Bar Chart comparing
revenue across different sales regions. [3] A Pie Chart showing
the market share of each drone model (use “Drone model” and
“Profit Amount” columns). [3] 9. From the Home ribbon, use
“Format as Table” to select the style for the dataset (use any
purple style). Make sure you select the dataset before you start.
