Asked by seydi ortiz on May 30, 2024
Verified
Which of the following functions is used to find the smallest value in a range of cells using Microsoft Excel?
A) MAX(range)
B) MIN(range)
C) SUM(range)
D) AVERAGE(range)
MIN(range)
Refers to the smallest value in a given range of data.
Smallest Value
The minimum value within a set of numbers or measurements.
- Learn the basic capabilities of Microsoft Excel relevant to statistical analysis.
Verified Answer
RW
riley williamsJun 06, 2024
Final Answer :
B
Explanation :
The MIN function in Excel is used to find the smallest value in a range of cells. The MAX function, on the other hand, is used to find the largest value in a range of cells. The SUM function is used to add up a range of cells, and the AVERAGE function is used to find the average value of a range of cells.
Learning Objectives
- Learn the basic capabilities of Microsoft Excel relevant to statistical analysis.