EUP1501 ASSIGNMENT 3 SEMESTER 1 2025 – FULLY ANSWERED

Description

EUP1501 Assignment 3 Semester 1 Memo | Due April 2025. 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 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. [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: