[TYPE THE COMPANY NAME]
EUP1501 Assignment
4 (COMPLETE
ANSWERS) Semester
2 2025 - DUE October
2025
NO PLAGIARISM
[Pick the date]
[Type the abstract of the document here. The abstract is typically a short summary of the contents of
the document. Type the abstract of the document here. The abstract is typically a short summary of
the contents of the document.]
, 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
EUP1501 Assignment
4 (COMPLETE
ANSWERS) Semester
2 2025 - DUE October
2025
NO PLAGIARISM
[Pick the date]
[Type the abstract of the document here. The abstract is typically a short summary of the contents of
the document. Type the abstract of the document here. The abstract is typically a short summary of
the contents of the document.]
, 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
