Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL

This video tutorial explains how to find the largest and smallest values in a dataset using Excel functions. It covers the use of MAX, MIN, LARGE, and SMALL functions to identify top and bottom sales figures. The tutorial also demonstrates advanced techniques using MAXIFS and MINIFS to filter data by specific criteria, such as genre. The video provides step-by-step instructions on applying these functions, locking cell references, and formatting results for clarity.

What functions can be used to find the 2nd, 3rd, 4th, and 5th largest values in a range of data?

Evaluate responses using AI:

OFF

How do you use the LARGE function to return the second largest value?

Evaluate responses using AI:

OFF

What is the purpose of locking the table range when using the LARGE function?

Evaluate responses using AI:

OFF

Explain how to find the highest sales in the pop genre using the MAXIFS function.

Evaluate responses using AI:

OFF

What criteria must be specified when using the MINIFS function to find the lowest sales in a specific genre?

Evaluate responses using AI:

OFF

Describe the process of using the SMALL function to find the second lowest sales value.

Evaluate responses using AI:

OFF

How can you modify the formatting of sales data after calculating the largest or smallest values?

Evaluate responses using AI:

OFF