Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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) |
Step by Step Solution
★★★★★
3.37 Rating (147 Votes )
There are 3 Steps involved in it
Step: 1
Solution 1 2 3 A B D E 1 Category ATM Withdrawal Total 3 Date Payee ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started