Stat functions: MIN() MCQs Quiz | Class 9
This quiz is for Class 9 students studying Computer Applications (Code 165), based on Unit 3: Office Tools (Spreadsheets). It covers the topic of statistical functions, specifically focusing on using the MIN() function to find the smallest value in a range. Attempt all questions, submit your answers to see your score, and then download the PDF answer sheet for your records.
Understanding the MIN() Function in Spreadsheets
The MIN() function is a fundamental statistical function in spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc. Its primary purpose is to find the smallest or minimum numerical value from a given set of numbers, a range of cells, or a combination of both.
Key Concepts of MIN()
Understanding how MIN() works is crucial for data analysis. Here are the main points:
- Syntax: The basic syntax is
=MIN(number1, [number2], ...). You can provide individual numbers, cell references, or ranges of cells. For example,=MIN(A1:A10)finds the smallest number in the range from cell A1 to A10. - Purpose: It returns the smallest numeric value in the arguments. This is useful for identifying the lowest score, the cheapest price, the earliest date, or the fastest time in a dataset.
- Handling Data Types: The MIN() function is smart about what it includes in its calculation:
- Numbers: It directly compares and finds the smallest number.
- Text and Empty Cells: The function completely ignores any cells containing text or empty cells. They are not treated as zero.
- Logical Values: It does NOT include TRUE (1) or FALSE (0) in its calculation when they are in a cell range, but it will if they are typed directly into the formula (e.g.,
=MIN(5, TRUE)would be 1). However, for typical Class 9 level usage, you can assume it ignores logical values in ranges.
Example of MIN() in Action
Consider the following data in a spreadsheet:
| Cell | Value | Data Type |
|---|---|---|
| A1 | 25 | Number |
| A2 | 10 | Number |
| A3 | -5 | Number (Negative) |
| A4 | Apple | Text |
| A5 | Empty Cell |
If you use the formula =MIN(A1:A5) in another cell, the result will be -5. The function scans the range, finds all the numbers (25, 10, -5), and ignores the text “Apple” and the empty cell A5. It then returns the smallest of the numbers found.
Quick Revision Points
- MIN() finds the minimum or smallest value.
- Its counterpart is MAX(), which finds the maximum value.
- Syntax:
=MIN(range)or=MIN(value1, value2, ...). - It only considers numbers. Text, empty cells, and error values within a range are ignored.
- It can work with negative numbers and decimals.
Practice Questions
- What formula would you use to find the lowest temperature recorded in cells C2 through C32?
- If a range contains the values {15, “N/A”, 12, 0, -10}, what will the MIN() function return?
- What is the difference between =MIN(0, 10) and =MIN(A1, A2) if A1 contains 0 and A2 contains 10?
- Can the MIN() function be used to find the earliest date in a list of dates? Why?
- What happens if you apply MIN() to a range that contains no numbers at all? (e.g., only text and blank cells)
