HOMEWORK Principles of Accounting I

Elcrazyrepa22

PR2-2ATemplate.xls

Home >Mathematics homework help >HOMEWORK Principles of Accounting I

Pr. 2-2A

Problem 2-2A

# Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")

Name:

Section:

# N-box Incorrects due to blanks COUNTIF(B7:AT41," ")

Score:

# N-box +B-box corrects COUNTIF(B7:AT41," ")

Key Code:

[Key code here]

Total SUM(AV13:AV15)

Instructions

Answers are entered in the cells with gray backgrounds.

Percentage =(AV16-AV13-AV14)/AV16

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.

Notes:

An asterisk (*) will appear next to or below an incorrect entry only in the outlined cells. Only

If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "

ending balances of T accounts will be graded.

If number-entry or blank-entry box is incorrect, returns "*"

In the trial balance, enter a zero in answer cells you would otherwise leave blank.

If number-entry or blank-entry box is correct, returns single space, " "

Account

Debit

Credit

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.

(a)

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.

Accounts Payable

Automobile Expense

(b)

Cash

Faith Schultz, Capital

Faith Schultz, Drawing

(c)

Miscellaneous Expense

Office Salaries Expense

Rent Expense

(d)

Sales Commissions

Supplies

Supplies Expense

(e)

(f)

(g)

(h)

(i)

Cash

Sales Commissions

Rent Expense

Bal.

Supplies

Office Salaries Expense

Bal.

Accounts Payable

Automobile Expense

Bal.

Faith Schultz, Capital

Supplies Expense

Faith Schultz, Drawing

Miscellaneous Expense

HEAVENLY REALTY

Unadjusted Trial Balance

October 31, 2012

Debit

Credit

Cash

Supplies

Accounts Payable

Faith Schultz, Capital

Faith Schultz, Drawing

Sales Commissions

Rent Expense

Office Salaries Expense

Automobile Expense

Supplies Expense

Miscellaneous Expense

Enter transaction letter here.

Enter account balance.

Total debits must equal total credits.

Sol

Problem 2-2A
Name:			Solution
Section:
Score:			ON
Key Code:
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 only in the outlined cells. Only ending balances
of T accounts will be graded. In the trial balance, enter a zero in answer cells you would otherwise leave blank.
1.		Account								Debit			Credit
	(a)	Cash								20,000	0			0
		Faith Schultz, Capital									0		20,000	0	Accounts Payable
								0			0			0	Automobile Expense
	(b)	Rent Expense						0		3,750	0			0	Cash
		Cash						0			0		3,750	0	Faith Schultz, Capital
								0			0			0	Faith Schultz, Drawing
	(c)	Supplies						0		1,100	0			0	Miscellaneous Expense
		Accounts Payable						0			0		1,100	0	Office Salaries Expense
								0			0			0	Rent Expense
	(d)	Accounts Payable						0		400	0			0	Sales Commissions
		Cash						0			0		400	0	Supplies
								0			0			0	Supplies Expense
	(e)	Cash						0		16,750	0			0
		Sales Commissions						0			0		16,750	0
	(f)	Automobile Expense						0		1,000	0			0
		Miscellaneous Expense						0		700	0			0
		Cash						0			0		1,700	0
								0			0			0
	(g)	Office Salaries Expense						0		2,150	0			0
		Cash						0			0		2,150	0
								0			0			0
	(h)	Supplies Expense						0		600	0			0
		Supplies						0			0		600	0
								0			0			0
	(i)	Faith Schultz, Drawing						0		1,000	0			0
		Cash						0			0		1,000	0
2.
			Cash						Sales Commissions
			(a)		20,000	(b)	3,750				(e)		16,750
			(e)		16,750	(d)	400			-
						(f)	1,700
						(g)	2,150		Rent Expense
						(i)	1,000		(b)	3,750
			Bal.		27,750								0
			Supplies						Office Salaries Expense
			( c)		1,100	( c)	600		(g)	2,150
			Bal.		500								0
			Accounts Payable						Automobile Expense
			(d)		400	( c)	1,100		(f)	1,000
						Bal.	700						0
			Faith Shultz, Capital						Supplies Expense
						(a)	20,000		(h)	600
					-								0
			Faith Shultz, Drawing						Miscellaneous Expense
			(f)		1,000				(f)	700
							0						0
3.	HEAVENLY REALTY
	Unadjusted Trial Balance
	October 31, 2012
		Cash								27,750	0	0	-	0
		Supplies								500	0	0	-	0
		Accounts Payable								-	0	0	700	0
		Faith Schultz, Capital								-	0	0	20,000	0
		Faith Schultz, Drawing								1,000	0	0	-	0
		Sales Commissions								-	0	0	16,750	0
		Rent Expense								3,750	0	0	-	0
		Office Salaries Expense								2,150	0	0	-	0
		Automobile Expense								1,000	0	0	-	0
		Supplies Expense								600	0	0	-	0
		Miscellaneous Expense								700	0		-	0
										37,450	0		37,450	0
4.
		a.		$ 16,750		0
		b.		$ 8,200		0
		c.		$ 8,550		0
5.
				$ 7,550

Enter transaction letter here.

Enter account balance.

Total debits must equal total credits.