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 your work( CTRL + s). Analysis, Summary and Recommendation( TCO’ s 8, and 9; 30 Points).