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
A. Assets increase, and liabilities decrease.
Answer:
Importancia de la tecnología en el crecimiento económico de los países. ... El desarrollo de estas vías tecnológicas aporta un aspecto positivo como el ahorro del tiempo, la disminución de los esfuerzos de los trabajadores que permite una economía progresiva.
Explanation:
Answer:
a store owner would calculate a mean to see the how much a person spends
Explanation:
Answer:
#include <iostream>
using namespace std;
int main() {
int *ip_arr,n;//pointer name inp_arr and integer n to store the size.
cin>>n;//size.
for(int i=0;i<n;i++)
ip_arr[i]=-1;//assigning -1 to every element.
for(int i=0;i<n;i++)
{
cout<<ip_arr[i]<<" ";//printing every element.
}
return 0;
}
output:-
100
-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
Explanation:
I am taking input of size.You should enter 100 for 100 values which have value -1.
