You're in the process of using PivotTables to analyze a report of consulting hours for recent projects. Perform the following actions:

$1.$ On the Format sheet, change the values to show the Average hours and display the values as Numbers with no decimal places, but with the thousands separator.

$2.$ On the Group sheet, group the hours data in increments of $300,$ starting at $550$and ending at $3500,$ to see the distribution of data.

$3.$ On the Revenue sheet, add a field called Revenue that is calculated by multiplying Hours by Price per Hour.

$4.$ On the Analyze sheet, add a slicer on Product and select Incident Mgmt

In this scenario, you'll use the appropriate Excel features to format cell values, automate date entry, and fix errors. Perform the following actions:

$1.$ On the Projects sheet, apply green data bars to the values in cells H$2$:H$50.$

$2.$ On the Projects sheet, modify the conditional formatting rule for cells F$2$:F$50$ to only highlight items in the west with a gross profit greater than or equal to $$200,000.$

$3.$ Select the Scorecard sheet and record a simple macro named Insert Date Row to do the following:

o Insert a new row at the top of the active worksheet.

o Use the TODAY$()$ function to add the current date in cell A$1.$

$4.$ On the Error sheet, find the cell with an error and fix it using the formula bar.