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.

12
    12
    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
    AFK1503 Assignment 6 Due 1 October 2024
    AFK1503 Assignment 6 Due 1 October 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    TLI4801 Assignment 1 Semester 1 | Due 14 March 2025
    TLI4801 Assignment 1 Semester 1 | Due 14 March 2025
    Seller:

    Aimark94

    Price: R100.00
    R100.00
    PSC1501 Assignment 3 Solutions
    PSC1501 Assignment 3 Due 5 July 2024
    Seller:

    Unisian

    Price: R50.00
    R50.00
    BPT1501 Assignment 7 Portfolio (Due 17 November 2023)
    R60.00
    OPM1501 Assignment 2 2025 Due 6 June 2025
    OPM1501 Assignment 2 2025 Due 6 June 2025
    Seller:

    Unisian

    Price: R60.00
    R60.00
    FAC1601 Exam Pack 2024
    FAC1601 Exam Pack 2024
    Seller:

    Unisian

    Price: R80.00
    R80.00
    SAE3701 Exam Pack 2024 (Quizzes, Exam, Footnotes)
    R80.00
    NST2601 Assignment 2
    R50.00
    LCR4805 Assignment 1 2025 Due 12 August 2025
    LCR4805 Assignment 1 2025 Due 12 August 2025
    Seller:

    Unisian

    Price: R50.00
    R50.00
    CPR3701 Exam Pack 2025
    CPR3701 Exam Pack 2025
    Seller:

    Unisian

    Price: R80.00
    R80.00