Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Open the file NP EX 1 9 5 a FirstLastName 1 xlsx , available for download from the SAM website Save the file as NP EX 1 9 5 a 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 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 EX 1 9 5 a 2 0 2 0 Sales xlsx o Support EX 1 9 5 a Locations docx With the file NP EX 1 9 5 a FirstLastName 2 xlsx still open, ensure that your first and last name is displayed in cell B 6 of the Documentation sheet o If cell B 6 does not display your name, delete the file and download a new copy from the SAM website When opening your start file or the Graded Summary Report, you may be prompted to update the links Select Don't Update in the dialog box 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 B 4 B 7 of the Manager Information worksheet are replaced with static values Then switch to the Manager Information worksheet 2 In cell C 5 , remove the hyperlink, leaving the unlinked text Bozeman, MT in the cell 3 In cell D 7 , create a hyperlink to an email address as follows a Link to the email address washingtonmgr example com b Use washingtonmgr example com as the text to display c Use Email the statewide manager for Washington as the ScreenTip text 4 In cell B 9 , create a hyperlink to the Narbonne Suites Locations listing as follows a Link to the file Support EX 1 9 5 a 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 B 1 0 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 in the merged range A 1 F 1 to 1 8 point b Apply the 2 0 Accent 6 cell style to the merged range A 2 F 2 c Bold the values in the range A 6 A 1 0 d Apply the Accounting number format with zero decimal places and $ as the symbol to the range B 6 F 1 0 e Resize the column width of column B F to 1 2 Do not ungroup the worksheets 7 With the Idaho, Montana, and Oregon worksheets still grouped, update the worksheet as follows a In cell A 6 , change the text In Person to read Walkup b In cell A 9 , 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 Enter a formula in cell B 1 0 using the SUM function that totals the sales for Q 1 b Copy the formula to the range C 1 0 E 1 0 Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 6 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 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 A 2 F 2 c Clear the contents of the range B 6 E 9 1 0 Edra wants to consolidate the data from each of the regions Switch to the Consolidated Sales worksheet, then update the worksheet as follows a In cell A 6 , enter a formula without using a function that references cell A 6 in the Washington worksheet b Copy the formula from cell A 6 to the range A 7 A 9 without copying the formatting c In cell B 6 , enter a formula using the SUM function, 3 D references, and grouped worksheets that totals the values from cell B 6 in the Idaho Washington worksheets d Copy the formula from cell B 6 to the range B 7 B 9 without copying the formatting e Then copy the formulas and the formatting from the range B 6 B 9 to the range C 6 E 9 1 1 Edra started to create named ranges in the worksheet and has asked you to complete the work Create a defined name for the range B 6 E 6 using Walkup as the range name 1 2 Create names from the range A 7 E 9 using the values shown in the left column 1 3 Apply the defined names Q 1 Sales, Q 2 Sales, Q 3 Sales, and Q 4 Sales to the formulas in the range B 1 0 E 1 0 in the Consolidated Sales worksheet 1 4 Change the defined name

The Answer is in the image, click to view ...

Question: Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Open the file NP _ EX 1 9 _ 5 a _ FirstLastName _ 1 .

Narbonne Suites

GENERATING REPORTS FROM MULTIPLE WORKBOOKS

GETTING STARTED

Open the file NP

_

19_5

_

FirstLastName

_1 .

xlsx

,

available for download from the SAM website.

Save the file as NP

_

19_5

_

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.

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

_

19_5

_2020_

Sales.xlsx

o Support

_

19_5

_

Locations.docx

With the file NP

_

19_5

_

FirstLastName

_2 .

xlsx still open, ensure that your first and last name is displayed in cell B

6

of the Documentation sheet.

o If cell B

6

does not display your name, delete the file and download a new copy from the SAM website.

When opening your start file or the Graded Summary Report, you may be prompted to update the links. Select Don't Update in the dialog box.

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 B

4

7

of the Manager Information worksheet are replaced with static values. Then switch to the Manager Information worksheet.

2 .

In cell C

5,

remove the hyperlink, leaving the unlinked text "Bozeman, MT

"

in the cell.

3 .

In cell D

7,

create a hyperlink to an email address as follows:

.

Link to the email address:

washingtonmgr@example.com

.

Use washingtonmgr@example.com as the text to display.

.

Use Email the statewide manager for Washington as the ScreenTip text.

4 .

In cell B

9,

create a hyperlink to the Narbonne Suites Locations listing as follows:

.

Link to the file Support

_

19_5

_

Locations.docx.

.

Use Narbonne Suites locations as the text to display.

.

Use View the current list of Narbonne Suites Locations as the ScreenTip text.

5 .

Edit the hyperlink in cell B

10

as follows:

.

Use Narbonne Suites website as the display text.

.

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:

.

Change the font size in the merged range A

1

1

18

point.

.

Apply the

20 % -

Accent

6

cell style to the merged range A

2

2 .

.

Bold the values in the range A

6

10 .

.

Apply the Accounting number format with zero decimal places and $ as the symbol to the range B

6

10 .

.

Resize the column width of column B

-

F to

12 .

Do not ungroup the worksheets.

7 .

With the Idaho, Montana, and Oregon worksheets still grouped, update the worksheet as follows:

.

In cell A

6,

change the text

"

In Person" to read:

Walkup

.

In cell A

9,

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:

.

Enter a formula in cell B

10

using the SUM function that totals the sales for Q

1 .

.

Copy the formula to the range C

10

10 .

Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps

6 - 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 worksheet as follows:

.

Change the worksheet name to Washington for the copied worksheet.

.

Edit the text to read Washington in the merged range A

2

2 .

.

Clear the contents of the range B

6

9 .

10 .

Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows:

.

In cell A

6,

enter a formula without using a function that references cell A

6

in the Washington worksheet.

.

Copy the formula from cell A

6

to the range A

7

9

without copying the formatting.

.

In cell B

6,

enter a formula using the SUM function,

3 -

D references, and grouped worksheets that totals the values from cell B

6

in the Idaho:Washington worksheets.

.

Copy the formula from cell B

6

to the range B

7

9

without copying the formatting.

.

Then copy the formulas and the formatting from the range B

6

9

to the range C

6

9 .

11 .

Edra started to create named ranges in the worksheet and has asked you to complete the work. Create a defined name for the range B

6

6

using Walkup as the range name.

12 .

Create names from the range A

7

9

using the values shown in the left column.

13 .

Apply the defined names Q

1_

Sales, Q

2_

Sales, Q

3_

Sales, and Q

4_

Sales to the formulas in the range B

10

10

in the Consolidated Sales worksheet.

14 .

Change the defined name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

City of Bradford Pools GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Save the file NP_EX365_2021_EOM5-2_FirstLastName_1.xlsx as NP_EX365_2021_EOM5-2_FirstLastName_2.xlsx Edit the file...

GETTING STARTED - Open the file NP_EX365_2021_5a_FirstLastName_1.xlsx, available for download. - Save the file NP_EX365_2021_5a_FirstLastName_1.xisx as NP_EX365_2021_5a_FirstLastName_2.xIsx Edit the...

GETTING STARTED Open the file NP_EX365_2021_5a_FirstLastName_1.xlsx, available for download. Save the file NP_EX365_2021_5a_FirstLastName_1.xlsx as NP_EX365_2021_5a_FirstLastName_2.xlsx Edit the file...

I need help figuring this out 2. in ce 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...

Can you please help me with the following? Than you Create names from the range A7:E9 using the values shown in the left column. Apply the defined names Q1_Sales , Q2_Sales , Q3_Sales , and Q4_Sales...

PROJECT STEPS 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...

1 . In cell C 5 , remove the hyperlink, leaving the unlinked text "Bozeman, MT " in the cell. 2 . In cell D 7 , create a hyperlink to an email address as follows: a . Link to the email address:...

5 . Edit the hyperlink in cell B 1 0 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...

how to to do 10a & 10b? a. b. c. New Perspectives Excel 2019 | Module 5: SAM Project la 10. Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet,...

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...

Which of the following is true of a variable cost? a. Unit variable cost decreases with an increase in production. b. Total variable cost decreases with an increase in the number of goods sold. c....

Describe the structure of the FASB. Where does the FASB get its operating funds?

In September, Widhone Industries sold 8 2 0 units of product. The average unit seling price wan $ 4 5 . During the month, fand costs were 5 7 , 4 3 4 and variatle costs were 6 0 % of nales ( a ) Kour...

Within a continuously competitive global business environment, publicly held companies face constant pressure to generate and report positive financial results. Unfortunately, some leaders may be...

=+2. In contemporary discussions, we often hear that government should run like

=+3. To what extent is there evidence of an AA culture actively promoting social equity and diversity in the workforce and among management?

=+1. Why do some managers seek to get around the rules of civil service systems?