As PureAssignment official, we help students from all around the world with their Excel projectssam critical thinking capstone project c Assignment is only one of them! If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.

Instructions Related with Excel Project on MindTap

  • Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building a workbook that summarizes income and expenses for the organization.
    Change the theme of the workbook to Office.
  • Switch to the Departments worksheet, which contains a header and several tables that need to be completed and formatted. Columns C through H could use a bit more room. Change the width of columns C through H to 12.00 characters.
  • Change the height of the first row to 21 points.
  • Merge and center the contents of the second row to match the merged range in the first row.
  • Format the newly merged range using the 40% – Accent 5 cell style, Bold formatting, and a 14 point font size.
  • The first few headings of the Staff table need to be entered. Enter the data shown in Table 1 in the appropriate cells.

*   Table 1: Data for the Range A5:E5


Table Formatting help within Microsoft Excel

  • Format the headings in the Staff table as follows:
    • Center the headers and change the font size to 11 piont.
    • Change the background color to one shade darker than the subtitle in the second row, and then wrap the text.
  • From the CCU abbreviation to the end of the table (including the total row), add a White, Background 1 border to all sides of each cell. Be sure to include the total row.
  • Add a thin top border to the total row (including the abbreviation column) using the Automatic color.
  • Format the last three columns of the staff table data (not including the total row).
    • Display the turnover percentage data as a percentage with no decimal places.
    • Use a conditional formatting rule to highlight departments with a turnover rate greater than 24 percent using the default formatting.
  • Use a conditional formatting rule to add solid orange data bars to the data for the 2021 budget. Don’t include the total row.
  • Finish by adding conditional formatting rules to the change from 2020 data that highlights the top and bottom 10% of values. Show the top 10% of values as green fill with dark green text and the bottom 10% of values as light red fill with dark red text.
  • The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out.

Excel Function Help on Microsoft Excel 2019

  • To begin, next to the cell listed “Department”, use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation.
  • Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column.
  • In the appropriate cell below the staff table, use a function to display the current date without displaying the time.
  • The averages will not be needed, so delete column O.
  • The date for the next update isn’t certain, so hide row 18.
  • Switch to the Budget worksheet, which contains the department budgets from 2018 to 2022. There’s already a pie chart showing 2018 budget information, and Carmelo wants another one to compare.
    Create a 2-D pie chart based on the data in the Department and 2022 columns. Move the chart so that it covers the range H4:O22. Use the third chart style, and use 2022 Budget by Department as the chart title.
  • The pie chart for 2018 now needs to be changed. Format this chart the same way as the 2022 chart.
  • The Departmental Budget Comparison 2018-2022 combo chart needs to be updated as well.
    • Change the minimum bounds of the right vertical axis to 40,000,000, and then add axis titles to the chart.
    • Use Department Budgets as the left vertical title, use Total Budget as the right vertical title, and remove the horizontal axis title.
    • Apply a shape fill to the chart using the Blue, Accent 5, Lighter 80% fill color.
  • The Hiring worksheet won’t be needed, so delete it from the workbook.

Where to start to get The Best Excel Homework Help Service?

Choose PureAssignment for reliable, secure, and high-accuracy online Excel help services that guarantee your academic success. If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.


Author Since: 08/08/2020

My name is Engin. I am the founder of pureassignment, a traveller, fitness lover and a cat person.

Open Whatsapp
Wanna Connect To Live Support?
Hi there. Need help of a real person?
Text now!