My ITLAB Solutions

Exp22_Excel_Ch01_ML1_Rentals

Exp22_Excel_Ch01_HOE_Souvenirs

Exp22_Excel_Ch01_Cumulative_Medical

New Perspectives Excel 365/2021 | Module 5: SAM Project 1a | NP_EX365_2021_5a | Narbonne Suites


.xlsx

Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?igsh=eXpyM2Ixa3ZmbWZ2

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

Module 5 SAM Project A


Module 5 SAM Project 1a


Module 5 SAM Project A Narbonne Suites


Perspectives Excel 2019 Module 5 SAM Project 1a


cashman excel 2019 module 5 sam project 1a


Suites


REPORTS FROM MULTIPLE WORKBOOKS


.xlsx
.xlsx






PROJECT STEPS
1. Edra Kinsman is the sales manager for Narbonne Suites hotel chain, which has locations in Washington, Oregon, Idaho, and Montana. Edra is using multiple worksheets to summarize sales data by state.
Break the external link in the worksheet, so that the formulas in the range B4:B7 of the Manager Information worksheet are replaced with static values. Then switch to the Manager Information worksheet.
2. In cell C5, remove the hyperlink, leaving the unlinked text "Bozeman, MT" in the cell.
3. In cell D7, create a hyperlink to an email address as follows:
a. Link to the email address:
[email protected]
b. Use [email protected] as the text to display.
c. Use Email the statewide manager for Washington as the ScreenTip text.
4. In cell B9, create a hyperlink to the Narbonne Suites Locations listing as follows:
a. Link to the file Support_EX19_5a_Locations.docx.
b. Use Narbonne Suites locations as the text to display.
c. Use View the current list of Narbonne Suites Locations as the ScreenTip text.
5. Edit the hyperlink in cell B10 as follows:
a. Use Narbonne Suites website as the display text.
b. Use View the public-facing website for Narbonne Suites as the ScreenTip text.

.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx

.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx
.xlsx

Shelly Cashman Excel 365/2021 | Modules 1-3: SAM Capstone Project 1a Ensight Healthcare Consultants

-3a_FirstLastName_1.xlsx
-3a_FirstLastName_2.xlsx
-3a
-3a_FirstLastName
/2021
-3


-EndofModuleProject1
Perspectives Excel 2019
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-EndofModuleProject1
-4-EndofModuleProject1
-8-EndofModuleProject1
-12-EndofModuleProject1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-4a
-8a
-12a
1. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.

Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.
2. In cell J1, enter a formula using the NOW function to display today's date. Apply the Short Date number format to display only the date in the cell.
3. Format the worksheet title as follows to use a consistent design throughout the workbook:
a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color.
b. Change the font color to White, Background 1.
c. Merge and center the contents of cell B2 across the range B2:H2.
d. Use AutoFit to resize row 2 to its best fit.
8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows:
a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.
b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.
c. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F.
9. Carla also wants to show the remaining amount as a percentage of the actual amount. Enter this information as follows:
a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5).
b. Copy the formula in cell H5 to the range H6:H14, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total.
11. Carla also wants to identify the services for which Ensight has billed more than the full estimate amount.

In the range H5:H13, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text.
12. Carla imported data about the consultants working on the Everett Hospital project and stored the data on a separate worksheet, but wants to include the data in the Project Status worksheet.

Copy and paste the data as follows:
a. Go to the Consultants worksheet and copy the data in the range B2:G12.
b. Return to the Project Status worksheet. Paste the data in cell J3, keeping the source formatting when you paste it.
13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows:
a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to

Word Modules 1-4 SAM Capstone Project 1a | Word Capstone Project 1-4 | Wellhaven Insurance Group


-4_SAM_Capstone_Project_1a -4a -4SAMCapstoneProject1a -4 -4SAMCapstoneProject1a -4


Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?igsh=eXpyM2Ixa3ZmbWZ2

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

-4SAMCapstoneProject1a
Perspectives Word 2019 Modules 1-4 SAM Capstone Project 1a
Modules 1-4 SAM Capstone Project 1a

-4SAMCapstoneProject1a
Capstone Project 1-4
-4

Capstone Project 1-4 Wellhaven Insurance Group
-4WellhavenInsuranceGroup

-4a_FirstLastName_1.docx
-4a_FirstLastName_2.docx
-4a
Insurance Group


A CUSTOMER SERVICE HANDBOOK



-4SAMCapstoneProject1a
Cashman Word 2019 Modules 1-4 SAM Capstone Project 1a





PROJECT STEPS
1. As the assistant director of training in the Customer Service Department at Wellhaven Insurance Group, you are completing a handbook for customer service agents. On page 1, rotate the picture to the right by 90° so that it has the correct orientation.
2. Change the theme colors of the document to Paper to coordinate with the company colors.
3. On page 2, insert a Dropped Drop Cap at the beginning of the first body paragraph ("At Your Service is a digital tool…") to mark the beginning of the body text.
4. Provide more detailed information as follows:
a. Find the sentence "Customers prefer using…exchanging email messages."
b. After the period at the end of the sentence, insert a footnote with the following text:
About 55 percent of our customers prefer live chat.
5. Insert a picture as follows to illustrate the options in the At Your Service app:
a. Insert the picture Support_WD19_CS1-4_Icons.png in the blank paragraph after step 2 in the "Getting Started with At Your Service" section.
b. Resize the picture to a width of 2".
6. Add visual interest to the "Chatting with Customers" section as follows:
a. To the left of the "Customers can use…conduct the dialogue." paragraph, insert a Speech Bubble: Rectangle with Corners Rounded shape from the Callouts section of the Shapes gallery. [Mac Hint: Rounded Rectangular Callout]
b. Resize the shape to a height of 0.5" and a width of 0.5".
c. Apply the Colored Fill – Orange, Accent 2 shape style.
d. Type three periods (an ellipses) into the shape.
e. Change the font size of the shape text to 18 point.
f. Apply Square text wrapping to the shape.
g. Move the anchor point of the shape to the beginning of the paragraph "Customers can use At Your Service…."

7. Format the paragraphs in the "Chatting with Customers" section as follows:
a. Create a bulleted list beginning with the paragraph "At Your Service…Can I help you?" and ending with the paragraph "Click the More button…and previous visits."
b. Increase the indent of the paragraph "When you receive…the conversation." and the paragraph "As you type…you are responding." by one level.
8. On page 3, add a border to the picture of the app using the Blue-Gray, Accent 6 border color.
9. Illustrate ways to increase customer satisfaction as follows:


-4SAMCapstoneProject1a
Perspectives Word 2019 Modules 1-4: SAM Capstone Project 1a

-4SAMCapstoneProject1a
Cashman Word 2019 | Modules 1-4: SAM Capstone Project 1a


-7SAMCapstoneProject1a
Perspectives Word 2019 Modules 5-7: SAM Capstone Project 1a

-7SAMCapstoneProject1a