Challenge Project 5-10

For this project, you create a timesheet workbook. At the end of the week, you consolidate the sheets to calculate total hours for each employee.

File Needed: None

Completed Project File Name: [your initials] Excel 5-10.xlsx

[Student Learning Outcomes 5.1, 5.4, 5.8]

Create a new workbook and save it as [your initials] Excel 5-10. Modify your workbook according to the following guidelines:

• Insert worksheets so that you have five sheets in the workbook.
• Name the sheets Mon, Tue, Wed, Thu, and Fri.
• Group all the sheets and type the names of five employees in cells A3:A7.
• Select cell B3. Enter the number of hours worked for each person. Type values that are decimals such as 5.5 or 6.25. Assume that employees can work up to 10 hours per day.
• Select the values in column B. Create a custom number format to display the value with two decimal places and hrs after the value (for example, 8.25 hrs).
• Determine a company name and type a main label in cell A1.
• In cell A2, type Week of, press Spacebar, and type the date for Saturday of this week in mm/dd/yy format. This date is not treated as a value because it is part of the label.
• Ungroup the sheets. Make a copy of one of the sheets and name it Totals.
• Consolidate the data on the Totals sheet without links.
• Encrypt the workbook with the password 123.