ART #1-- Legal Staff Billable Hours Log Employee Name Swinson David Employee Number 6287 Billable Rate $ 165.00 Dates Worked Mon Tue Wed Thu Fri Sat Sun 7/25/2016 7/26/2016 7/27/2016 7/28/2016 7/29/2016 7/30/2016 7/31/2016 Clients Hudson 4.00 4.00 1.00 2.25 Smith 4.00 4.00 4.00 Aturo 1.50 2.50 3.50 1.00 4.00 Proctor 2.25 2.25 2.25 3.00 2.25 Total Billable Hours Per Day 7.75 8.75 6.25 7.50 7.25 6.25 4.00 Daily Bill $1,278.75 $1,443.75 $1,031.25 $1,237.50 $1,196.25 $1,031.25 $660.00 Bill Total for Week $7,878.75 Dates Worked Mon Tue Wed Thu Fri Sat Sun Clients Hudson 3.50 3.00 1.00 2.50 1.00 Smith 2.00 2.00 3.00 Aturo 3.00 2.00 1.00 1.00 1.00 2.00 Proctor 2.25 1.00 2.25 4.00 16.00 4.00 Total Billable Hours Per Day Daily Bill Total Bill Total for Week PART #2-- (same question, just needed file) Open the start file EX2016-ChallengeYourself-1-3. The start 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, enable editing so you can make changes to the workbook. 3. Verify that the Swinson Hours worksheet is active. 4. If necessary, scroll to the bottom of the worksheet so you can see the empty timesheet beginning on row 19. 5. The dates are missing from the timesheet. Enter the date 8/1/2016 in cell B20. 6. Use AutoFill to complete the dates in cells C20:H20. 7. Change the date format for B20:H20 to the Short Date format. 8. The hours reported for the Proctor client on Friday (cell F25) are incorrect. Change the number in cell F25 to: 4 9. Use the Quick Analysis tool to enter total hours for each day. Use the cell range B22:H25. The daily totals should be inserted into the range B26:H26. 10. Format the hours billed section (cells B22:H26) to use the Comma Style number format. Be sure to include the total row. 11. Enter a formula in cell B28 to calculate the daily bill for Monday, August 1. The formula should calculate the total billable hours for the day (cell B26) times the billable rate (B4). Be sure to use an absolute cell reference for the billable rate. 12. Use AutoFill to copy the formula to the remaining days in the timesheet (cells C28:H28). Step 1 Download start file A Skills Approach: Excel 2016 Chapter 1: Getting Started with Excel 2016 2 | Page Challenge Yourself 1.3 Last Updated 9/18/16 13. Calculate the bill total for the week by summing the daily bill amounts. In cell B29, enter a formula using the SUM function. The function argument should be the range of cells representing the daily bill totals (B28:H28). 14. Apply the Currency number format to cells B28:H28 and cell B29. ****NOTE: the 'formulas' aspect is very vital in the correct completion of this spreadsheet.****