Question
Match the following Excel tasks to the correct formulas.(5 points)
=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...
=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...
Answers
GPT 3.5
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
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
Related Questions
Which formula would you use to round the number in cell B5 to the nearest 10?
1. MROUND(B5,10)
2.=MR...
4.2.7 - Quick Check: Estimating by Rounding 4. Microsoft® Excel > 4.2. Estimating by Rounding
Which...
Which formula would you use to round the number in cell B5 to the nearest 10?
(1 point)
Responses...
Which formula would you use to round the number in cell B5 to the nearest 10?
(1 point)
Response...