Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROJECT SIEPS Danny Chase is a finance assistant for Wilmington Critical Care in Wilmington, NC . Her current project is to format departmental data for
PROJECT SIEPS
Danny Chase is a finance assistant for Wilmington Critical Care in Wilmington, NC Her current project is to format departmental data for the years to make it easier to analyze.
Switch to the Cancer Center worksheet. Unfreeze the top row of the worksheet.
Sort the table data first in ascending order by the Admission column and then in ascending order by the Service column.
Insert a total row in the table, and then calculate the totals for the and columns.
The administrator overseeing the cancer center is considering mandating that all inpatient service names be different from outpatient service names, and wants to see which duplicate names are currently in use.
Apply a conditional formatting rule to service names that uses light red fill with dark red text for duplicate values. Don't include the total row since there's no value there.
Switch to the Cardiac Care worksheet. Freeze the first column of the worksheet.
The data on this worksheet is not formatted like the other worksheets. Format the headings and the data as an Excel table with headers using the same style as the table on the Cancer Center worksheet. Enter CardiacCare as the name of the table.
Danny notices that the CardiacCare table is missing a record. Add the record shown in Table to the bottom of the CardiacCare table.
Table : Missing Record for CardiacCare Table
tableDepartmentAdmission,Service,tableCardiacCareInpatient,Other,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started