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]
4 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]4 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
When coding, how do you get animations to work??
Nina [5.8K]

Answer:

Blender's animation & rigging if you are talking about 3d modeling.

Explanation:

Blender is a standard free to use universally used software used in animation for most standard games. You learn to model, then to rig with bones, then to animate. Animations don't entirely go with coding unless you are calling them in the code to make them play.

7 0
4 years ago
Write function modifyString(origString, charsToReplace, count) that takes as input a string origString, a string charsToReplace,
laila [671]

Answer:

The code of the above program is provided below. using Python

Explanation:

<u>Code in Python 3:- </u>

def modifyString(origString,charsToReplace,count):

# Make s1 as original string

s1=origString

# Make s2 as charsToReplace string in lowercase

s2=charsToReplace.lower()

# Make s3 as charsToReplace string in uppercase

s3=s2.upper()

# Initialize answer as an empty string

ans=''

# Iterate the string upto length times

for i in range(len(s1)):

# check for chars in the string and append to the answer

if (s1[i] in s2) or (s1[i] in s3):

ans=ans+count*s1[i]

else:

ans=ans+s1[i]

# return the final string

return ans

print(modifyString("Our cat is funny","aeiou",5))    

print(modifyString("Our cat is funny","zu",3))

8 0
3 years ago
1. A(n)
Dennis_Churaev [7]

Answer:

1.Spelling checker


2. Order of mathematical operations .

3. Series  

4. Pick from list  

5. Sum Function


6. Active Cell  

7. cell


8. Accounting format


9. Format

Explanation:

4 0
3 years ago
QUESTION 4
Kaylis [27]

Answer: 2, 3, 6, 8

Explanation:

i must tell you something very important.

in LISTS.... the FIRST thing is marked with a 0.

[0, 1, 1, 2, 3, 6, 8, 13, 21, 34]

[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]

do you see how these line up with each other?

the output would be 2, 3, 6, 8

4 0
3 years ago
nadine is the systems administrator for a network with a single subnet. The subnet uses 192.168.1.0 with a mask of 255.255.255.0
weeeeeb [17]

Answer:

Authorize Srv11

Explanation:

In order to fix this problem, Nadine should Authorize Srv11. The problem is most likely being caused due to failure of authorization of the server. This would prevent this server from being on the same scope as Srv1 and therefore, it is why the IPaddress being given is different. DHCP is an automatic protocol and would not be able to provide an IP address in the same scope if the server is not Authorized to do so.

3 0
3 years ago
Other questions:
  • Compare and contrast assertiveness, arrogance and passivity.
    14·1 answer
  • What does limited access to a document mean?
    7·2 answers
  • You are setting up a desktop computer for an AutoCAD specialist who needs a minimum of 125GB of RAM. Which operating system belo
    6·1 answer
  • What is a digital certificate? Select one: a. It is a means of establishing the validity of an offer from a person, entity, web
    7·1 answer
  • Front office employees at the Melville Lodge use a computer-based system to manage, among other things, the central reservation
    13·1 answer
  • Some careers emerge to address the environmental impact human behaviors and processes might be having on our planet. True False
    9·2 answers
  • For what parties the prepare documentation ​
    9·1 answer
  • Why does Microsoft release new versions of its Windows operating system every few years?
    9·2 answers
  • What is the definition of trouble shooting.
    12·1 answer
  • Name at least three classes to which each of these objects might belong:
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!