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

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
wa.me/message/...
Whatsapp Contact Number:
[phone]
Email ID:
[e-mail]
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."
Break links to an external workbook.
2. In cell C5, remove the hyperlink, leaving the unlinked text "Bozeman, MT" in the cell.
Remove a hyperlink.
3. "In cell D7, create a hyperlink to an email address as follows:
a. Link to the email address:
[e-mail]
b. Use [e-mail] as the text to display.
c. Use Email the statewide manager for Washington as the ScreenTip text."
Hyperlink to an email address.
Set the display text as a hyperlink.
Set the ScreenTip for a hyperlink.
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."
Add a hyperlink to an external workbook.
Set the display text for a hyperlink.
Set the ScreenTip for a hyperlink.
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."
Set the display text for a hyperlink.
Set the ScreenTip for a hyperlink.
6. "Edra wants to apply consistent formatting to the worksheets submitted by each of the statewide managers. Group the Idaho, Montana, and Oregon worksheets together and then make the following formatting updates:
a. Change the font size in the merged range A1:F1 to 18 point.
b. Apply the 20% - Accent 6 cell style to the merged range A2:F2.
c. Bold the values in the range A6:A10.
d. Apply the Accounting number format with zero decimal places and $ as the symbol to the range B6:F10.
e. Resize the column width of column B-F to 12. Do not ungroup the worksheets."
Change the font size.
Apply a cell style.
Change the font style.
Change the number format.
Change the column width.
7. "With the Idaho, Montana, and Oregon worksheets still grouped, update the worksheet as follows:
a. In cell A6, change the text ""In Person"" to read:
Walkup
b. In cell A9, change the text ""Other"" to read:
Other referrals
Do not ungroup the worksheets."
Update a value in a cell.
Update a value in a cell.
8. "With the Idaho, Montana, and Oregon worksheets still grouped, create a formula as follows:
a. Enter a formula in cell B10 using the SUM function that totals the sales for Q1.
b. Copy the formula to the range C10:E10.
Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 6-8 are present in all three worksheets."
Create a formula using a function.
Copy a formula into a range.
9. "Edra wants to create a copy of the formatted Oregon worksheet to use for the Washington section of the chain's sales data. Create a copy of the Oregon worksheet between the Oregon worksheet and the Consolidated Sales worksheet, and then update the worksheet as follows:
a. Change the worksheet name to Washington for the copied worksheet.
b. Edit the text to read Washington in the merged range A2:F2.
c. Clear the contents of the range B6:E9."
Copy a worksheet to a specific location.
Change the name of a worksheet.
Update a value in a cell.
Clear cell contents.
10. "Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows: