Select Page

book: ACCOUNTING (26th Edition); Publisher: Cengage Warren, Reeve and Duchac.ISBN: 978-1-285-74361-5
wrd_26e_ex_02_15.xlsx

wrd_26e_pr_02_3a.xlsx

wrd_26e_ex_02_07.xlsx

Unformatted Attachment Preview

Exercise 2-15
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. For correct grading,
enter a zero where you would otherwise leave an amount cell blank.
a.
WYOMING TOURS CO.
Unadjusted Trial Balance
Cash
Accounts Receivable
Supplies
Equipment
Accounts Payable
Lorene Jones, Capital
Lorene Jones, Drawing
Service Revenue
Operating Expenses
b.
Service revenue
Operating expenses
Net income (loss)
Problem 2-3A
Name:
Section:
Score:
0%
Key Code: 2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.
In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be
graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank.
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells.
1.
Page 1
JOURNAL
Date
2016
Nov.
Description
Post
Ref.
Debit
Page 2
JOURNAL
Date
2016
Nov.
Description
Credit
Post
Ref.
Debit
Credit
2.
GENERAL LEDGER
Cash
Date
2016
Nov.
11
Item
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Accounts Receivable
Date
2016
Nov.
12
Item
Post
Ref.
Item
Post
Ref.
Item
Post
Ref.
Item
Post
Ref.
Item
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Supplies
Date
2016
Nov.
13
Balance
Dr.
Cr.
Dr.
Cr.
Prepaid Insurance
Date
2016
Nov.
14
Balance
Dr.
Cr.
Dr.
Cr.
Equipment
Date
2016
Nov.
16
Balance
Dr.
Cr.
Dr.

Cr.
Truck
Date
2016
Nov.
18
Balance
Dr.
Cr.
Dr.
Cr.
Notes Payable
Date
2016
Nov.
21
Item
Post
Ref.
Item
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Accounts Payable
Date
2016
Nov.
22
Balance
Dr.
Cr.
Dr.
Cr.
Patty Cosgrove, Capital
Date
2016
Nov.
Item
31
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Patty Cosgrove, Drawing
Date
2016
Nov.
32
Item
Post
Ref.
Item
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Fees Earned
Date
2016
Nov.
41
Balance
Dr.
Cr.
Dr.
Cr.
Wages Expense
Date
2016
Nov.
51
Item
Post
Ref.
Item
Post
Ref.
Item
Post
Ref.
Item
Post
Ref.
Balance
Dr.
Cr.
Dr.
Cr.
Rent Expense
Date
2016
Nov.
53
Balance
Dr.
Cr.
Dr.
Cr.
Utilities Expense
Date
2016
Nov.
54
Balance
Dr.
Cr.
Dr.
Cr.
Truck Expense
Date
2016
Nov.
55
Balance
Dr.
Cr.
Dr.
Cr.
Miscellaneous Expense
Date
2016
Nov.
Item
3.
Balance
Dr.
Cr.
Debit
Balances
Credit
Balances
CLASSIC DESIGNS
Unadjusted Trial Balance
November 30, 2016
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Equipment
Truck
Notes Payable
Accounts Payable
Patty Cosgrove, Capital
Patty Cosgrove, Drawing
Fees Earned
Wages Expense
Rent Expense
Utilities Expense
Truck Expense
Miscellaneous Expense
4.
59
Post
Ref.
Dr.
Cr.
# Incorrect N-box and B-box entries COUNTIF(B7:AT41,”~*”)
0
# N-box Incorrects due to blanks COUNTIF(B7:AT41,” “)
144
# N-box +B-box corrects COUNTIF(B7:AT41,” “)
0
Total SUM(AV13:AV15)
144
Percentage =(AV16-AV13-AV14)/AV16
0%
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 “*”
If number-entry or blank-entry box is correct, returns single space, ” ”
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
Conditional formatting might be used but wasn’t here, to hide some of the error check return symbols. If A1 = “~*”, then font = red, if
and names, so that students can’t enter a space in a box and have it counted as correct.
symbols. If A1 = “~*”, then font = red, if something else, then font = background color.
Exercise 2-7
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.
An asterisk (*) will appear next to or below an incorrect entry.
JOURNAL
2016
Account
Mar. 1
3
5
6
10
15
27
30
31
31
31
Debit
Credit

Purchase answer to see full
attachment