ACCOUNTING SPREADSHEET EXCEL CHART

danivic78
Chapter7-4B.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCOUNTING SPREADSHEET EXCEL CHART

Pr. 7-3B

Problem 7-3B # Incorrect N-box and B-box entries COUNTIF(B15:G24,"~*")
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
31
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
Key Code: [Key code here] Total SUM(AD13:AD15)
Instructions 31
Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16
Cells with non-gray backgrounds are protected and cannot be edited. 0%
An asterisk (*) will appear to the left of an incorrect entry. Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or blank-entry box is incorrect, returns "*"
1. STONE SYSTEMS If number-entry or blank-entry box is correct, returns single space, " "
Bank Reconciliation Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.
July 31, 20Y5 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Cash balance according to bank statement
Adjustments:
Bank error in charging check as $1,180 instead of $1,810
Bank service charges
Total adjustments Deposit of July 31, not recorded by bank
Adjusted balance Error in recording check
Outstanding checks
Cash balance according to company's records Proceeds of note collected by bank, including $345 interest
Adjustments:

cpence: Enter positive adjustments first, larger before smaller. Enter a deduction from cash balance as a negative amount.
Total adjustments
Adjusted balance
2.
July 31
cpence: Record increases to cash in this entry.		 Accounts Payable - Holland Co.

cpence: Enter credits in descending order, largest to smallest.
cpence: Enter positive adjustment first. Enter deductions from cash balance as negative amounts, larger adjustment first.		 Cash
Interest Revenue
Miscellaneous Expense
Notes Receivable
31
3.
Amount to be reported on July 31, 20Y5, balance sheet

Sol

Problem 7-3B
Name: Solution
Section:
Scoring: ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the left of an incorrect entry.
1. STONE SYSTEMS
Bank Reconciliation
July 31, 20Y5
Cash balance according to bank statement $ 33,650
Adjustments:
Deposit of July 31, not recorded by bank $ 9,150
cpence: Enter positive adjustment first, larger before smaller. Enter a deduction from cash balance as a negative amount.
Outstanding checks (17,865) Bank error in charging check as $1,180 instead of $1,810
Bank error in charging check as $1,180 instead of $1,810 (630) Bank service charges
Total adjustments (9,345) Deposit of July 31, not recorded by bank
Adjusted balance $ 24,305 Error in recording check
Outstanding checks
Cash balance according to company's records $ 17,750 Proceeds of note collected by bank, including $345 interest
Adjustments:
Proceeds of note collected by bank, including $345 interest $ 6,095
cpence: Enter positive adjustments first, larger before smaller. Enter a deduction from cash balance as a negative amount.
Error in recording check 540
Bank service charges (80)
Total adjustments 6,555
Adjusted balance $ 24,305
2.
July 31 Cash
cpence: Record increases to cash in this entry.		 6,635 Accounts Payable - Holland Co.
Notes Receivable
cpence: Enter credits in descending order, largest to smallest.
cpence: Enter positive adjustment first, larger before smaller. Enter a deduction from cash balance as a negative amount.		 5,750 Cash
Accounts Payable - Holland Co. 540 Interest Revenue
Interest Revenue 345 Miscellaneous Expense
Notes Receivable
31 Miscellaneous Expense 80
Cash 80
3.
Amount to be reported on July 31, 20Y5, balance sheet $ 24,305