Excel sheet $2,$ please include formulas for excel.

Excel File Edit AutoSave Home Insert Draw Jan. 17 View Insert Format Formulas Tools Data Data Window Page Layout Help ExcelAssignment2_Question2 (1) v Automate Q Tell me Text Mon Apr 15 5:01 PM Review View C) Comments Liberation Sans v 12 Paste 0/0 Conditional Formatting Format as Table Cell Styles 4)) Insert v Format v Sort & Filter Find & Select Sensitivity Add-ins C Share v Analyze Data Function: SUM; Formula: Subtract; Cell Referencing 3 4 10 11 12 13 14 15 16 17 18 19 20 21 22 25 26 27 28 29 30 31 33 34 36 37 38 39 41 42 43 ; Formula: Subtract; Cell Referencing Function: S Using Excel to Identify Accounts Receivable Subsidiary Ledger Balances PROBLEM The following is information related to Gantner Company for its first month of operations. Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts receivable balance that appears in the general ledger at the end of January. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. Use the SUM function with cell references to Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts receivable balance that appears in the general ledger at the end of January. Jan. 7 15 23 24 29 Credit Sales Austin co. $ 10,000 Diaz Co. Noble Co. Cash Collections Austin Co. $ Diaz Co. Noble Co. 8,000 9,000 7,000 4,000 9,000 General Led er Accounts Receivable Date Ref. Debit Credit Accounts Receivable Subsidia Led Date Ref. Date Ref. Date Ref. Austin Co. Debit Credit Diaz Co. Debit Credit Noble Co. Debit Credit Balance er Balance Balance Balance Enter Answer Ready Accessibility: Investigate ooo