Answered step by step
Verified Expert Solution
Link Copied!

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.

DatePayeeCategoryMethod of PaymentAmount
6/1/2017Zachary KayeRentCheck$ (800.00)
6/2/2017George's SuperMartGroceriesCredit Card$ (114.62)
6/3/2017Sam's StopGasDebit Card$ (61.13)
6/4/2017VisaCredit Card PaymentCheck$ (300.00)
6/5/2017South & MainATM WithdrawalDebit Card$ (202.00)
6/6/2017IncomeSalaryCheck$ 2,034.78
6/7/2017[Savings Account]Transfer to SavingsTransfer$ (300.00)
6/8/2017George's SuperMartGroceriesCredit Card$ (136.52)
6/9/2017Gas-N-WashGasDebit Card$ (57.49)
6/10/2017SECElectric BillCheck$ (217.61)
6/11/2017Springfield Savings & LoansStudent LoanCheck$ (175.00)
6/12/2017George's SuperMartGroceriesDebit Card$ (173.06)
6/13/2017Gas-N-WashGasCredit 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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M.Dater, George Foster, Madhav

13th Edition

8120335643, 136126634, 978-0136126638

More Books

Students also viewed these Accounting questions