How record accounting transactions

profilecc2014
ac113_unit_7__assignment.xlsx
Home>Business & Finance homework help>Accounting homework help>How record accounting transactions

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.
Peggy Hussey: Enter a formula of principal x rate x time.		 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

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
Peggy Hussey: Enter a formula of principal x rate x time.		 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

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
Peggy Hussey: Enter the total cost of this commodity.
Peggy Hussey: Enter the total market value of this commodity.
Craig Pence: Enter the lower of the total cost or the total market value.		 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)