On the JuneTotals worksheet, sort the data in the range A3:E16 in ascending order by Category. At each change in Category, use the Sum function to add subtotals to the data in the Amount column. Accept all other defaults. Collapse the outline to show the grand total and Category subtotals only.

Date	Payee	Category	Method of Payment	Amount
6/1/2017	Zachary Kaye	Rent	Check	$ (800.00)
6/2/2017	George's SuperMart	Groceries	Credit Card	$ (114.62)
6/3/2017	Sam's Stop	Gas	Debit Card	$ (61.13)
6/4/2017	Visa	Credit Card Payment	Check	$ (300.00)
6/5/2017	South & Main	ATM Withdrawal	Debit Card	$ (202.00)
6/6/2017	Income	Salary	Check	$ 2,034.78
6/7/2017	[Savings Account]	Transfer to Savings	Transfer	$ (300.00)
6/8/2017	George's SuperMart	Groceries	Credit Card	$ (136.52)
6/9/2017	Gas-N-Wash	Gas	Debit Card	$ (57.49)
6/10/2017	SEC	Electric Bill	Check	$ (217.61)
6/11/2017	Springfield Savings & Loans	Student Loan	Check	$ (175.00)
6/12/2017	George's SuperMart	Groceries	Debit Card	$ (173.06)
6/13/2017	Gas-N-Wash	Gas	Credit Card	$ (65.33)

Answer rating: 100% (QA)

Solution 1 2 3 A B D E 1 Category ATM Withdrawal Total 3 Date Payee ... View the full answer