Using the MIN and MAX Functions in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

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
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. Which formula is an example of finding the smallest number in a range?

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
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

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

Additional Learning

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