,EUP1501 Assignment 3 Semester 1 2025 - DUE
April 2025 ;100 % TRUSTED workings, Expert
Solved, Explanations and Solutions.
MULTIPLE CHOICE,ASSURED EXCELLENCE
The assessment has 2 Parts (Section A and Section B), and you
must complete both sections. Read the instructions carefully.
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 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. [5] 10. Save the spreadsheet as
Surname-StudentNumber (e.g. 2324567_Brown)
------------------------------------------------------------------------------------
--------------------------------------------------- Section Sections B:
PowerPoint Presentation (45 Marks) Download the provided
PowerPoint Presentation (Formative Assessment 3 –
ClimateChange), and perform the following tasks: Create a 5-
slide PowerPoint presentation summarizing your findings from
the Excel analysis. 1. Slide 1: Title Slide [8] o Title:
Section A: Excel Tasks
1. Create the Drone Sales Dataset:
o Open a new spreadsheet and input the given data in
columns for Drone Model, Sales Region, Units Sold,
Unit Price, Total Revenue, Profit Margin (%), and
Profit Amount.
Here's an example structure for your dataset:
mathematica
CopyEdit
April 2025 ;100 % TRUSTED workings, Expert
Solved, Explanations and Solutions.
MULTIPLE CHOICE,ASSURED EXCELLENCE
The assessment has 2 Parts (Section A and Section B), and you
must complete both sections. Read the instructions carefully.
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 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. [5] 10. Save the spreadsheet as
Surname-StudentNumber (e.g. 2324567_Brown)
------------------------------------------------------------------------------------
--------------------------------------------------- Section Sections B:
PowerPoint Presentation (45 Marks) Download the provided
PowerPoint Presentation (Formative Assessment 3 –
ClimateChange), and perform the following tasks: Create a 5-
slide PowerPoint presentation summarizing your findings from
the Excel analysis. 1. Slide 1: Title Slide [8] o Title:
Section A: Excel Tasks
1. Create the Drone Sales Dataset:
o Open a new spreadsheet and input the given data in
columns for Drone Model, Sales Region, Units Sold,
Unit Price, Total Revenue, Profit Margin (%), and
Profit Amount.
Here's an example structure for your dataset:
mathematica
CopyEdit
