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 .