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

WRITE MY ESSAY

Please see attached an excel workbook to work form. See below the list of instructions on how to complete the workbook. Task
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 Start with the “Test Your Skills” worksheet
Add a Fake ID using Auto Fill in column AHint: Column should read from numbers 1 through 56
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
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)
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
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)
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
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
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
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

WRITE MY ESSAY