In cell R9, enter a formula using the AVERAGEIF function to determine the average number of years of experience for lifeguards.

Computers and Technology

1 answer:

Kipish [7]3 years ago

8 0

Answer:

Explanation:

The AVERAGEIF function is an excel function that is used to determine the average of a range of cells. It has the format

=AVERAGEIF(range, criteria, average_range)

The range is use to specify the range of cells that will be covered when calculating the average. like R9:R20

The criteria is like the condition that a cell must meet in order for it content to be included in the calculation. Like for the formula for years of experience, the criteria might be the course of study. This show that anybody that does study a course will not be included in the average calculation.

Average_range maybe optional if the cell of the range is the cell in which the data to be considered is located. However, if the cell is different, then the average range is used to specify the range of the cell to be calculated. For example, R9:R20 might contain the names of the employees, while maybe p9:p20 contain their their course, then the average_range cells might contain the number of years of experience that will be calculated example Q9:Q20.

The formular can be =AVERAGEIF(R9:R20, p9:p20, Q9:Q20)

The number in each segment of the formula denotes the lowest range of cells while the second numbers after the colon is the highest range of cell you want.

You might be interested in

Which folder does the ipad saves my pictures?

saw5 [17]

It will save it in the pre-installed iphotos application.
Hope this helps. <span />

4 0

3 years ago

Read 2 more answers

Renter’s insurance is not necessary if you don’t have a lot of expensive things.

attashe74 [19]

Wrong, You should get renters insurance to insure your items that you do have or will recieve in the future are safe

7 0

3 years ago

An open system consists of nonproprietary hardware and software based on publicly known standards that allows third parties to c

kolezko [41]

Answer:

The answer is "Option D".

Explanation:

A system or a group of components that communicate with your environment through the sharing of resources, materials, and knowledge with a view to system regeneration and development is known as an Open system. In other words, we can say that it is a system that includes a non-proprietary hardware and advert-based software which enables third parties to add or interact with products to plug in the system and It is freely available on the internet. In this question, the incorrect options can be described as follows:

In option A, The management system is used by an organization. It is a paid system that's why it is not correct.

In option B, This system enables users in online communities and evaluates one another that's why it is not correct.

In option C, This type of system provides resources for upgrade user knowledge. It is a paid system that's why it is not correct.

6 0

3 years ago

You are going to visit a national park, and have never been there before. You are using a map to try and make the distance trave

Firdavs [7]

Answer:

eggs fishing didn't ysjffj

8 0

3 years ago

it is a program a personal computer microprocessor uses to get the computer system started after you turn it on

Fofino [41]

Explanation:

please repeat your question

5 0

3 years ago