EUP1501 Assignment 3 2025 – Due 30 April 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 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: