I need the comprehensive practice set completed and emailed to me in excel format from QuickBooks. the book used is quickbooks 2015 by janet horne isbn: 9780134130101. Pages to be completed are 670-693. The excel pages I need are the tabs shown in my excel submission file. ALSO, WORTH2.5 times the points, the 14 questions also attached. Every question worth ten points. excel is worth 60 pts. total project worth 200 points. (1/3 of my grade) I need at least 150 out of these 200 points to maintain a B in the class. Due Dec 1st at midnight(central time)

ale Comprehensive Final Ch 1-9 Description 1) Balance Sheet (Jan. 31) Total Assets $) 2) Profit and Loss (Net Income $) 3) Trial Balance Jan 31 (Debit Balance $) Total $ Points Available Points Earned 0 % 20 0% 20 0% 20 0% 60 0% ale ale ale Test 1) What is the Sales Receipt total for the work Katie did for the Cash Customer on January 2nd? (10pts) 2) What is the total of the Purchase Order created to Textbook Co. on January 2nd? (10pts) 3) What is the Invoice Total for Pamela Johnson on January 8th? (10pts) 4) How much is the Bill to Supplies Co. for stationery on January 14th? (10pts) 5) What is the Total Amount of the Invoice to Pamela Johnson on January 22nd? (10pts) 6) What is the Total Amount of the Sales Order to Total Training, Inc. on January 25th? (10pts) 7) What is the Net Pay to Tom Parker on January 31st? (10pts) 8) What is the Total Amount of Payroll Liabilities for January 2015? (10pts) 9) What is the Total Sales Tax paid on January 31st to the State Board of Equalization? (10pts) 10) What is the Checking Balance as of January 31st, 2015? (10pts) 11) What is the Accounts Payable balance for Capitol Books as of January 31st, 2015? (10pts) 12) What is the Balance of Capitol Book's Store Equipment & Fixtures Loan as of January 31st, 2015? (10pts) 13) What is Capitol Book's Net Income as of January 31st, 2015? (10pts) 14) What is the amount of the Total Assets on Capitol's Balance Sheet dated January 31, 2015? (10pts)