excel capstone project 1 4

Modules 1-4 - SAM Capstone Project 1a

Description

Topics covered in this video:

• 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.
• On the Departments worksheet, change the width of columns C through H to 12.00 characters.
• Change the height of row 1 to 21 points.
• Merge and center the contents of the range A2:J2.
• Format the merged range A2:J2 as described below: a. Apply the 40% - Accent 5 cell style. b. Apply bold formatting. c. Change the font size to 14.
• Enter the values shown in Table 1 into the corresponding cells in the range A5:E5. Table 1: Data for the Range A5:E5

A B C D E 5 Abbreviation Department MD RN Support

• Format the range A5:J5 as described below: a. Center cell contents. b. Change the font size to 11 pt. c. Change the background color to Blue, Accent 5, Lighter 40% (9th column, 4th row of the Theme Colors palette). d. Apply Wrap Text to the text in each cell.
• Select the range A6:J14 and then add a White, Background 1 border to all sides of each cell.
• Select the range A14:J14 and then add a thin top border to each cell using the Automatic color.
• Select the range H6:H13 and then format the range as described below: a. Format the range with the Percentage number format with zero decimal places. b. Add a Highlight Cells conditional formatting rule that formats cells that are greater than 0.24 as light red fill with dark red text.
• Select the range I6:I13 and then use conditional formatting to add solid orange data bars.
• Select the range J6:J13 and then add top/bottom conditional formatting rules to format 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.
• Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column).
• Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L.
• In cell C17, enter a formula using the TODAY function that displays the current date.
• Delete column O.
• Hide row 18.
• On the Budget worksheet, create a 2-D pie chart based on the non-adjacent range A5:A12 and F5:F12. Modify the chart as described below: a. Resize and reposition the chart so that the upper-left corner is located within cell H4 and the lower-right corner is located within cell O22. b. Apply Chart Style 3 to the chart. c. Enter 2022 Budget by Department as the chart title.
• In the 2018 Budget by Department 2-D pie chart (located in the range H23:O43), make the following changes: a. Change the data labels to display only the percentage and a label position of Center. (Hint: Select Reset Label Text to remove category names) b. Reposition the legend on the right side of the chart.
• Update the Departmental Budget Comparison 2018-2022 combo chart in the range A15:G36 as follows: a. Change the minimum bound of the right vertical axis to 40,000,000. b. 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. c. Apply a shape fill to the chart using the Blue, Accent 5, Lighter 80% fill color.
• Delete the Hiring worksheet.

Support 💖 Buy me a coffee: https://www.buymeacoffee.com/taandar Join Patreon: https://www.patreon.com/Taandar

#cengage #solutions #sam #excel

Disclaimer: Our videos are intended solely for educational purposes, with the goal of assisting students in understanding how to solve problems in various courses. We want to emphasize that any attempt to copy or replicate the solutions shown in these videos may be regarded as a breach of academic integrity policies at your college or university. We strongly recommend that you use these videos as a guide and as a tool to support your learning, but we urge you to complete your assignments independently and refrain from cheating or plagiarism. Please be aware that we are not liable for any consequences resulting from the misuse of these videos in violation of academic integrity policies.

1 00:00:00,000 --> 00:00:04,980 so this is Capstone project 1A and step

2 00:00:03,179 --> 00:00:06,720 1 it is saying

This is member-only video. Contact [email protected] if you are confused.

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.

Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.

• Homework Q&A
• Become a Tutor

All Subjects

Mathematics

Programming

Health & Medical

Engineering

Computer Science

Foreign Languages

Access over 35 million academic & study documents

New perspectives excel 2019 modules 1-4 sam capstone project 1a.

Sign up to view the full document!

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

Similar Documents

working on a study question?

Studypool is powered by Microtutoring TM

Copyright © 2024. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

Access over 35 million study documents through the notebank

Get on-demand Q&A study help from verified tutors

Read 1000s of rich book guides covering popular titles

Sign up with Google

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

August 2024 updates for Microsoft Office

Introduction.

Microsoft released the following security and nonsecurity updates for Office in August 2024. These updates are intended to help our customers keep their computers up to date. We recommend that you install all updates that apply to you.

To download an update, select the corresponding Knowledge Base article in the following list, and then go to the "How to download and install the update" section of the article.

List of Office updates released in August 2024

Microsoft office 2016.

SharePoint Server Subscription Edition

Microsoft SharePoint Server 2019

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.