GETTING STARTED
 Save the file SC_EX365_2021_EOM2-1_FirstLastName_1.xlsx as
SC_EX365_2021_EOM2-1_FirstLastName_2.xlsx
 Edit the file name by changing “1” to “2”.
 If you do not see the .xlsx file extension, do not type it. The file extension will
be added for you automatically.
 With the file SC_EX365_2021_EOM2-1_FirstLastName_2.xlsx open, ensure
that your first and last name is displayed in cell B6 of the Documentation
worksheet.
 If cell B6 does not display your name, delete the file and download a new copy.
PROJECT STEPS

1. Brad Kauffman is the senior director of projects for Rivera Engineering in Miami,
   Florida. The company performs engineering projects for public utilities and
   energy companies. Brad has started to create an Excel workbook to track
   estimated and actual hours and billing amounts for each project. He asks you to
   format the workbook to make the information clearer and easier to interpret.
   Go to the Employees for Projects worksheet. Change the worksheet theme to
   Office.
2. In cell A1, decrease the font size to 18 point and change the fill color to Blue,
   Accent 1, Lighter 80%.
3. Center the values in the range B3:B9.
4. Add Outside Borders to the range A1:C9.
5. Change the color of the Employees for Projects worksheet tab to Blue, Accent 1.
6. Go to the Project Tracking worksheet. In cell B2, change the date format of cell
   B2 to Short Date and resize column B to its best fit.
7. Display the values in the range D4:D13 with one decimal place.
8. In cell F4, insert a formula without using a function that multiplies Aubrey Irwin’s
   estimated hours (the cell D4) and his pay rate (the cell E4). Fill the range
   F5:F13 with the formula in cell F4.
9. Apply the Currency number format to the range F4:F13 using a dollar sign ($)
   and two decimal places.
10. Display the values in the range K4:K13 as percentages with a percent (%) sign
    and no decimal places. Use Conditional Formatting Highlight Cells Rules to
    format cells containing a value greater than 10% with Light Red Fill with Dark
    Red Text.
11. Cashman Excel 365/2021 | Module 2: End of Module Project 1 11. In the range H4:H13, use Conditional Formatting to create a Data Bars rule with
12. the Gradient Fill Blue Data Bar color option.
13. In cell G14, insert a formula using the AVERAGE function that calculates the
    average amount of actual hours worked (range G4:G13).
14. In cell G15, insert a formula using the MIN function that calculates the
    minimum amount of actual hours worked (range G4:G13).
15. In cell G16, insert a formula using the MAX function that calculates the
    maximum amount of actual hours worked (range G4:G13).