HOMEWORK Principles of Accounting I

Elcrazyrepa22

Ex2-9Template-3.xls

Home >Mathematics homework help >HOMEWORK Principles of Accounting I

Ex. 2-9

Exercise 2-9

# 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 to the right of incorrect entries in outlined answer cells.

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

For correct grading, enter a zero where you would otherwise leave an amount cell blank.

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 a space in a box and have it counted as correct.

(1)

Accounts Payable

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 Receivable

Cash

(2)

Fees Earned

Supplies

(3)

(4)

Cash

Accounts Payable

Supplies

Fees Earned

Accounts Receivable

Sol

Exercise 2-9
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.
For correct grading, enter a zero "0" in an amount answer cell you would otherwise leave blank.
An asterisk (*) will appear to the right or below of incorrect entries in outlined answer cells.
a.
	(1)		Accounts Receivable			0	35,700	0		0		Accounts Payable
			Fees Earned			0		0	35,700	0		Accounts Receivable
								0		0		Cash
	(2)		Supplies			0	2,000	0		0		Fees Earned
			Accounts Payable			0		0	2,000	0		Supplies
								0		0
	(3)		Cash			0	26,150	0		0
			Accounts Receivable			0		0	26,150	0
								0		0
	(4)		Accounts Payable			0	800	0		0
			Cash			0		0	800	0
b.
		Cash						Accounts Payable
	0	(3)	26,150	(4)	800			(4)	800	(2)	2,000
	0
		Supplies
	0	(2)	2,000					Fees Earned
	0									(1)	35,700
		Accounts Receivable
	0	(1)	35,700	(3)	26,150
	0