Microsoft Excel 2021365 - Beginner to Advanced - Working with the MIN and MAX Functions

The video tutorial covers Excel's essential functions, focusing on the MIN and MAX functions. It explains how to use these functions to find the minimum and maximum values in a range of cells. The tutorial provides a step-by-step guide on constructing these functions and demonstrates how to efficiently copy formulas using the Control D shortcut.

What is the primary purpose of the MIN function in Excel?

• To calculate the average of a range

• To find the highest value in a range

• To sum all values in a range

• To return the lowest value in a range

Which function would you use to determine the highest value in a set of cells?

• MIN

• MAX

• AVERAGE

• SUM

How do you select the MIN function from the list in Excel?

• Type 'min' and press the Tab key

• Type 'min' and press Enter

• Type 'min' and click the mouse

• Type 'min' and press the Spacebar

What is the result of using the MAX function on a range of cells?

• It returns the sum of all values

• It returns the lowest value

• It returns the highest value

• It returns the average value

What does the Control D shortcut do in Excel?

• Deletes the selected cells

• Duplicates the selected worksheet

• Copies a formula down a column

• Opens the formula editor