2.4 - MIN
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What does the MIN function do?
💡 Hint: Think about finding the lowest value.
Use the MIN function to find the minimum of the numbers 8, 3, and 5. What will the formula look like?
💡 Hint: Recall the structure of the MIN function.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What is the purpose of the MIN function in spreadsheets?
💡 Hint: Focus on the concept of minimum vs maximum.
Using =MIN(A1:A10), if A3 contains 20 and the rest are smaller, what will be the result?
💡 Hint: Think about the other numbers in that range.
1 more question available
Challenge Problems
Push your limits with advanced challenges
In a dataset containing sales figures for different hours of a store, you have the following data in G1:G24: 250, 300, 150, 420, 180, 225, 90... What is the formula to find the minimum sales figure during this time?
💡 Hint: Make sure to select the entire range of sales for accuracy.
Using the same sales data, if you want to see the absolute minimum sales made on any given hour, what pattern of analysis would you follow to ensure comprehensiveness?
💡 Hint: Consider how to analyze a range of data that's not in sequence!
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.