I need help with an accounting assignment.

1 formula that would indicate if the sum of the first column 1 of numbers does not equal the sum of the second column by displaying 1 either Equal or Not Equal and if not equal show 1 Not equal by { and enter the amount of the difference } 1 2000 2345.5 1 1000 1 500 1 2500 1 2 On the sheet called Income Statement, in cell E14 create the formula 2 for the Income Tax. 2 2 3 3 On the sheet called Income Statement, makecell C14 is the only cell 3 that the enduser can type in.Protect the sheet without a password. 3 4 4 Freeze column A of the spreadsheet to make sure it does not 4 scroll off the left side of the screen. 4 5 5 The only valid entry is an account number from the chart of accounts 5 5 chart of accounts 5 1110 cash 5 1130 prepaid 5 1211 office equip 6 6 Custom format cell to display "The report is due on Tuesday, February 28, 2012" 6 6 2/28/2012 6 6 7

7 Display an error if there is a value in the Current and Late cells for the same invoice. 7 7 7 Invoice Amount Current Late 7 AM1254 120.00 100.00 20.00 7 AM1255 200.00 200.00 7 7 7 7 8 8 formula that will finds the code for the color 8 or return #N/A if the color is not on the list. 8 Color Code 8 Red 101 8 Blue 102 8 Yellow 103 8 Orange 104 8 Green 105 8 Black 106 8 White 107 8 Green 8 9 9 formula that sums theassets 9 9 9 Amount 9 1110 Cash 1500 9 1130 Prepaid Insurance 1000 9 5100 Telephone 200 9 5120 Rent 400 9 1140 Accounts Receivable 600 9 9 9 10 10 Format the cellto show the amount owed after the words "You owe $100.00." 10 10 Amount 10 100 10 10 10 11 11 Indicate if the balance is different than the normal balance. 11 11 11 1110 Cash Debit 11 1130 Prepaid Ins Debit 11 3100 Capital Stock Credit 11 2200 Dividends Debit 11 11 Account Balance 11 1110 -$100.25 11 3100 $200.00 11 11 12 12 On the sheet called Invoice name the range A2:A27 , Dates and the range B2:B27, Amount. 12 formula using the named range to determine the last date and the largest amount. 12 Last Date 12 Largest Amount 12 13 13 Roundup to the next number of cans and use cans in the format. 13 13 13 2,123.60 2,124 cans 13 14 14 formula that will indicate that ALL the values 14 are " All Greater than 10" or that they are "Not all greater than 10". 14 12.00 14.00 45.00 14 14 14 15 15 Displays "Markdown"if the product is a Marker, or if the product 15 is a Red Pen that costs more than $6.Displays "Regular" if not. 15 Product Color Price 15 Pen Red 2.00 Regular 15 Marker Black 6.00 Markdown 15 Pen Red 7.00 Markdown 15 Marker Black 4.00 Markdown 15 Pen Red 5.00 Regular 15 Marker Black 3.00 Markdown 15 15 16 16 Indicate the sum of the prices of the product selected 16 . 16 Marker 13.00 16 17 17 Follow the rules in the following table and write "Discount" or "No Discount" 17 17 RED and >10 Discount 17 GREEN and >15 Discount 17 Blue and > 20 Discount 17 17 RED 12.00 Discount 17 17 18 18 Item Description A/R 18 1000 John's Cavern $10,000.00 18 2000 IHOP $330.00 18 3000 Grace Land $40,000.00 18 4000 Fisher Island $100,000.00 18 18 Item Description A/R 18 2000 IHOP $330 18 19 19 Display the latest date in the format: 19 " The last date entered was January 02, 2009." 19 19 Dates 19 1/2/2009 19 2/4/2009 19 10/21/2017 19 4/1/2009 The last date entered was January 02, 2009. 19 12/29/2009 19 11/25/2009 19 Oct-21-2009 19 19 19 19 19 20 Married Filing Jointly 20 Taxable income over Rate on excess Tax on amount in "E" 20 $- 10% $- 20 16,700.00 15% 1,670.00 21 67,900.00 25% 9,350.00 21 137,050.00 28% 26,637.50 21 208,850.00 33% 46,741.50 21 372,950.00 35% 100,894.50 21 21 Using the table above determine the tax due if the taxable income 21 Income was.. $68,000.00 $9,375.00 21 22 22 22 22 On the sheet name Depreciation Schedule 23 23 23 Double Declining Depreciation Schedule that restricts: 24 Cost to positive numbers 24 Scrap to positive numbers less than the cost 24 Life to between 3 and 10 years 25 And shows only years that are equal to or less than life 25 Use Named Ranges