#### Shelly Cashman Excel 2019 | Module 2: End of Module Project 1 Elvita Da Costa 1

Subject:MS ExcelPrice:20.87 Bought12

# Shelly Cashman Excel 2019 | Module 2: End of Module Project 1Elvita Da Costa1. Brad Kauffman is the senior director of projects for Rivera Engineering in Miami, Florida. The companyperforms engineering projects for public utilities and energy companies. Brad has started to create anExcel workbook to track estimated and actual hours and billing amounts for each project. He asks you toformat the workbook to make the information clearer and easier to interpret.Go to theEmployees for Projectsworksheet. Change the worksheet theme to Office.Change the workbook theme.2. In cell A1, decrease the font size to 18 point and change the fill color to Blue, Accent 1, Lighter 80%.Change the font size.Change the fill color of a cell.3.Center the values in the range B3:B9.Center cell content.4. Add Outside Borders to the range A1:C9.Add a border to a range.5. Change the color of theEmployees for Projectsworksheet tab to Blue, Accent 1.Change the color of a worksheet tab.6. Go to the Project Tracking worksheet. In cell B2, change the date format of cell B2 to Short Date andresize column B to its best fit.Change the date format.Change the column width.7.Display the values in the range D4:D13 with one decimal place.  Change the number format.8. In cell F4, insert a formula using thePRODUCTfunction that multiplies Aubrey Irwin's estimated hoursand his pay rate (the rangeD4:E4). Fill the range F5:F13 with the formula in cell F4.  Create a formula using a function.Copy a formula into a range.9.Apply the Currency number format to the range F4:F13 using a dollar sign (\$) and two decimal places.Change the number format.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 than10%with Light Red Fill with Dark Red Text.Change the number format.Apply a conditional formatting rule.Apply a conditional formatting rule.11.In the range H4:H13, use Conditional Formatting to create a Data Bars rule with the Gradient Fill BlueData Bar color option.Apply a conditional formatting rule that uses data bars.

## 20.87 USD

### Option 2

#### rated 5 stars

Purchased 12 times

Completion Status 100%