Final answer:
The correct way to calculate the range in Excel is by using the formula =MAX(some values) - MIN(some values), making the right answer option A.
Step-by-step explanation:
In Excel, the range of a set of values is calculated by finding the difference between the maximum and the minimum values in that set.
The correct method to calculate the range is by using the formula: =MAX(some values) - MIN(some values). Therefore, the correct answer to the student's question is A.
The function =RANGE(maximum value, minimum value) does not exist in Excel. To find the range, you simply subtract the smallest number (the result of the MIN function) from the largest number (the result of the MAX function).