Description

EUP1501 Assignment 4 2025

 

EUP1501

Semester 2 2025

Formative Assessment 4

Total Grade: 45

This practical assessment is designed to evaluate students’ proficiency in Microsoft Excel by testing their ability to apply key functions, formulas, and data analysis tools to solve real-world problems and manage datasets effectively.

 Read the instructions carefully.

 Ms Excel (45)

Open a blank spreadsheet. Create the VR Headset Sales Dataset using the data provided below, and complete the tasks:                                                                                                                              [5]

No Drone Model Sales Region Units Sold Unit Price Total Revenue Profit Margin (%) Profit Amount
1 HTC Vive Cosmos Elite North America 500 1200 25
2 HTC Vive XR Elite Europe 300 800 30
3 Varjo Aero Asia 700 1000 28
4 Skydio 2 South America 250 1500 32
5 Pimax 8K X Africa 180 1100 27
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

Reviews

There are no reviews yet.

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

Description

EUP1501 Assignment 4 2025

 

EUP1501

Semester 2 2025

Formative Assessment 4

Total Grade: 45

This practical assessment is designed to evaluate students’ proficiency in Microsoft Excel by testing their ability to apply key functions, formulas, and data analysis tools to solve real-world problems and manage datasets effectively.

 Read the instructions carefully.

 Ms Excel (45)

Open a blank spreadsheet. Create the VR Headset Sales Dataset using the data provided below, and complete the tasks:                                                                                                                              [5]

No Drone Model Sales Region Units Sold Unit Price Total Revenue Profit Margin (%) Profit Amount
1 HTC Vive Cosmos Elite North America 500 1200 25
2 HTC Vive XR Elite Europe 300 800 30
3 Varjo Aero Asia 700 1000 28
4 Skydio 2 South America 250 1500 32
5 Pimax 8K X Africa 180 1100 27
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

Reviews

There are no reviews yet.

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

13
    13
    Your Shopping Cart
    TMS3716 Assignment 3 2024 | Due 25 June 2024
    TMS3716 Assignment 3 2024 | Due 25 June 2024
    Seller:

    Aimark94

    Price: R50.00
    R50.00
    PYC4807 Assignment 3 Semester 2 (Due 28 Sept 2023)
    R60.00
    TPS3704 Portfolio Due 19 September 2024
    TPS3704 Portfolio Due 19 September 2024
    Seller:

    Unisian

    Price: R100.00
    R100.00
    CAS3701 ASSIGNMENT 10 SOLUTIONS,SEMESTER 2 ,2024
    CAS3701 ASSIGNMENT 10 SOLUTIONS,SEMESTER 2 ,2024
    Seller:

    SHINING SMILE ACADEMY

    Price: R50.00
    R50.00
    LPL4802 Portfolio Semester 2 Due 27 October 2023
    LPL4802 Portfolio Semester 2 Due 27 October 2023
    Seller:

    Unisian

    Price: R60.00
    R60.00
    CSP2601 Assignment 5 Due 26 Sept 2024
    CSP2601 Assignment 5 Due 26 Sept 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    MAT2615 Assignment 1 Memo | Due 15 May 2025
    MAT2615 Assignment 1 Memo | Due 15 May 2025
    Seller:

    Aimark94

    Price: R100.00
    R200.00
    CRI2601 Assignment 1 2025 - March 2025
    CRI2601 Assignment 1 2025 - March 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    MRL2601 Assignment 2 2025 - Due April 2025
    MRL2601 Assignment 2 2025 - Due April 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    MNP3701 Assignment 3 Due 24th April 2024
    MNP3701 Assignment 3 Due 24th April 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    NST1501 Assignment 2 2025 - Due 17 July 2025
    NST1501 Assignment 2 2025 - Due 17 July 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    GGH3702 Assignment 1 2025 | March 2025
    GGH3702 Assignment 1 2025 | March 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00