ACCT Assignment 4

profileMrJinx29
acct300_07-01.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCT Assignment 4

Pr. 7-1

Problem 7-1 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
23
Score: 71% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
*Since some answer boxes are correct when left blank, the beginning score is greater than 0%. 57
Key Code: Total SUM(AV13:AV15)
Instructions 80
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 71%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
" " represents an unanswered N box - counts as an incorrect.
1. Land Other " " represents a correct blank answer or N answer
Item Land Improvements Building Accounts Total number of answers = sum of above
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.
b.
c.
d. Steps:
e. Open this sheet and macro sheet
f. Open old templated, then change color palet to this sheet's
g. Insert new header - change problem number and reformat
h. Copy these formulas (column AD) to new sheet.
i. Update to new edition's names and numbers
j. Copy new error check formulas. For N-boxes
k. =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
l.
m. For B-Boxes
n. =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
o.
p. Copy Score formula from this template to new sheet.
q.
cpence: Enter a cash receipt as a negative value.
cpence: Enter a cash receipt as a negative value.		 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
r.
cpence: Enter a cash receipt as a negative value.
s.
2. Total
3.
Land does not lose its ability to provide services and is not depreciated. Land improvements do, so they are depreciated.
Land improvements do not lose their ability to provide services and are not depreciated. Land does, so it is depreciated.
Land does not lose its ability to provide services so it is depreciated. Land improvements do, and so are not depreciated.

sol.

Problem 7-1 * 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: ON " " 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. ERROR:#DIV/0!
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
" " represents an unanswered N box - counts as an incorrect.
1. Land Other " " represents a correct blank answer or N answer
Item Land Improvements Building Accounts Total number of answers = sum of above
a. ERROR:#REF! ERROR:#REF! $ 75,000 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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.
b. $ 18,000 ERROR:#REF!
c. 12,500 ERROR:#REF!
d. $ 14,500 Steps:
e. 400,000 ERROR:#REF! Open this sheet and macro sheet
f. $ 7,500 ERROR:#REF! Open old templated, then change color palet to this sheet's
g. 1,800 ERROR:#REF! Insert new header - change problem number and reformat
h. 12,000 ERROR:#REF! Copy these formulas (column AD) to new sheet.
i. 31,750 ERROR:#REF! Update to new edition's names and numbers
j. 1,500
cpence: Enter a cash receipt as a negative value.		 ERROR:#REF! Copy new error check formulas. For N-boxes
k. 4,000 ERROR:#REF! =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
l. 40,000 ERROR:#REF!
m. (775,000)
cpence: Enter a cash receipt as a negative value.		 ERROR:#REF! For B-Boxes
n. 800,000 ERROR:#REF! =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
o. (4,500) ERROR:#REF!
p. 6,000 ERROR:#REF! Copy Score formula from this template to new sheet.
q. (6,500)
cpence: Enter a cash receipt as a negative value.
cpence: Enter a cash receipt as a negative value.		 ERROR:#REF! =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
r. (1,000)
cpence: Enter a cash receipt as a negative value.		 ERROR:#REF!
s. 9,000 ERROR:#REF!
2. Total $ 470,250 $ 26,500 $ 920,000 ERROR:#REF!
3.
Land does not lose its ability to provide services and is not depreciated. Land improvements do, so they are depreciated. Land does not lose its ability to provide services and is not depreciated. Land improvements do, so they are depreciated.
Land improvements do not lose their ability to provide services and are not depreciated. Land does, so it is depreciated.
Land does not lose its ability to provide services so it is depreciated. Land improvements do, and so are not depreciated.