Essay
Starsystems is a small information systems company that employs 50 workers. The employee details for a particular month are given below:
a. The administrative manager of the company wanted to know the total number of employees who were on leave for 4 days and 5 days in this month. Use COUNTIF function to determine this.
b. Now, the manger wanted the details of employees, Ava, Julia, and Alanis who are working in the company. Use VLOOKUP function to get these employees details.
Correct Answer:

Verified
a. A part of the spreadsheet m...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q6: The _ function pairs each element of
Q21: Arrows pointing from the selected cell to
Q22: In _ decision making companies have to
Q44: A one-way data table summarizes<br>A)a single input's
Q47: What do nodes in an influence diagram
Q51: The average cost/unit for the production of
Q54: Suppose a company supplies four of its
Q55: The _ function is used for the
Q56: The modularity approach of building the influence
Q57: . Reference - 7.1Use the influence diagram