EUP1501 Assignment 3 (COMPLETE ANSWERS) Semester 1 2025 ;DUE April 2025; 100% correct solutions and explanations.

EUP1501 Assignment 3 (COMPLETE ANSWERS) Semester 1 2025 ;DUE April 2025; 100% correct solutions and explanations. Both Excel and Powerpoint done. 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: