Question

N Excel, we calculate the range as:

A. =MAX(some values) - MIN(some values)
B. =RANGE(maximum value, minimum value)
C. Both A and B
D. Neither A nor B

Answer 1

To calculate the range in Excel, one should use the formula '=MAX(some values) - MIN(some values)', which is option A, since there is no RANGE function as implied in option B. Thus, the correct answer is A.

Step-by-step explanation:

In Excel, to calculate the range of a series of values, we would use option A: =MAX(some values) - MIN(some values). The range is the difference between the maximum and minimum values in a set of numbers.

There is no built-in function called RANGE that takes a maximum and minimum value as arguments in Excel, as suggested in opstion B. Therefore, option C (Both A and B) is not correct, and option D (Neither A nor B) is also not correct because option A is indeed the method to calculate range in Excel.