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
Answer:
The answers to 1st question and part 2A is given. However, the 2B is not given complete and thus cannot be answered.
Explanation:
UNION is a keyword used in C Language to have a commonly shared memory that can be used by multiple elements. It is a data-type that allows different data types to use the same shared memory location.
Importance: If you want to minimize the use of memory by sharing it between different datatype variables, then use UNION. For Ex. Let's suppose I want to use 2 variables a and b of type char and int respectively. Now, suppose int takes memory space of 2 bytes and char takes 1 byte then the total amount of memory needed = 2 + 1 = 3 Bytes. But, we want to first make use of a, and once done, we want to declare variable b. We can limit the memory use by declaring a memory space of 2 bytes (max of a and b). First, we can use this space to store the int variable and when done with it, we can use it to store the char variable.
PART 2A
typedef struct{
int partNum;
char partName[25];
} partin;
#define Partin partin
Answer:
Devastating Vocal Xcellence
Explanation:
Answer:
3 bits
Explanation:
Capacity of main memory=16 Bytes=24
The number of address bits= 4 bits.
The size of the word= 1 Byte=20
The word bits=0.
Number of lines =4
Number of sets required=21
The sets bits is =1
The number of offset bits=20=0
Number of tag bits= total number of address bits - (word bits + offset bits + set bits)
= 4 - 0 -0- 1
= 3 bits
