Match the following Excel tasks to the correct formulas.(5 points)

Question

=MROUND =MAX =RANGE =AVERAGE =SUM
To find the mean of a data set...

to find the highest number in a data set...

to round a number to the nearest 10...

to find the range of a data set...

To add the total of a data set...

Answer 1

To find the mean of a data set... =AVERAGE

to find the highest number in a data set... =MAX

to round a number to the nearest 10... =MROUND

to find the range of a data set... =RANGE

To add the total of a data set... =SUM