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:

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

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:

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

65
    65
    Your Shopping Cart
    ENG1505 Assignment 4 2025 - Due 8 August 2025
    ENG1505 Assignment 4 2025 - Due 8 August 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    MAC3701 Assignmen
    MAC3701 Assignment 1 2025 - March 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    ENN1504 Assignment 2 Due September 2024
    ENN1504 Assignment 2 Due September 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    CAS1501 Assignment 2 Quiz Due 10 Sept 2024
    CAS1501 Assignment 2 Quiz Due 10 Sept 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    HES4810 ASSIGNMENT 2 2025 - FULLY ANSWERED (DUE 2 JULY 2025)
    HES4810 ASSIGNMENT 2 2025 - FULLY ANSWERED (DUE 2 JULY 2025)
    Seller:

    The Smart Slacker

    Price: R100.00
    R100.00
    FAC1501 Assignment 3 Due 30 September 2024
    FAC1501 Assignment 3 Due 30 September 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    RRLLB81 Assignment 2 2025 (3 Topics) - Due 9 April 2025
    R50.00
    LML4807 Exam Pack with great notes!
    LML4807 Exam Pack with great notes!
    Seller:

    Mbali Law Tutor

    Price: R85.00
    R85.00
    TLI4801 Assignment 2 Answers Semester 1 2025
    TLI4801 Assignment 2 Answers Semester 1 2025
    Seller:

    Andre

    Price: R50.00
    R50.00
    LCP4804 ASSIGNMENT 1 (QUIZ) SEMESTER 1 2025
    LCP4804 ASSIGNMENT 1 (QUIZ) SEMESTER 1 2025
    Seller:

    The Smart Slacker

    Price: R100.00
    R100.00
    HRIOP87 Assignment 4 Semester 2 2024
    R150.00
    AUE2602 Exam Pack 2025
    AUE2602 Exam Pack 2025
    Seller:

    Unisian

    Price: R65.00
    R65.00
    MAC2602 Questions & Answers Exam Pack
    MAC2602 Questions & Answers Exam Pack
    Seller:

    Calvin

    Price: R50.00
    R50.00
    CIV3701 ASSIGNMENT 01 MEMO SEMESTER 2 2023
    CIV3701 ASSIGNMENT 01 MEMO SEMESTER 2 2023
    Seller:

    Andre

    Price: R50.00
    R50.00
    LML4807 Assignment 2 Semester 2 2024 | Due 30 September 2024
    R50.00
    SOC2604 Assignment 2 Semester 2 2024 | Due 27 September 2024
    R80.00
    PRM3701 Assignment 6 Semester 2 2024
    R80.00
    SUS1501 Assignment 03 Answers Semester 1 2025
    SUS1501 Assignment 03 Answers Semester 1 2025
    Seller:

    Andre

    Price: R50.00
    R50.00
    AUE1601 ASSIGNMENT 02 SOLUTIONS , SEMESTER 1 , 2022(TO BE USED AS A GUIDELINE)
    R50.00
    FAC1503 ASSIGNMENT 01 ANSWERS SEMESTER 1 2024
    FAC1503 ASSIGNMENT 01 ANSWERS SEMESTER 1 2024
    Seller:

    Andre

    Price: R50.00
    R50.00
    LSP1501 Simplified notes with past assignments
    R65.00
    TLI4801 Assignment 1 answers
    TLI4801 Assignment 01 Answers Semester 1 2025
    Seller:

    Andre

    Price: R50.00
    R50.00
    LCR4805 ASSIGNMENT 2 SEMESTER 1 2025 - FULLY ANSWERED
    LCR4805 ASSIGNMENT 2 SEMESTER 1 2025 - FULLY ANSWERED
    Seller:

    The Smart Slacker

    Price: R100.00
    R100.00
    ENN1504 ASSIGNMENT 01 MEMO SEMESTER 1 2024
    ENN1504 ASSIGNMENT 01 MEMO SEMESTER 1 2024
    Seller:

    Andre

    Price: R50.00
    R50.00
    IOP2601 Assignment 2 Due 15 April 2024
    IOP2601 Assignment 2 Due 15 April 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    CIV3701 Assignment 01 Answers Semester 1 2025
    CIV3701 Assignment 01 Answers Semester 1 2025
    Seller:

    Andre

    Price: R50.00
    R50.00
    COM2602 ASSIGNMENT 1 SEMESTER 2 2025 - FULLY ANSWERED (DUE SEPTEMBER 2025)
    R100.00
    PED3701 ASSIGNMENT 1 (FORUM) 2025 - FULLY ANSWERED
    PED3701 ASSIGNMENT 1 (FORUM) 2025 - FULLY ANSWERED
    Seller:

    The Smart Slacker

    Price: R100.00
    R100.00
    FAC3703 Assignment 2 Semester 2 2022 #699225
    FAC3703 Assignment 2 Semester 2 2022 #699225
    Seller:

    Anne Moore

    Price: R50.00
    R50.00
    HSY1511 ASSIGNMENT 04 SOLUTIONS ,SEMESTER 1 ,2023(TO BE USED AS A GUIDELINE)
    R50.00
    Family Law - PVL2601 afrikaans notes
    Family Law - PVL2601 afrikaans notes
    Seller:

    The Graduate

    Price: R55.00
    R55.00
    LSK3701 Old Exam Pack (Free)
    LSK3701 Old Exam Pack (Free)
    Seller:

    Lori

    Price: R0.00
    R0.00
    HSY1511 ASSIGNMENT 05 SOLUTIONS ,SEMESTER 1 ,2023(TO BE USED AS A GUIDELINE)
    R50.00
    FAC3704 ASSIGNMENT 02 SOLUTONS ,SEMESTER 1,2022 (TO BE USED AS A GUIDELNE)
    R50.00
    CMY3706 ASSIGNMENT 01 MEMO SEMESTER 2 2023
    CMY3706 ASSIGNMENT 01 MEMO SEMESTER 2 2023
    Seller:

    Andre

    Price: R50.00
    R50.00
    DSC1520 Assignment 01 Answers Semester 1 2025
    DSC1520 Assignment 01 Answers Semester 1 2025
    Seller:

    Andre

    Price: R50.00
    R150.00
    APM3700 ASSIGNMENT 03 SOLUTIONS,SEMESTER 2 ,2024
    APM3700 ASSIGNMENT 03 SOLUTIONS,SEMESTER 2 ,2024
    Seller:

    SHINING SMILE ACADEMY

    Price: R150.00
    R150.00
    MNB3701 ASSIGNMENT 02 MEMO SEMESTER 2 2023
    MNB3701 ASSIGNMENT 02 MEMO SEMESTER 2 2023
    Seller:

    Andre

    Price: R50.00
    R50.00
    OHS2602 ASSIGNMENT 2 SEMESTER 1 2025 - FULLY ANSWERED
    OHS2602 ASSIGNMENT 2 SEMESTER 1 2025 - FULLY ANSWERED
    Seller:

    The Smart Slacker

    Price: R100.00
    R100.00