Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - AVERAGE, MEDIAN, and MODE.

This video tutorial guides students through exercises to practice calculating average, median, and mode, using large and small functions, and applying the RANK function. It emphasizes using cell references and absolute referencing. The tutorial also demonstrates how to find the top three largest and smallest values in a table and return corresponding products, as well as how to rank student scores and sort them by rank.

What is the importance of using cell references instead of hard-coded values in calculations?

What are the steps to calculate the average, median, and mode for a set of numbers?

How do you ensure that the mode calculation returns all values that occur more than once?

Describe the process of finding the top three largest values in a table and returning the corresponding product.

How can you use the SMALL function to find the top three smallest values in a table?

Explain how to use the RANK function to rank scores in descending order.

What steps should be taken to sort a table by rank after using the RANK function?