You are developing a worksheet to analyze employee data for an environmentally-friendly grocery supplies company. Bonuses are paid to employees based on the results of their performance evaluations, while parking fees are charged to the employees based o
Programming
Starting File: Project 5 – Student – GreenGrocers.xlsx
You are developing a worksheet to analyze employee data for an environmentally-friendly grocery supplies company. Bonuses are paid to employees based on the results of their performance evaluations, while parking fees are charged to the employees based on their base salary. Follow the steps to produce the results shown in Figure 1 at the end of this document.
Notes:
This workbook has 4 worksheets: the Documentation worksheet (for the history of this workbook), the EmpData worksheet with employee details, the Reference worksheet with reference tables, and the Analysis worksheet for summary information. Be sure to work on the correct worksheet as indicated in the instructions.
You should use cell references, table column names, and/or defined names in all formulas – do not re-enter data. Use absolute cell references where appropriate.
