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)
ep-by-step Detailed Guide
1. Apply Bold Headers and Change Font Size to 12pt. [2]
Why? Headers must stand out for readability and professionalism.
How? Highlight the top row (the one with labels like Drone Model, Units Sold, Unit Price,
Profit Margin, Total Revenue, Profit Amount).
On the Home ribbon → Click Bold (B).
(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)
ep-by-step Detailed Guide
1. Apply Bold Headers and Change Font Size to 12pt. [2]
Why? Headers must stand out for readability and professionalism.
How? Highlight the top row (the one with labels like Drone Model, Units Sold, Unit Price,
Profit Margin, Total Revenue, Profit Amount).
On the Home ribbon → Click Bold (B).
