EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE October 2025;

EUP1501 Assignment 4
(COMPLETE ANSWERS)
Semester 2 2025 - DUE
October 2025;




USER
[Email address]

, EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE
October 2025;

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 the 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. [4]

6. Adjust column width 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. [3]

10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown)
and upload [2] (Do not convert to pdf)




EUP1501 Assignment 4 – Complete Report