Answer:
The correct answer to this question is given below in the explanation section.
Step-by-step explanation:
An essential skill in Excel is to know how to determine the range of values in Excel for Excel users. Maybe you don't have time to waste sorting through rows and columns in order to find the lowest and highest values of sales, revenue, or other finance-related information, etc. The range in Excel, the difference between the highest and lowest value helps in making accurate decisions, forecasting, and budgeting.
To find the minimum and maximum, you can use the following functions.
To determine the range for Cell F1 to F5 is given below:
To find the minimum, you can use this function: =MIN(F1:F5)
To find maximum, you can use this function: =MAX(F1:F5)
If you want to find the highest and lowest values for the example sale amount, you can use the following formulas.
To find the lowest, you can use this function:=SMALL(F1:F5,1)
To find the next lowest, you can use this function:=SMALL(F1:F5,2)
To find the third-lowest, you can use this function:=SMALL(F1:F5,3)
To find the highest, you can use this function: =LARGE(F1:F5,1)
To find the next highest, you can use this function: =LARGE(F1:F5,2)
To find the third-highest, you can use this function: =LARGE(F1:F5,3)