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