Information Communication Technology: Solving and Presenting Dataset
VerifiedAdded on 2023/06/13
|9
|665
|76
Practical Assignment
AI Summary
This document presents a solved Information Communication Technology (ICT) assignment involving the analysis of a given dataset. The dataset includes information about various businesses, such as mobile phone repair shops, stationery shops, and confectionery retailers, along with their business income, tax income, and net income. The solution demonstrates the use of Excel formulas to calculate tax, net income, total net income, average net income, highest and lowest net incomes, and counts based on specific criteria. It also includes a chart comparing the income and net income of each business. The assignment leverages functions like TODAY, COUNT, IF, SUM, AVERAGE, MAX, MIN, and COUNTIF to derive insights from the data. References to resources on advanced Excel functions are also provided. Desklib offers a platform to explore similar solved assignments and study materials for students.
1 out of 9