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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

Starsystems Is a Small Information Systems Company That Employs 50