To find the minimum and maximum values in the dataset, you may:
a) sort the dataset (A1:A100) using the Sort Smallest to Largest functionality which you will find by clicking on the Sort & Filter icon, in the Editing section of the ribbon under the Home tab. Simply retrieve the lowest and highest (the first and last, respectively) value in the column.
b) use the functions =MIN(...) and =MAX(...) to get the minimum and maximum values of the dataset, respectively. In our example, type =MIN(A1:A100) and =MAX(A1:A100).
To calculate the range of the dataset, no predefined function can be found. You’ll have to calculate manually the difference between the maximum and the minimum of the dataset. In that case, simple type the formula =MAX(...)-MIN(...). In our example, this means =MAX(A1:A100)-MIN(A1:A100).