EMPLOYEE+ROSTER


 * An employee roster is a list of basic information about each employee.**

Depending on the size of your restaurant, the number of employees could range from a few to several dozen. No matter the number, an employee roster is a necessary tool for managing the personnel in your business..

In this project, you will enter employee information into a spreadsheet.This will allow you to contact your employees quickly, compare wages, and help plan work schedules. You can also easily add or update employee information as needed.


 * Strategies:**
 * Use the Internet to research the average pay rate for each job title listed below:
 * Owner/Manager
 * Assistant Manager
 * Hostess (2 positions)
 * Waitstaff (5 positions)
 * Dishwasher (2 positions)
 * Cook (2 positions)
 * Bus Person (2 positions)
 * Maintenance


 * Use either appropriate fictitious names or the names of friends and family as employees
 * Use proper currency style in formatting the dollar amount on the worksheet
 * Be sure to enter all of the information accurately.

Instructions:
 * 1) Refer to Amanda's sample for guidance. Do not copy the content or design of this sample.
 * 2) Create a new workbook (sheet) and save it as "Employee Roster."
 * 3) Insert a header and key the following text:  Employee Roster
 * 4) Format the header to 18 point bold.
 * 5) In the spreadsheet footer, key the title "Employee Roster"
 * 6) In cells A1 - E1, key the following column headings: //Employee Name, Job Title, Employee Number, Phone Number, Pay Rate//


 * Note:** //Adjust row heights and column widths when needed so that all data displays properly.//

7. Bold and center align cells A1 - E1 8. Key your employee roster information into the spreadsheet. 9. Format column E as Currency showing the "$" symbol and two decimal places. 10. Shade the cells below the heading in column D in a bright color. 11. Sort the spreadsheet by Employee Name in ascending order (A-Z) 12. Below the last cell that contains data in column A, key the following text: //Average Pay Rate// and format to bold. 13. Below the last cell that contains data in column E, enter the formula to compute the Average Pay Rate for all employees and format to bold.


 * Hint:** //Use the AVERAGE formula --- You must use cell references in your formula. **=AVERAGE(1st PAY RATE cell:last PAY RATE cell); Click ENTER -- FORMAT as currency**//

14, Proofread your work for accuracy, format, spelling, and grammar, then resave.

[|Wicked Kickn' BBQ Employee Roster] //**YES, you must have the number of employees listed above!**//