To efficiently calculate the difference between the highest number and the lowest number in your data set, you should use the MAX and MIN functions in combination. However, since that option is not listed, none of the provided choices are correct.
If you are looking for a general answer based on the options given, you would benefit from using functions rather than manual tools. But to specifically answer the question based on the provided options, please note that those options are not optimal for this task. You would typically use:
=MAX(range) - MIN(range)
You can enter this formula into a cell in your spreadsheet to achieve the desired calculation directly.
1 answer