Скачать или смотреть New Perspectives Excel 2019 | Module 5: SAM Critical Thinking Project 1c

New Perspectives Excel 2019 | Module 5: SAM Critical Thinking Project 1c #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

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.

PROJECT STEPS
1. Edra Kinsman is the sales manager for the 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 workbook, so that the formulas in the table on the Manager Information worksheet are replaced with static values. Then switch to the Manager Information worksheet.
2. Remove the hyperlink in the Location column, leaving the unlinked text "Bozeman, MT" in the cell.
3. For the Washington manager, 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 the cell above the website link, create a hyperlink to the Narbonne Suites Locations listing as follows:
a. Link to the file Support_EX19_CT5c_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 website hyperlink 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.
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 of the Narbonne Suites heading to 18 point.
b. Apply the 20% - Accent 6 cell style to the heading with the state name.
c. Bold the four sales categories as well as the label for the total row.
d. Apply the Accounting number format with zero decimal places and the $ symbol to all of the numerical data.
e. Resize the width of columns B-F to 12. Do not ungroup the worksheets.
7. With the Idaho, Montana, and Oregon worksheets still grouped, update the worksheet as follows:
a. Change the text "In Person" to read: Walkup
b. Change the text "Other" to read: Other referrals
Do not ungroup the worksheets.
8. With the Idaho, Montana, and Oregon worksheets still grouped, create a formula as follows:
a. Use a function to total the sales for Q1.
b. Use the same function to fill the remaining sales totals. Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 5-8 are present in all three worksheets.
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 copied worksheet as follows:
a. Change the worksheet name to Washington for the copied worksheet.
b. Edit the state heading text to read Washington.
c. Clear the quarterly numerical data for the four sales categories. Be sure to leave the totals.
10. Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, and then update the worksheet as follows:
a. Without using a function, begin filling in the sales categories using a reference to cell A6 in the Washington worksheet .
b. Without copying the formatting, use a similar reference to fill the remaining sales categories.
c. Enter a function using 3-D references and grouped worksheets to total the Q1 walkup sales from the Idaho through Washington worksheets.
d. Without copying the formatting, use a similar function to fill the remaining Q1 sales values.
e. Use a similar function to fill the remaining quarterly sales values, filling the formatting.
11. Edra started to create named ranges in the worksheet and has asked you to complete the work. Create a defined name for the quarterly walkup values using Walkup as the range name.
12. In a similar way, create names for the other sales categories' quarterly values using the categories as the range names.
13. Modify the quarterly sales totals by using the existing defined names Q1_Sales, Q2_Sales, Q3_Sales and Q4_Sales

14. Change the existing defined name from Total to Totals_2021. [Mac Hint: Delete the existing defined name "Total" and add the new defined name.]