# Using the MIN and MAX Functions in Excel

Instructions:

question 1 of 3

### Which formula would find the largest number in the range?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free for 30 days. Cancel anytime

### 2. Using the example in the image below, what will the value or result be using the following formula? =MIN(D3:D12)

Create your account to access this entire worksheet
Quizzes, practice exams & worksheets
Certificate of Completion
Create an account to get started

MIN and MAX functions in Excel provide the lowest or highest numbers in a range or set. This quiz will judge your understanding of how to best use these functions alone or in conjunction with other formulas.

## Quiz & Worksheet Goals

This assessment will test your knowledge of Excel functions including:

• Using MIN functions
• Using MAX functions
• Keyboard shortcuts

## Skills Practiced

• Making connections - use understanding of the concept of functions performed on ranges
• Problem solving - apply acquired knowledge to solve MIN and MAX function practice problems from sample ranges
• Knowledge application - use your knowledge to answer questions about types of formulas and how to use them

For more information regarding MIN and MAX functions, review the lesson titled Using the MIN and MAX functions in Excel. This article goes in depth on the subject, including:

• Using functions in a range or in single cells
• Combining functions (i.e. with the IF function)
• Creating complex formulas
Final Exam
Chapter Exam

Support