accounting homework unit 7

profileArmyBoy
unit_7_excel_homework.xls
Home>Business & Finance homework help>Accounting homework help>accounting homework unit 7

Ex. 6-2

Exercise 6-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
10
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Total SUM(AV13:AV15)
Instructions 10
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
May 21 " " represents an unanswered N box - counts as an incorrect.
May 22 " " represents a correct blank answer or N answer
Due Date Interest May 23 Total number of answers = sum of above
a. May 24 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. Feb. 19 Steps:
e. Feb. 20 Open this sheet and macro sheet
Feb. 21 Open old templated, then change color palet to this sheet's
Feb. 22 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
Aug. 27 Update to new edition's names and numbers
Aug. 28 Copy new error check formulas. For N-boxes
Aug. 29 =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
Aug. 30
For B-Boxes
Dec. 27 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Dec. 28
Dec. 29 Copy Score formula from this template to new sheet.
Dec. 30 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Nov. 28
Nov. 30
Dec. 1
Dec. 2
Enter a formula of principal x rate x time.

sol.

Exercise 6-2 * 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," ")
10
Total SUM(AV13:AV15)
Instructions 10
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 100%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
May 21 " " represents an unanswered N box - counts as an incorrect.
May 22 " " represents a correct blank answer or N answer
Due Date Interest May 23 Total number of answers = sum of above
a. Feb. 20 $ 450.00 May 24 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. May 22 150.00
c. Aug. 28 360.00
d. Dec. 28 600.00 Feb. 19 Steps:
e. Nov. 30 140.00 Feb. 20 Open this sheet and macro sheet
Feb. 21 Open old templated, then change color palet to this sheet's
Feb. 22 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
Aug. 27 Update to new edition's names and numbers
Aug. 28 Copy new error check formulas. For N-boxes
Aug. 29 =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
Aug. 30
For B-Boxes
Dec. 27 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Dec. 28
Dec. 29 Copy Score formula from this template to new sheet.
Dec. 30 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Nov. 28
Nov. 30
Dec. 1
Dec. 2
Enter a formula of principal x rate x time.

Ex. 6-7

Exercise 6-7
Estimated Uncollectible Accounts
Age Category Balance Percent Amount
Not past due (Current)
1-30 days past due
Total $ - 0 $ - 0

Ex. 6-18

Exercise 6-18 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
18
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Total SUM(AV13:AV15)
Instructions 18
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 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.
" " represents a correct blank answer or N answer
Unit Unit Total Total number of answers = sum of above
Inventory Cost Market 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.
Commodity Quantity Price Price Cost Market LCM
Buffalo 35 $115 $120 Steps:
Dakota 67 90 75 Open this sheet and macro sheet
Frontier 8 300 280 Open old templated, then change color palet to this sheet's
Midwest 83 40 30 Insert new header - change problem number and reformat
Rainbow 100 90 94 Copy these formulas (column AD) to new sheet.
Total Update to new edition's names and numbers
Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
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)
Enter the total cost of this commodity.
Enter the total market value of this commodity.
Enter the lower of the total cost or the total market value.