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

Organization, Planning and Consolidation Strategies (TCO’s 5, 7, & 8;
40 Points) Using the ‘Quest 5 – Organizing Data’ worksheet:
Consolidate the information on the Quest 5-Organizing Data sheet
from the three (3) worksheets (DC Branch, Houston Branch, and LA
Branch), using consolidation strategies that include:
Group sheets and use the auto-fill to complete the list of months in
Column A and add totals for rows and columns.
Apply formatting to column headings and merge and center a title
across row 1 for each sheet.
Open the blank worksheet, Quest 5-Organizing Data, and on the data
tab click consolidate.
Choose the sum function to sum the data.
Add each worksheet to the consolidated Summary.
As an alternative to steps 3-5 above, use 3-D referencing to
summarize the data.
Add row and column summary totals on the Quest 5-Organizing Data
Worksheet.
Summarize your results using an appropriate chart type and place it
below the summarized data.
Spell check the worksheet.
Save yo ur work (CTRL+s).
Analysis, Summary and Recommendation (TCO’s 8, and 9; 30 Points).