BIS 155 Endless Education /uophelp.com BIS 155 Endless Education /uophelp.com | Page 22

For more course tutorials visit www. uophelp. com

For more course tutorials visit www. uophelp. com

The owner of Carina ' s Pizza, wants to evaluate the profitability of the three restaurants before expanding further. They are particularly interested in the comparative results of three dining categories, dinein, pickup, and delivery. Carina has asked for your help in doing this analysis in return for a small stipend and all the pizza you can eat. You have already prepared a template and distributed it to each restaurant manager, who has entered the sales data for last year. Your next task is to consolidate the data into a single workbook that shows the total sales for each quarter and each dining category. The information should be shown in tabular, as well as graphical formats. You will also create a documentation sheet so that Joe will know exactly what you have created. Lab Steps STEP 1: Open all Worksheets and consolidate into a summary worksheet. You will be using Week5 _ Lab5 _ Carinas _ Summary _ Student. xlsx the partially completed Summary workbook and the completed Northside Workbook, Southside Workbook, and Downtown Workbook. Consolidate the data from the three completed worksheets into the Summary workbook( Week5 _ Lab5 _ Carinas _ Summary _ Student. xlsx). A. The individual worksheets for the three locations have been placed in the single workbooks( Northside, Southside and Downtown) for you. Be sure to practice the copying feature from multiple workbooks, as shown in the tutorial videos. B. Using the Consolidate feature and perform a summary consolidation of the three locations into the provided summary worksheet page. C. Rename the file that includes your consolidated summary worksheet. File naming convention: If your name is Jane Doe, then your files should be named very similar to: Doe _ J _ Week5 _ iLab. xlsx. D. Close the Northside, Southside and Downtown Workbooks. Leave your Summary workbook open.