445,687 views
29 votes
29 votes
17) If you want to find the average salary (with each employee's salary found in column C) for those who are full time employees (which will have "FT" in column B), you would use the ________ function.

A. COUNTAVERAGE


B. IFAVERAGE


C. AVERAGE


D. AVERAGEIF

User Marurban
by
3.3k points

2 Answers

11 votes
11 votes

Answer:

Average

Step-by-step explanation:

If you want to find the average salary (with each employee's salary found in column C) for those who are full time employees (which will have "FT" in column B), you would use the AVERAGE function.

User Timothy Steele
by
3.3k points
15 votes
15 votes

Answer:

AVERAGE

Step-by-step explanation:

THIS is a function used in Microsoft Excel.

The steps to find average is

  • Sum/Total

Hence

first we use AUtoSUM function to find sum then we use average to calculate

User Wlyles
by
3.0k points