2 years ago

Enter a formula in cell b7 to calculate the average value of cells b2:b6

1 answer:

7 0

The answer is =AVERAGE(B2:B6)
Or, you can just go to "HOME" tab, then click the arrow down next to AutoSum, click the AVERAGE, then select B2:B6.
Average, which is also called arithmetic mean,can be calculated manually by adding all the numbers in a set, then dividing the count of the numbers in a set. But, in excel, there are shortcut formulas to calculate it.

You might be interested in

what is the purpose of the Outline view in word 2016? check all that apply. 1. editing the format of size and text. 2.working wi

iragen [17]

Answer:

2.working ... heading.

3. demoting ...document

4: creating .......Navigation view

Explanation:

The outline view shows the document uniquely. It leverages advantage from the Word's style of heading for sorting out the problems of the groups by helping then arrange their thoughts, plotlines, and the ideas, as well as mix in the text for helping to arrange the thoughts. Hence, 2 and 3 are correct options. Also, the headings are displayed on the navigation view. And hence the fourth option is also correct.

5 0

3 years ago

When gathering information about certain occupations, be sure to understand how you are paid. What is the difference between a s

kirill [66]

Salary is what you get paid weekly or biweekly. Hourly wage is why you paid in a hour.

5 0

2 years ago

Read 2 more answers

Which command os used to find a particular word in a document ?<br>

lorasvet [3.4K]

Answer:

Ctrl+F