PHS CyberSchool

Computer Studies SG

Modified 30 September 2003

Pivot table of software reported inWord

1. Copy the file Software.xls to your own drive.
2. Insert a row at the top of the sheet with the headings Type, Object, Price, Supplier, Web address and SA Computer Magazine Edition.  Make the headings bold.
3. In the last few tasks (Stock costs, Stock counts) you have used the SumIf and CountIf functions and formulaes to find the costs and numbers of things.  It could be done so quickly and simply using a pivot table.
4. Create a pivot table showing the Type and total Prices.  Look at the tip sheet for Excel PivotTable. 
5. Create some new pivot tables.  Explore - be creative.
6. Open Word, and a new file.
   1. Do a Copy / Paste from Excel to Word of one simple pivot table. 
      1. Insert a caption below the table with the label Table whatever it is (Insert / Caption). 
      2. Leave an open line, then add 1 or 2 lines of text to explain the table. 
      3. In the sentences about the table add a Cross-reference to refer to the table by number (Insert / Cross-reference).  Make sure the cross-reference is to Only label and number.
   2. Do a Copy / Paste from Excel to Word of another simple pivot table. 
      1. Insert a caption below the table with the label Table whatever it is (Insert / Caption). 
      2. Leave an open line, then add 1 or 2 lines of text to explain the table. 
      3. In the sentences about the table add a Cross-reference to refer to the table by number (Insert / Cross-reference).  Make sure the cross-reference is to Only label and number. 
   3. Do a Copy / Paste from Excel to Word of a pivot table with more than one criteria on the left, i.e. more than one criteria in the rows section.
      1. Insert a caption below the table with the label Table whatever it is (Insert / Caption). 
      2. Leave an open line, then add 1 or 2 lines of text to explain the table. 
      3. In the sentences about the table add a Cross-reference to refer to the table by number (Insert / Cross-reference).  Make sure the cross-reference is to Only label and number. 
7. In File / Properties add your name as the author.
8. Add a footer to the Word document with your name, date and page number.
9. Format the table, caption and text according to the Word processing evaluation rubric.
10. Add an automatically created Table of Tables at the beginning of the document. 
11. Print and submit.  You may physically hand it in or fax it to school.

Return to  Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.