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
We're the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click either of the buttons below to place your order.
Order a Similar Paper
Order a Different Paper
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.