Pr. 8-3A
Problem 8-3A # 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 right 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. AMERICAN MEDICAL CO. 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.
April 30 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
Add:
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values.
Mark Sears: Enter the total of additions. Bank error in charging check as $420 instead of $240
Bank service charges
Deduct:
Mark Sears: Enter all amounts as positive values, whether being added or subtracted. Deposit of April 30, not recorded by bank
Adjusted balance Error in recording check
Note and interest collected by bank
Cash balance according to company's records Outstanding checks
Add:
Deduct:
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values.
Adjusted balance
2.
April 30
cpence: Record increases to cash in this entry. Accounts Payable - Targhee Supply Co.
cpence: Enter the larger of the credits on this line. Cash
Interest Revenue
Miscellaneous Expense
30
Mark Sears: Enter the largest of the two debits first. Notes Receivable
3.
Amount to be reported on April 30 balance sheet
Sol
Problem 8-3A
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 right of an incorrect entry.
1. AMERICAN MEDICAL CO.
Bank Reconciliation
April 30
Cash balance according to bank statement $ 388,600
Add: Deposit of April 30, not recorded by bank $ 42,500
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values.
Bank error in charging check as $420 instead of $240 180 42,680
Mark Sears: Enter the total of additions. Error in recording check
Bank error in charging check as $420 instead of $240
Deduct: Outstanding checks 61,280
Mark Sears: Enter all amounts as positive values, whether being added or subtracted. Bank service charges
Adjusted balance $ 370,000 Outstanding checks
Deposit of April 30, not recorded by bank
Cash balance according to company's records $ 334,985 Note and interest collected by bank
Add: Note and interest collected by bank 42,000
Deduct: Error in recording check $ 6,840
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values.
Bank service charges 145 6,985
Adjusted balance $ 370,000
2.
April 30 Cash
cpence: Record increases to cash in this entry. 42,000 Accounts Payable - Targhee Supply Co.
Notes Receivable
cpence: Enter the larger of the credits on this line. 40,000 Cash
Interest Revenue 2,000 Interest Revenue
Miscellaneous Expense
30 Accounts Payable - Targhee Supply Co.
Mark Sears: Enter the largest of the two debits first. 6,840 Notes Receivable
Miscellaneous Expense 145
Cash 6,985
3.
Amount to be reported on April 30 balance sheet