employee_evaluations_

employee_evaluations_ - Create the formulas necessary to...

This preview shows pages 1–2. Sign up to view the full content.

Employee Evaluations Name Salary Evaluation Rasie % Raise New Salary Mandelbrot 117,000 6.4 6 7,020 124,020 Gardner 94,000 5.3 5 4,700 98,700 Thom 72,400 2.7 8 5,792 78,192 Russell 67,200 8.5 3 2,016 69,216 Whitehead 51,200 7.2 1 512 51,712 Goedel 41,700 4.5 5 2,085 43,785 Hardy 39,800 3.9 4 1,592 41,392 Cauchy 29,800 7.2 2 596 30,396 Ramanujan 39,400 6.4 8 3,152 42,552 Gauss 24,500 7.9 9 2,205 26,705 Euler 18,900 5.8 5 945 19,845 595,900 6.0 5.1 30,615 626,515 Mandelbrot Gardner Thom Russell Whitehead Goedel Hardy Cauchy Ramanujan Gauss Euler 0 1 2 3 4 5 6 7 8 9 Evaluation Rasie %

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Your assignment is to calculate raises for employees in your department. The table in Sheet1 lists their performance evaluations along with percentage raises that you wish to give.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Create the formulas necessary to complete the table: 1. Calculate the Raise (in dollars) for the first employe. 2. Calculate the New Salar y for the first employee. 3. Copy the formulas for Raise and New Salary to all other employees. 4. Calculate the total of Salary , Raise , and New Salary . 5. Calculate an average for Evaluation and Raise % 6. Format the Raise and New Salary columns to look like the Salary column. Optional (but good practice): Create a graph that displays the percentage raise and the performance evaluations for each employee....
View Full Document

This homework help was uploaded on 04/16/2008 for the course SCH-MGT 210 taught by Professor Milne during the Spring '08 term at UMass (Amherst).

Page1 / 2

employee_evaluations_ - Create the formulas necessary to...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online