Stat functions: MAX() MCQs Quiz | Class 9
This is an online MCQs quiz for Class 9 Computer Applications (Code 165), from Unit 3: Office Tools (Spreadsheets). This quiz covers the topic of using the statistical function MAX() to find the largest value in a range. Attempt all questions, click the submit button to check your score, and download the PDF answer sheet for your records.
Understanding the MAX() Function in Spreadsheets
The MAX() function is a fundamental statistical function used in spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc. Its primary purpose is to find and return the largest numerical value from a given set of numbers, cell references, or a range of cells.
Key Concepts of MAX()
Understanding how MAX() works is crucial for data analysis. Here are the main points:
- Purpose: To find the maximum or largest value in a dataset.
- Syntax: The general syntax is
=MAX(number1, [number2], ...). - Arguments: The function can take one or more arguments. These arguments can be numbers, cell references (like A1), or ranges (like A1:A10).
- Handling Data Types:
- Numbers: It processes all numerical values directly.
- Text: It ignores cells containing text.
- Logical Values: It ignores logical values (TRUE and FALSE) when they are in a range of cells.
- Empty Cells: Empty cells within a range are also ignored.
Practical Examples
Let’s consider a small dataset to see MAX() in action.
| Cell | Value |
|---|---|
| A1 | 10 |
| A2 | 25 |
| A3 | 5 |
| A4 | 50 |
| A5 | “Apple” |
=MAX(A1:A4)would return 50, as it is the largest number in that range.=MAX(A1:A5)would also return 50. The function ignores the text value “Apple” in cell A5.=MAX(A1, A3, 100)would return 100. It compares the values from cells A1 (10) and A3 (5) with the number 100 and returns the largest among them.
Quick Revision Points
- MAX() is used for finding the highest value.
- The opposite function is MIN(), which finds the lowest value.
- The function only considers numerical values, ignoring text and empty cells in a range.
- You can mix individual cell references, ranges, and hardcoded numbers as arguments.
- If a range contains no numbers, MAX() will return 0.
Extra Practice Questions
- What would the formula
=MAX(15, -20, 0, 8)return?
Answer: 15 - A spreadsheet range C1:C5 contains the values: 10, 20, TRUE, “thirty”, 40. What is the result of
=MAX(C1:C5)?
Answer: 40 (It ignores TRUE and “thirty”). - How would you find the highest score from a list of student scores in cells D2 through D50?
Answer: Use the formula=MAX(D2:D50). - What is the difference between
=MAX(A1, A2)and=MAX(A1:A2)?
Answer: Functionally, they both return the maximum value from cells A1 and A2. The first uses individual cell references, while the second uses a range. - If cell B1 is empty, what will
=MAX(B1)return?
Answer: 0.
