Question: Excel Assessment Instructions:Use the Microsoft Excel file, HIT 1 0 1 _ Excel Worksheet attached to this learning module, to complete the following tasks:Go to

Excel Assessment Instructions:Use the Microsoft Excel file, HIT 101_Excel Worksheet attached to this learning module, to complete the following tasks:Go to the Audit List worksheet tab and make the following changes:1.Change the font in cells A1, B1, C1, D1 to Bold 2.Change the cell color in A1 to Blue, Accent 1, Lighter 80%3.Insert a new row at row 10(your new row should become row 10).4.In the new row, input 000123 in the MR Number column, 9/28/2022 in the Discharge Date column, 4 in the LOS column, and 292 in the DRG Column5.Create a formula in cell C23 to show the total LOS Days (SUM) Go to the Report worksheet tab and make the following changes:6.Format that data set as a table. Format the table to Light Blue, Table Style Light 27.Filter the LOS column to show value of 6 in your table (note, you should see 4 cases)Go to the Discharges worksheet tab and make the following changes:8.Create a bar graph using the data set on the Discharges tab9.Change the bar graph design to Style 410.Change the graph title to Number of Discharges in 2021

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!