EUP1501 Assignment
4 (COMPLETE
ANSWERS) Semester 2
2025 - DUE October
2025
NO PLAGIARISM
[Pick the date]
[Type the company name]
, Exam (elaborations)
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.
Ensure your success with us.
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
4 (COMPLETE
ANSWERS) Semester 2
2025 - DUE October
2025
NO PLAGIARISM
[Pick the date]
[Type the company name]
, Exam (elaborations)
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.
Ensure your success with us.
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
