subject

Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows: a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4.
b. If the consultant has four or more years of experience, display "Lead" in cell N5.
c. If the consultant has less than four years of experience, display "Associate" in cell N5.
d. Copy the formula in cell N5 to the range N6:N13, pasting the formula only.
e. Use AutoFit to resize column N to its best fit.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 00:40
If you arrive at the same time as another user straight across from you yield if a. they flash your headlights at you b. you can’t see their turn signals c. you’re going street and they’re running d. you’re turning they’re going straight plz
Answers: 1
question
Computers and Technology, 22.06.2019 10:30
Dave has to create animations for a game. which tool can dave use?
Answers: 3
question
Computers and Technology, 22.06.2019 12:30
Some of the first computer games were created in the early 1970s by college students experimenting after hours to see what the were capable of doing.
Answers: 3
question
Computers and Technology, 23.06.2019 06:30
When early motion pictures played in movie theaters, they were often accompanied by live organ or piano music. which of the following are the most likely reasons that this happened? (select all that apply). the music was provided to distract audience members from the loud sounds made when filmstrips were changed. the music accompanied the movies because the movies were silent and audiences were used to hearing music during plays in theaters. the music usually was played before, and sometimes after the movie, as an alternative form of entertainment. the music viewers to interpret the dramatic action in the films.
Answers: 2
You know the right answer?
Carla needs to list the role for each consultant. Those with four or more years of experience take t...
Questions
question
Computers and Technology, 06.05.2021 19:10
question
Mathematics, 06.05.2021 19:10
question
Arts, 06.05.2021 19:10
Questions on the website: 13722367