Question: I need help with 11-14. I have completed question 10 a-e. 10Edra wants to consolidate the data from each of the regions. Switch to the

I need help with 11-14. I have completed question 10 a-e.

  1. 10Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows:
    1. In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet.
    2. Copy the formula from cell A6 to the range A7:A9 without copying the formatting.
    3. In cell B6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B6 in the Idaho:Washington worksheets.
    4. Copy the formula from cell B6 to the range B7:B9 without copying the formatting.
    5. Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9.
  2. 11Edra started to create named ranges in the worksheet and has asked you to complete the work. Make/create defined name for the range B6:E6 using Walkup as the range name.
  3. 12Make/Create names from the range A7:E9 using the values shown in the left column.
  4. 13Apply the defined names Q1_Sales, Q2_Sales, Q3_Sales, and Q4_Sales to the formulas in the range B10:E10 in the Consolidated Sales worksheet.
  5. 14Change the defined name to Totals_2021 for the range F6:F9. [Mac Hint: Delete the existing defined name "Totals" and add the new 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 Mathematics Questions!

Q:

Need this in given time...

Q:

1. Suppose the CEO of your company wants to honor an important employee who contributed exceptionally in the achievement of company goals in 2020. Choose and recommend an employee you would like to...

Q:

Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sai'es worksheet, then update the worksheet as follows: a. in cell A6, enter a formula without using a function...

Q:

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

Q:

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

Q:

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

Q:

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

Q:

Need this in given time...

Q:

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

Q:

I just need help knowing how to copy the formulas without copying the formatting and just how to give multiple defined names to a range at one time. a. 10. Edra wants to consolidate the data from...

Q:

Michael Company is considering the purchase of a large press costing $100,000. The estimated cash inflows before considering the effects of inflation and income taxes are considered follow:...

Q:

Compare and contrast logistics management with supply chain management.

Q:

Katrina has the option of an eight year non - subsidized student loan of 3 2 , 0 0 0 and annual interest rate of 3 . 5 % or an eight year subsidize loan of 3 2 , 0 0 0 and annual interest rate of 4 ....

Q:

Required Identify which of the following items are added to or subtracted from the unadjusted bank balance to arrive at the true cash balance. Distinguish the additions from the subtractions by...

Q:

On January 1, 2017, Kimbel Inc. had these stockholders' equity balances Common Stock, $1 par (2,000,000 shares authorized, 600,000 shares issued and outstanding) .............................$...

Q:

During 2016, Yoko has total capital gains of $8,000 and total capital losses of $16,000. a. What is the effect of the capital gains and losses on Yoko's 2016 taxable income? Explain. b. Assume that...

Q:

Computer Wholesalers restores and resells notebook computers on eBay. It originally acquires the notebook computers from corporations upgrading their computer systems, and it backs each notebook it...

Q:

Top Sound International designs and sells high-end stereo equipment for auto and home use. Engineers notified management in December 2015 of a circuit flaw in an amplifier that poses a potential fire...

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

Hot dogs. A nutrition lab tested 40 hot dogs to see if their mean sodium content was less than the 325-mg upper limit set by regulations for reduced sodium franks. The mean sodium content for the...

Q:

Tax audits. Certified public accountants are often required to appear with clients if the IRS audits the clients tax return. Some accounting firms give the client an option to pay a fee when the tax...

Q:

AP Stats 2017. The College Board reported that 53.8% of all students who took the 2017 AP Statistics exam earned scores of 3 or higher. One teacher wondered if the performance of her school was...