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 function would you use to find the highest value in a dataset?

• MAX

• LARGE

• MIN

• SMALL

Which function helps in finding the nth largest value in a dataset?

• MAX

• AVERAGE

• MIN

• LARGE

What is the purpose of locking cell references when using the LARGE function?

• To increase calculation speed

• To ensure the correct range is used

• To prevent changes to the formula

• To make the formula more readable

How can you find the highest sales in a specific genre using Excel?

• Use AVERAGEIFS

• Use MAXIFS

• Use MAX

• Use MIN

Which function would you use to find the lowest value based on a condition?

• MIN

• MINIFS

• SMALL

• LARGE

What is the benefit of combining the LARGE function with an IF statement?

• To apply conditions to the data

• To increase the speed of calculations

• To simplify the formula

• To reduce the number of functions used

Why is it important to format data correctly in Excel?

• To reduce file size

• To prevent data loss

• To ensure accurate calculations

• To make it look professional