EDUCATOR-LEVEL-1 practice question 1 of 30

Which function would you use to find the lowest value in a range of cells?

Full set: 210 questions
Answer options
A: AVERAGE
B: MAX
C: MIN Correct answer
D: SUM
Correct Answer:
C. MIN
Explanation

The MIN function in Google Sheets is used to identify and return the lowest numerical value from a specified range of cells. It parses through all the cells in the defined range (e.g., A1:B10), ignores any non-numeric data such as text or empty cells, and outputs the single smallest number it finds. This is a fundamental function for data analysis when you need to find a minimum value in a dataset.

Why Incorrect

A. The AVERAGE function calculates the arithmetic mean of the numbers in a range, not the lowest value.
B. The MAX function finds the highest numerical value in a range, which is the direct opposite of the MIN function.
D. The SUM function adds all the numerical values in a range together to produce a total.

References

1. Google Workspace Help. (n.d.). MIN function. In Google Docs Editors Help. Retrieved from https://support.google.com/docs/answer/3094017?hl=en. (This is the official documentation for the MIN function in Google Sheets).

2. Google for Education. (n.d.). Unit 7: Organize your data with Google Sheets - Lesson 2: Calculate and summarize your data. In Google Educator Level 1 Fundamentals Training. Retrieved from https://skillshop.exceedlms.com/student/path/29453-fundamentals-training. (The official training curriculum for the exam covers basic data analysis functions, including MIN).

Scroll to Top