The workbook for this project generates client bills from staff hours in multiple worksheets. In this project, you will complete the worksheet for staff member Swinson to calculate the daily bill, the total billable hours per week, and the total weekly bill. The worksheet for staff member Stevens has been completed. You may use it for reference as necessary. Skills needed to complete this project: Working in Protected View
Navigating a Workbook
Entering and Editing Text and Numbers in Cells
Applying Number Formats
Entering Dates and Applying Date Formats
Inserting Data Using AutoFill
Understanding Absolute and Relative References
Entering Simple Formulas
Calculating Totals with the Quick Analysis Tool
Previewing and Printing a Worksheet
1. Open the start file EX2016-SkillReview-1-1. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it.
3. Explore the workbook. If you accidentally make changes while exploring, press Ctrl + Z to undo the change.
a. Click the worksheet tab labeled Stevens Hours.
b. If necessary, use the vertical scroll bar to scroll down so you can see both weeks of billable hours. (If necessary, use the vertical scroll bar again to return to the top of the worksheet.)
c. Click cell B2 (the cell displaying the staff member’s last name, Stevens). This is the cell at the intersection of column B and row 2.
i. Note that the column B and row 2 selector boxes highlight.
ii. Note that the status bar displays Ready, indicating that you are in Ready mode.
iii. On the Home tab, in the Number group, look at the Number Format box at the top of the group. Note that the format for this cell is General.
iv. Double-click cell B2 to switch to Edit mode. Note that the status bar now displays Edit, and the blinking cursor appears within the cell. If you needed to, you could edit the text directly in the cell.
d. Press Esc key to exit Edit mode and return to Ready mode.
Step 1 Download start file