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 function should be used to return all values that occur more than once in a dataset?

• MODE.SNGL

• MODE.MULT

• AVERAGE

• MEDIAN

Which function can be used to find the largest value in a dataset?

• SMALL

• AVERAGE

• LARGE

• MIN

When using the LARGE function, what is important to ensure when copying the formula down?

• Use hard-coded values

• Lock the sales array

• Avoid using cell references

• Use the MIN function

Which function can be used as an alternative to INDEX and MATCH for finding a product?

• HLOOKUP

• XLOOKUP

• SUM

• VLOOKUP

What is the purpose of the RANK function in this exercise?

• To calculate the average score

• To find the median score

• To rank scores in descending order

• To sort scores alphabetically

What should be done to sort the table by rank without errors?

• Use the SUM function

• Copy and paste values

• Use the AVERAGE function

• Delete the rank column

What is the final step after ranking the scores in descending order?

• Calculate the median

• Sort the table by rank

• Find the smallest value

• Use the MODE function