HOMEWORK Principles of Accounting I

Elcrazyrepa22

Ex.1-19-2.xls

Home >Mathematics homework help >HOMEWORK Principles of Accounting I

Ex. 1-19

Exercise 1-19

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

Name:

Section:

# N-box Incorrects due to blanks COUNTIF(B15:AT24," ")

Score:

# N-box +B-box corrects COUNTIF(B15:AT24," ")

Key Code:

[Key code here]

Total SUM(AD13:AD15)

Instructions

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.

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

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, " "

UNIVERSAL SERVICES

For the Month Ended October 31, 2012

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.

Income Statement

October 31, 2012

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.

Fees earned

Supplies expense

Expenses:

Miscellaneous expense

Wages expense

Rent expense

Net income

Net loss

Total expenses

Sol

Exercise 1-19
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.
An asterisk (*) will appear next to or below an incorrect entry only in the outlined cells.
	UNIVERSAL SERVICES					For the Month Ended October 31, 2012
	Income Statement					October 31, 2012
	For the Month Ended October 31, 2012
		Fees earned			$ 800,000	Supplies expense
		Expenses:				Miscellaneous expense
			Wages expense	$ 270,000		Wages expense
			Rent expense	60,000		Rent expense
			Supplies expense	9,000		Net income
			Miscellaneous expense	12,000		Net loss
			Total expenses		351,000
		Net income			$ 449,000

Enter the net amount of the increase (decrease) to owner's equity.