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 Font Size
What to do:
Select the header row (e.g., “Drone Model,” “Units Sold,” “Unit Price,” etc.).
Press Ctrl + B or click the Bold button.
Change the font size to 12pt from the font dropdown.
Why:
Bold headers make your table easier to read and clearly differentiate column titles from
data.
A consistent font size ensures readability and a professional appearance.
Tip: You can also center-align the headers to improve aesthetics.
2. Calculate Total Revenue
Formula:
Total Revenue = Units Sold × Unit Price
How:
Insert a new column titled Total Revenue.
In the first cell, type:
=B2*C2
(assuming B2 = Units Sold, C2 = Unit Price)
Drag the formula down to apply it to all rows.
Why:
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 Font Size
What to do:
Select the header row (e.g., “Drone Model,” “Units Sold,” “Unit Price,” etc.).
Press Ctrl + B or click the Bold button.
Change the font size to 12pt from the font dropdown.
Why:
Bold headers make your table easier to read and clearly differentiate column titles from
data.
A consistent font size ensures readability and a professional appearance.
Tip: You can also center-align the headers to improve aesthetics.
2. Calculate Total Revenue
Formula:
Total Revenue = Units Sold × Unit Price
How:
Insert a new column titled Total Revenue.
In the first cell, type:
=B2*C2
(assuming B2 = Units Sold, C2 = Unit Price)
Drag the formula down to apply it to all rows.
Why:
