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 ).