Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
2 cards from this section. Quick, good the night before a test.
What does the MIN function do?
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?
Recall the structure of the MIN function.
What is the purpose of the MIN function in spreadsheets?
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?
Think about the other numbers in that range.
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?
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?
Consider how to analyze a range of data that's not in sequence!
5 more questions in this section. Enroll free to practise them all.
Enroll free