EUP1501 Assignment 4
(COMPLETE ANSWERS)
Semester 2 2025 - DUE
October 2025
[Document subtitle]
[School]
[Course title]
, EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE October 2025
Course
Ethical Information and Communication Technologies for Development Solutions
(EUP1501)
Institution
University Of South Africa (Unisa)
Book
Technology-Supported Teaching and Research Methods for Educators
EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE October 2025; 100%
TRUSTED Complete, trusted solutions and explanations.
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
(COMPLETE ANSWERS)
Semester 2 2025 - DUE
October 2025
[Document subtitle]
[School]
[Course title]
, EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE October 2025
Course
Ethical Information and Communication Technologies for Development Solutions
(EUP1501)
Institution
University Of South Africa (Unisa)
Book
Technology-Supported Teaching and Research Methods for Educators
EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 2 2025 - DUE October 2025; 100%
TRUSTED Complete, trusted solutions and explanations.
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
