In the sheet ‘retail_sales_dataset’ add all available data between columns A – H into a ‘table’
Using the ‘filter’ function, filter ‘Age’ to ‘largest to smallest’
Using the ‘SUM’ function, show me the commission total in cell ‘P10’
Using the ‘AVERAGE’ function, show me the average commission in cell ‘P11’
Embedded Files
Objectives: create charts to visualise data in Microsoft Excel.
Part 1: Creating a Line chart
Part 2: Creating a Column Chart
Part 3: Creating a Pie Chart
Background / scenario
Data visuaulisation assists with the analysis and interpretation of data by graphically
presenting relationships, trends, and inferences that cannot always be clearly derived examining the raw text and numeric values in a dataset.
Task
Apply filter and sorting to show the best students in each subject.
Calculate the average for all students and fill into Column E. (Use formula)
Using the =MAX funtion, tell me what the students highest score was in column F.
Apply filter and sorting to show the best student in this classroom by average.
Apply filter and sorting to show the best student in this classroom by highest score.
Use conditional formatting to clearly identify the highest and lowest average scores
Page updated
Google Sites
Report abuse