All categories

2 years ago

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]2 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

How is the Internet Simulator similar to the Actual Internet? How is it different?

masya89 [10]

The Internet Simulator is a tool developed by Code.org for our new high school Computer Science Principles class. ... The Internet Simulator was designed to be used in a classroom with students working collaboratively in-person to solve problems.

4 0

3 years ago

What is the function of a bread crumb trial in a website

joja [24]

Answer:

A “breadcrumb” (or “breadcrumb trail”) is a type of secondary navigation scheme that reveals the user's location in a website or Web application. The term comes from the Hansel and Gretel fairy tale in which the two title children drop breadcrumbs to form a trail back to their home.

Explanation:

A breadcrumb or breadcrumb trail is a graphical control element frequently used as a navigational aid in user interfaces and on web pages. It allows users to keep track and maintain awareness of their locations within programs, documents, or websites. Breadcrumbs make it easier for users to navigate a website – and they encourage users to browse other sections of the site. ... You head to their site and end up on The Nestle company history page. Using their breadcrumbs, you can easily navigate back to About Us, History, or even their home page.

6 0

2 years ago

When a computer restarts without a hardware power-down-power-up cycle, it is doing a _______________?

tamaranim1 [39]

When a computer restarts without a hardware power-down-power-up cycle, it is doing an update.

4 0

2 years ago

A system is being developed to help pet owners locate lost pets. Which of the following best describes a system that uses crowds

Slav-nsk [51]

Crowdsourcing is used by mobile application that allows users to report the location of a pet that appears to be lost.

<h3>What is a mobile application?</h3>

A mobile application is known to be a kind of computer app or program that has been made to handle or run itself on a mobile device e.g. phone, etc.

Conclusively, the option that best describes a system that uses crowdsourcing is the mobile application that allows users to report the location of a pet that appears to be lost and upload a photo that is made available to other users of the application and thus everyone can help to look for it.

Learn more about mobile application from

brainly.com/question/9477543

#SPJ1

6 0

1 year ago

g You and your friend both send documents to the printer, but the printer can only print one document at a time. What does it do

Sedbober [7]

Answer:

It places the document in a buffer

Explanation:

Since the printer can only print a document at a time, the other document is going to be placed in a buffer.

The print buffer can be described as a location in memory that has the function of holding data that is going to be sent to a computers printer. A print job such as in this scenario may remain in the buffer because another document is to be printed first.

Sometimes a document could be put in the buffer because the computer is waiting for the printer to respond. This is just another reason why documents are placed in a buffer.

5 0

2 years ago