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 Excel Worksheet attached to this learning module, to complete the following tasks:Go to the Audit List worksheet tab and make the following changes:Change the font in cells A B C D to Bold Change the cell color in A to Blue, Accent Lighter Insert a new row at row your new row should become row In the new row, input in the MR Number column, in the Discharge Date column, in the LOS column, and in the DRG ColumnCreate a formula in cell C to show the total LOS Days SUM Go to the Report worksheet tab and make the following changes:Format that data set as a table. Format the table to Light Blue, Table Style Light Filter the LOS column to show value of in your table note you should see casesGo to the Discharges worksheet tab and make the following changes:Create a bar graph using the data set on the Discharges tabChange the bar graph design to Style Change the graph title to Number of Discharges in
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
