1. Open the data file EX2016-1-5-Timelog.xlsx. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.

2. 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.

3. Enter the current day and time in cell F2 by using the appropriate formula. Change the formatting to show only the time.

4. Place the current day in cell F3 using the TODAY() function.

5. Calculate the Minimum billable time in cell F5 (this is the least number of hours for any day in the time log).

6. Calculate the Maximum billable time in cell F6 (this is the greatest number of hours for any day in the time log).

7. Use Quick Analysis to highlight any days that had more than 5 billable hours.

8. Change the font of the document title to Verdana, in 26-point size.

9. Save the file. Close the workbook. Chapter 1: Introduction to Microsoft Excel 1 Last updated: 12/15/2017 Project Learn Microsoft Office 2016 Excel REVIEW PROJECT 1.5

10. Upload and save your project file.

11. Submit your project. Step 2 Upload & Save Step 3 Grade my Project Chapter 1: Introduction to Microsoft Excel 2 Last updated: 12/15/2017

Client Project Time Log
				Time Submitted
	Project Day	Hours		Day Submitted
	Day 1	5.3
	Day 2	9.3		Minimum billable time
	Day 3	1.3		Maximum billable time
	Day 4	5.5
	Day 5	1.4
	Day 6	6.4
	Day 7	9.3
	Day 8	3.6
	Day 9	7.6
	Day 10	4.4
	Day 11	3.4
	Day 12	2.9
	Day 13	8.4
	Day 14	2.0
	Day 15	4.3
	Day 16	0.9
	Day 17	2.8
	Day 18	8.5
	Day 19	2.7
	Day 20	4.7
	Day 21	4.9
	Day 22	7.9
	Day 23	7.7