Please see attached an excel workbook to work form. See below the list of instru

Please see attached an excel workbook to work form. See below the list of instructions on how to complete the workbook.

Task

1. Download the “Test Your Skills” workbook workbook. This data contains counts of inpatient visits that lead to a discharge to a hospice care facility in 2022. The
2. Start with the “Test Your Skills” worksheet
3. Add a Fake ID using Auto Fill in column A
   • Hint: Column should read from numbers 1 through 56
4. Calculate the total number of inpatient visits that lead to a hospice care facility discharge in cell H6 using the SUM() function.
   • Hint: The sum should be 12077
5. Fill in the percentage column using a formula (format the cells to percentages with 2 decimal points)
   • Hint 1: Remember the percentage is the count of the inpatient visits divided by the total you just calculated in cell H6
   • Hint 2: Remember you need to use absolute referencing (otherwise you’ll receive errors)
6. Calculate the average number of inpatient visits that lead to a hospice care facility discharge in cell H7 using the AVERAGE() function.
   • Hint: The average should be 215.7
7. Use conditional formatting to highlight cells with more than the average in cell H7 in red (make sure your formatting rule doesn’t apply to other columns (only apply to column C)
8. Use conditional formatting color scales to color all the cells in column D with the highest percentages being red and the lowest percentages being green.
   • Note: The cells should automatically have a color scale from bright red to green. If you’re trying to do it manually, then you probably aren’t using the color scale option in conditional formatting
9. Filter the “Test Your Skills” worksheet to show only Los Angeles county — take a screenshot of your worksheet to show me you did this and then clear your filters
10. In the “Summary of Test Your Skills” worksheet, fill in the table using functions that you’ve learned and the information from the “Test Your Skills” worksheet.
    • Total number in B2: Reference cell H6 from the “Test Your Skills” worksheet
    • Highest number in B3: Use the MAX() function with the data in column C of the “Test Your Skills” worksheet
    • Lowest number in B4: Use the MIN() function with the data in column C of the “Test Your Skills” worksheet
    • County name with the highest number in B5: Use the XLOOKUP() function and cell B3 (the highest number you just calculated) to get the county name
11. Make the “Summary of Test Your Skills” worksheet look nice with table styles

Here’s some information to help you double check your calculations:

Submission

Upload the following:

• Completed Excel Workbook (with all changes above)
• Screenshot of your filtering of the “Test Your Skills” worksheet from step 9