1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Zepler [3.9K]
3 years ago
12

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
A function ________ contains the statements that make up the function.
mestny [16]

Answer:

A) definition

Explanation:

3 0
3 years ago
Choose the correct term to complete the sentence.
Diano4ka-milaya [45]

Answer:

Object-oriented programming

Explanation:

When used in object-oriented programming , a class is a factory for creating object. An object is a collection of data and behavaiors that represent some entity(real or abstract).

6 0
3 years ago
Vivian wants to increase the storage capacity of her computer. Which components should she upgrade?
Nikitich [7]

Answer:

Hard drive

Explanation:

The hard drive is where the operating system, programs and data reside on (unless the data is saved and backed up elsewhere). An older hard drive that uses platters for reading and writing data to it will be slower than a later model solid state device. Newer hard drives have very fast access speeds compared to older units.

4 0
3 years ago
ASAP
grin007 [14]
I would recommend A. Quickly on the left and move ahead of it because you should always pass on the left and seeing as it is a large truck, you would want to get ahead of it ASAP.
4 0
4 years ago
Read 2 more answers
You work as the IT administrator for a small business and are responsible for the corporate network. Until now, the network has
posledela

Answer:

Extend a Volume:

1. in the lower left-hand corner, R click the start page thumbnail and select disk management

2. if needed, click ok to initialize any new disks.

3. R click the volume and select extend volume.

4. click next.

5. for the system volume, you can only extend the volume onto the existing disk. type the amount of disk space to add to the volume and click next. click finish.

Convert a Disk to Dynamic

1. In Disk management, R click the disk and select convert to Dynamic Disk

2. Select the disk to convert, click ok.

3. Click convert

4. If the disk contains a volume, you will be shown a warning message. Click Yes to continue.

Create a Spanned Volume

1. In disk management, R click a disk or free space on a disk and select New Spanned Volume.

2. Click Next

3. Select the disks that will be part of the spanned volume and click Add. You must select at least 2 disks to create a spanned volume.

4. To modify the amount of space used on a disk for the new volume, select the disk in the right box, and then edit the number in the select the amount of space in MB: field.

5. Click next

6. Select the drive letter and click Next

7. Type the volume label, then click next

8. Click finish

9. If the new volume includes a space from a disk that is currently a basic disk, you will be prompted to convert the disk to a dynamic disk. Click Yes to create the volume.

Explanation:

5 0
3 years ago
Other questions:
  • During the past decade ocean levels have been rising faster than in the past, an average of approximately 3.1 millimeters per ye
    14·1 answer
  • A firewall, when properly implemented, can prevent most attacks on your system.
    11·1 answer
  • What does it mean to read visual and audio text
    7·1 answer
  • An optimal solution to a linear programming problem MUST lie A. somewere on the line between two corner points. B. somewhere out
    12·1 answer
  • Is 5g harmful to the body ?
    9·2 answers
  • Describe five different ways databases can be processed
    14·1 answer
  • If you want Nud3s add me on sc Kermit4lyfe1
    11·2 answers
  • An ALGORITHM IS?<br> PLEASE HELP
    14·1 answer
  • What is the difference between computer hardware and computer software?<br>​
    10·1 answer
  • what is the term for software that is exclusively controlled by a company, and cannot be used or modified without permission?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!