Question

In cell B20, enter a function to calculate the average attendance for 2018

Answer 1

A function to calculate the average attendance for all of the locations for the year 2018 would be: =average(F5:F11).

To enter a function to calculate the average attendance for the year 2018 we have to follow the following steps.

We have to select the cell that we want to edit. In this cell we are going to enter the function and the result of the operation will be there. In this case is cell B20.

We have to enter the next code "=average(F5:F11), with this code we are going to programate the program to sum and divide (promediate) the attendance of the year 2018.

Finally we have to press enter key to activate the formula.

Full Question:

Although part of your question is missing, you might be referring to this full question:

In cell B20, enter a function to calculate the average attendance for 2018?
See attached.

Answer 2

=Average(Cell Range)

Step-by-step explanation:

The function that is used to calculate the average value of a data set or the mean in Ms. Excel is;

AVERAGE function.

In the cell B20, Enter the function;

=Average

Then select the entire attendance for 2018 as the arguments of the function. Finally, press the enter key on your keyboard.