# Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
19
Score: 0% # N-box +B-box corrects COUNTIF(B7:AT41," ")
0
2. 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 f or lables and names, so that students can't enter a space in a box and have it counted as correct.
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 149,300$
Operating expenses:
Wages expense (a)
Rent expense 14,400
Supplies expense 12,000
Utilities expense 8,100
Miscellaneous expense 4,950
Total operating expenses (69,300)
Net income (b)
Common Stock Retained Earnings Total
Balances, Nov. 1, 20Y3 0$ 0$ 0$
Issuance of common stock 270,000 270,000
Net income (c)
Dividends (d)
Balances, Nov. 30, 20Y3 270,000$ (e) 314,000$
PARADISE REALTY
Statement of Stockholders' Equity
PARADISE REALTY
Income Statement
For the Month Ended November 30, 20Y3
For the Month Ended November 30, 20Y3
PARADISE REALTY
Balance Sheet
Problem 1-2
2.
Fees earned 149,300$
Operating expenses:
Wages expense (a) 29,850$
Rent expense 14,400
Supplies expense 12,000
Utilities expense 8,100
Miscellaneous expense 4,950
Total operating expenses (69,300)
Net income (b) 80,000$
Common Stock Retained Earnings Total
Balances, Nov. 1, 20Y3 0$ 0$ 0$
Issuance of common stock 270,000 270,000
Net income
(c) 80,000$ 80,000$
Dividends (d) (36,000) (36,000)
Balances, Nov. 30, 20Y3 270,000$ (e) 116,000$ 314,000$
PARADISE REALTY
Balance Sheet
Assets
November 30, 20Y3
PARADISE REALTY
Income Statement
For the Month Ended November 30, 20Y3
PARADISE REALTY
Statement of Stockholders' Equity
For the Month Ended November 30, 20Y3
Problem 1-2
Supplies 6,000