Illustrated office 2019 Module 1-3 Sam Integration Project 1a | Wellpoint Medical Clinic

If you directly want to get the project from us then contact us on our Whatsapp. Link is given below,
wa.me/message/...
Whatsapp Contact Number:
[phone]
Email ID:
[e-mail]
#newperspective #powerpointpresenation #powerpointinfographics #samprojects #textbookprojects
Project Steps
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."
Change the name of a worksheet.
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."
Apply a cell style.
Enter a date in a cell.
Change the date format.
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."
Merge and center a range.
Change the orientation of cell content.
Change the fill color of a range.
Align cell content vertically.
Change the column width.
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."
Change the number format.
Copy and paste formatting.
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:
a. In cell H5, enter a formula using the SUM function to calculate the total revenue for the General Medicine Department (range C5:F5).
b. Copy the formula without formatting from cell H5 to the range H6:H9.
c. In cell I5, enter a formula without using a function that divides the General Medicine total in cell H5 by the annual total in cell H9 to display the department's percentage of total revenue. Use an absolute reference for cell H9, and then copy the formula without formatting from cell I5 to the range I6:I9.
d. To display more precise percentages, increase the number of decimal places in the range I5 to I9 to show one decimal place."
Create a formula using a function.
Copy a formula into a range without formatting.
Create a formula without using a function.
Use an absolute reference in a formula.
Copy a formula into a range without formatting.
Change the number format.
6. "Margarita also wants to show the average, maximum, and minimum revenue amounts per department and for all departments. Calculate these statistics in the range J5:L9 by entering formulas as follows:
a. In cell J5, enter a formula using the AVERAGE function to average the quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell J5 to the range J6:J9.
b. In cell K5, enter a formula using the MAX function to find the maximum quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell K5 to the range K6:K9.
c. In cell L5, enter a formula using the MIN function to find the minimum quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell L5 to the range L6:L9."