#Modules 1-4: SAM Integration Project 1a(Wellpoint Medical Clinic) #NP_EX19_1-4a #SAM_Module_1-4 #New_Perspectives_Office_2019
Contact us:
Gmail: myitlab23@gmail.com
WhatsApp 1: +92 3075327614
WhatsApp 2: +92 3176380514
WhatsApp Link:
[ Ссылка ]
Contact me Through Instagram:
[ Ссылка ]
Follow me On my Facebook Page:
[ Ссылка ]
Follow me on My Twitter Account
[ Ссылка ]
We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more
We will help you with weekly quizzes, assignments, exams, thesis writing, Dissertation writing and Technical Writing.
#Modules 1-4: SAM Integration Project 1a(Wellpoint Medical Clinic) #NP_EX19_1-4a #SAM_Module_1-4
#New Perspectives Office 2019 | Modules 1-4: SAM Integration Project 1a
Wellpoint Medical Clinic
INTEGRATE EXCEL, ACCESS, WORD, AND POWERPOINT DATA
GETTING STARTED
• Open the files NP_EX19_1-4a_FirstLastName_1.xlsx and NP_PPT19_1-4a_FirstLastName_1.pptx, available for download from the SAM website.
• Save the file NP_EX19_1-4a_FirstLastName_1.xlsx as NP_EX19_1-4a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Save the file NP_PPT19_1-4a_FirstLastName_1.pptx as NP_PPT19_1-4a_FirstLastName_2.pptx by changing the “1” to a “2”.
o If you do not see the .pptx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
o Support_AC19_1-4a_Studies.accdb
o Support_PPT19_1-4a_Heart.png
o Support_WD19_1-4a_Hypertension.docx
• With the file NP_EX19_1-4a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
1. Margarita Romero is the clinic manager for the Wellpoint Medical Clinic in Columbia, Maryland. The clinic has recently completed its first year of operation, and Margarita is using an Excel workbook to prepare for the annual report, which will include data about revenue and the clinic's health studies. She asks for your help to calculate totals, incorporate data from Access, and insert charts to complete the workbook.
Open your Excel Project file workbook, go to the Department worksheet, and then rename the worksheet to use the more descriptive Department Analysis as the worksheet name.
2. Format and insert data in the first two rows as follows to provide a date and a more striking worksheet title:
a. In cell B1, apply the Title cell style.
b. Enter the date 7/29/21 in cell C2.
c. Using the Number Format list, apply the Short Date number format to cell C2 to display the date with a four-digit year.
3. Margarita wants to format cell A4 to match cells A12, A19, and A27. Format the cell as follows:
a. Merge and center the range A4:A9.
b. Rotate the text up so it reads from bottom to top.
c. Change the fill color of the cell to Lime, Accent 2, Lighter 60%.
d. Middle-align the text.
e. Autofit column A to reduce the width of the worksheet contents.
4. Format the Quarterly Revenue and Projected Revenue data as follows to make it easier to read:
a. In the ranges C5:F5 and C9:F9, apply the Accounting number format.
b. Copy the formatting from the range B5:H9 to the range B20:H24 so that the format of the Projected Revenue data matches the format of the Quarterly Revenue data.
5. In the range H5:I9, Margarita wants to calculate the annual revenue per department and show the percentage each department contributed to total revenue. Insert formulas to provide these calculations as follows:
#NP_PPT19_1-4a_FirstLastName
o Support_AC19_1-4a_Studies.accdb
o Support_PPT19_1-4a_Heart.png
o Support_WD19_1-4a_Hypertension.docx
