see attachments

profileArmyBoy
unit_3.xls
Home>Business & Finance homework help>Accounting homework help>see attachments

sol.

Exercise 2-17 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: 0 " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Total SUM(AV13:AV15)
Instructions 0
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
0 Notes:
* represents an incorrect N answer
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
BENJAMIN REALTY, INC. Utilities expense Total number of answers = sum of above
Income Statement Interest expense 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.
For the Month Ended April 30, 2013 Miscellaneous expense
Sales commissions
Revenues: Salaries expense Steps:
Sales commissions 0 $ 145,000 0 Rent expense Open this sheet and macro sheet
Expenses: Net income Open old templated, then change color palet to this sheet's
Salaries expense 0 $ 75,000 0 Net loss Insert new header - change problem number and reformat
Utilities expense 0 15,000 0 Copy these formulas (column AD) to new sheet.
Rent expense 0 5,000 0 Update to new edition's names and numbers
Interest expense 0 2,000 0 Copy new error check formulas. For N-boxes
Miscellaneous expense 0 3,000 0 =IF(sol.!$C$5="OFF","",IF(N77=""," ",IF(N77<>sol.!N77,"*"," ")))
Total expenses 100,000 0
Net income 0 $ 45,000 0 For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
List the expense accounts according to size, largest account balance to smallest, with one exception: place Miscellaneous Expense last in the list.

Ex. 2-21

Exercise 2-21
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.