Welcome to our Website!

Here is the 7th & Last Question of the Quiz!

In this Quiz, you need to create a very small template.

We have attached the Excel workbook, In sheet 1 you will find the Master data and in sheet 2 you will find the reporting template.

What we have required?

You need to prepare a small template, in which you need to fill all the required field.

What all requirements are?

  1. In 1st column, extract unique department list by using formula only from the data
  2. InĀ  2nd column, return the team size
  3. In 3rd column, you need to calculate “Average” salary department wise
  4. In 4th column, return “Average” tenure (yrs) department wise
  5. After getting all details, create a chart that should be include all data

 

 

 

 

 

 

 

 

 

 

Download Excel File