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 .