Hello, I am asked to create a Pivot Table from a data I already have and I know

Question

Hello, I am asked to create a Pivot Table from a data I already have and I know it correct. Here are the instructions:

"Create a PivotTable from the Checkbook table on the Expenditures sheet, and place it on a new sheet. Rename it to Q7, and move it as the last (i.e., far right) sheet. On Q7 sheet, make the PivotTable to summarize expenditures by category and month. (Hint: Select Date Paid then group by Month.) You can format the PivotTable with any format you want."

Its the last step on my assignment and I'm stuck because I believe I dont really understand what its asking me to show because I dont know where to place what when I get to this screen

Explanation / Answer

Payee Date Paid Check # Category Amount Fred Kaplan 12/2/2013 10227 Payroll $31.00 Rodney Hammer 12/3/2013 10228 Payroll $22 AbC Commercial Printer 11/5/2013 10210 Administration $86.60 No Power& light 11/5/2013 10208 Administration $64.94 Office Warehouse 11/5/2013 10206 Administration $10.67 Robert Eldin 11/5/2013 10207 Payroll $122.16 Crawl Feed Supply 11/5/2013 10212 Feed $526.56 Dr Smith 11/5/2013 10209 Medicine $865.69 Dr Schuler 11/5/2013 10211 Vet $25.00 Postmaster 12/6/2013 10228 Administration $68.00 Office Warehouse 12/7/2013 10230 Administration $44.95 No Power& light 11/8/2013 10213 Administration $23.40 Allred Tractor center 11/8/2013 10215 Equipment $4,938.75 Crawl Feed Supply 11/8/2013 10214 Feed $724.36 Phone South 12/10/2013 10232 Administration $67.25 Office Warehouse 12/10/2013 10233 Administration $14.57 Horace Olim 12/10/2013 10231 Payroll $899.00 Jose Gardon 12/10/2013 10236 Payroll $15.49

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.