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?

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF