The Range Free Foods Corporation began operation last year in Phoenix by opening three stores in…

The Range Free Foods Corporation began operation last year in Phoenix by opening three stores in different areas of the city. The manager of each store prepared a workbook that summarizes the first-quarter results. As the assistant to the general manager, you need to complete the Downtown workbook, and then link data from the three workbooks to a consolidated workbook. This exercise follows the same set of skills as used in Hands-On Exercises 1 and 2 in the chapter. Refer to Figure 33 as you complete this exercise.

6042c38e fe3a 44b2 9052 328724d0429a

a. Open e08p1downtown, and then save it as e08p1downtown_LastnameFirstname. Click each worksheet tab to see what work has been done and what work you will do. b. Click the Jan worksheet tab, press and hold Shift, click the Mar worksheet tab, and then do the following:

• Click cell A1, click the Home tab, click Fill in the Editing group, and then select Across Worksheets. Click Formats in the Fill Across Worksheets dialog box, and then click OK.

• Select the range B4:F10, and then click Sum in the Editing group.

c. Click the DowntownQtr1 worksheet, click cell B4, and then insert a 3-D formula by doing the following:

• Type =SUM( • Click the Jan worksheet tab, press and hold Shift, and then click the Mar worksheet tab.

• Click cell F4, and then press Ctrl+Enter.

• Double-click the cell B4 fill handle to copy the formula down the column.

d. Open e08p1south and save it as e08p1south_LastnameFirstname, open e08p1north and save it as e08p1north_LastnameFirstname, and then open e08p1quarter1 and save it as e08p1quarter1_ LastnameFirstname.

e. Click the View tab, click Switch Windows in the Window group, and then select e08p1north_ LastnameFirstname.

f. Group the Jan, Feb, and Mar worksheets, right-click a grouped worksheet tab, and then select Hide.

g. Adapt steps e and f to hide the Jan, Feb, and Mar worksheets in e08p1south_LastnameFirstname.

h. Click Switch Windows in the Window group, and then select e08p1quarter1_LastnameFirstname.

i. Click Arrange All in the Window group, click the Windows of active workbook check box to deselect it if necessary, and then click OK in the dialog box.

j. Add links by doing the following:

• Click cell B4 in the Quarter1 worksheet. Type =, display e08p1downtown_LastnameFirstname, click cell B4 in the DowntownQtr1 worksheet, and then press Ctrl+Enter. Edit the formula to change $B$4 to B4. Copy the formula down the Downtown column.

• Click cell C4 in the Quarter1 worksheet. Type =, display e08p1south_LastnameFirstname, click cell B4 in the Qtr1 worksheet, and then press Ctrl+Enter. Edit the formula to change $B$4 to B4. Copy the formula down the South column.

• Click cell D4 in the Quarter1 worksheet. Type =, display e08p1north_LastnameFirstname, click cell B4 in the Qtr1 worksheet, and then press Ctrl+Enter. Edit the formula to change $B$4 to B4. Copy the formula down the North column.

• Format the monetary values with Accounting Number Format with zero decimal places in the Quarter1 worksheet.

k. Click cell B3 in the Quarter1 worksheet, click the Insert tab, click Hyperlink in the Links group, scroll through the list of files, select e08p1downtown_LastnameFirstname.xlsx, and then click OK.

l. Adapt step k to create hyperlinks in cells C3 and C4 to their respective files.

m. Click the View tab, click Save Workspace, type e08p1workspace_LastnameFirstname, and then click Save. Click Save All when prompted to save all workbooks.

n. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the Quarter1 worksheet.

o. Save and close the workbooks, and submit based on your instructor’s directions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Criminal Justice
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452671, May 2nd, 2021
Nursing
Paper much better compared to the one prior revision request. References need to be no more than the past 5 years.
Customer 452547, July 20th, 2021
Sociology
THANK YOUUUUU
Customer 452591, March 18th, 2021
Nursing
Thank you so much for your help! :)
Customer 453167, May 11th, 2022
Psychology
quick, fast and exact!
Customer 453027, May 24th, 2022
IT, Web
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but Theresa did the job correctly. I will use her again to do my essays for sure!
Customer 452967, November 27th, 2021
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
Management
Love this writer!!! Great work
Customer 452597, April 5th, 2021
History
Don't really see any of sources I provided, but elsewise its great, thank you!
Customer 452697, May 8th, 2021
Management
Thank you!!! I received my order in record timing.
Customer 452551, February 9th, 2021
Management
It's the second time I use this service and it does not let me down. Work quality is so good for its price!
Customer 452985, December 3rd, 2021
Psychology
Received before the deadline. Great job!
Customer 453027, January 15th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You