Enter the database function in cell i6 that determines the average salary of all full-time employees with at least one dependant
1 answer:
Based on the given spreadsheet, the database function that needs to be entered into cell I6 to find the average salary of all full-time employees is =AVERAGEIFS(D5:D34,B5:B34,"FT",C5:C34,">=1")
<h3>What does the AverageIfs formula find?</h3>You can use the AverageIfs formula to find the average of a specific group of numbers from a spreadsheet based on the shared categories that these numbers fall under.
After typing in the =AverageIfs function, you then input the range from which the category will be specified. In this case that is D5:D34. The next entry would be the range the category is picked from which is B5:B34. The function will be FT for Full time workers.
Then use C5:C34 to find out the number of dependents that are equal to or greater than 1.
The digit returned is the average salary of all full-time employees.
Find out more on the AverageIf function at brainly.com/question/13661607
#SPJ1
You might be interested in
<h2><u>Given</u> :-</h2>
Create a HTML code for writing a web page for your school time-table.
<h2><u>Answer</u> :-</h2><html>
<head>
<title> Time Table </title>
</head>
<hrcolor = "red">
<hrcolor = "blue">
<body>
<table><tr = "7"><md = "7"><Period 1_></table>
</body>
</html>
Answered by - ItzMaster