BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 33

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.