EUP1501 Assignment 4 (DETAILED ANSWERS) Semester 2 2025 - DISTINCTION GUARANTEED

EUP1501 Assignment 4 (DETAILED ANSWERS) Semester 2 2025 - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED Answers, guidelines, workings and references ,... 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 the 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. [4] 6. Adjust column width 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. [3] 10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown) and upload [2] (Do not convert to pdf) 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 the 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. [4] 6. Adjust column width 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. [3] 10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown) and upload [2] (Do not convert to pdf) 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: 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 the 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. [4] 6. Adjust column width 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. [3] 10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown) and upload [2] (Do not convert to pdf) 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 the 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. [4] 6. Adjust column width 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. [3] 10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown) and upload [2] (Do not convert to pdf) 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: