Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi I need help with this project and I need it tomorrow. Can you help plz? Part.Page # 1 1 1 1 Write a formula
Hi I need help with this project and I need it tomorrow. Can you help plz?
Part.Page # 1 1 1 1 Write a formula that would indicate if the sum of the first column of numbers does not equal the sum of the second column by displaying either Equal or Not Equal and if not equal show Not equal by { and enter the amount of the difference } 1 2000 1 1000 2345.5 1 500 1 2500 1 2 2 On the sheet called Income Statement, in cell E14 create the formula for the Income Tax. 2 2 3 3 3 On the sheet called Income Statement, make cell C14 is the only cell that the enduser can type in. Protect the sheet without a password. 3 4 4 4 Freeze column A of the spreadsheet to make sure it does not 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 chart of accounts 1110 cash 1130 prepaid 1211 office equip 5 5 5 5 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 7 7 Invoice AM1254 AM1255 Amount 120.00 200.00 Current Late 100.00 20.00 200.00 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8 8 9 Write a formula that will finds the code for the color or return #N/A if the color is not on the list. Color Code Red Blue Yellow Orange Green Black White 101 102 103 104 105 106 107 Green 9 Write a formula that sums the assets 9 9 Amount 9 9 1110 Cash 1500 9 1130 Prepaid Insurance 1000 9 5100 Telephone 200 9 5120 Rent 1140 Accounts Receivable 400 600 9 9 9 9 10 10 Format the cell to 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 1110 1130 3100 2200 11 11 11 11 Cash Prepaid Ins Capital Stock Dividends Debit Debit Credit Debit Account 1110 3100 Balance -$100.25 $200.00 11 11 11 11 11 11 12 12 12 12 On the sheet called Invoice name the range A2:A27 , Dates and the range B2:B27, Amount. Write a formula using the named range to determine the last date and the largest amount. Last Date Largest Amount 12 12 13 13 Roundup to the next number of cans and use cans in the format. 13 13 2,123.60 2,124 cans 13 13 14 14 14 14 Write a formula that will indicate that ALL the values are " All Greater than 10" or that they are "Not all greater than 10". 12.00 14.00 45.00 14 14 14 15 15 15 15 15 15 15 15 Displays "Markdown" if the product is a Marker, or if the product is a Red Pen that costs more than $6. Displays "Regular" if not. Product Color Price Pen Red 2.00 Marker Black 6.00 Pen Red 7.00 Marker Black 4.00 15 Pen Red 5.00 15 Marker Black 3.00 15 15 16 16 Indicate the sum of the prices of the product selected 16 . Marker 16 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 17 17 RED 12.00 Byte of Accounting Income Statement For the Period Ending June 30, 2009 Revenue 4100 Computer Revenue $ 600.67 Expenses 5090 Interest Expense 5100 Insurance Expense Operating Income 5120 Tax Expense Net Income After Taxes $ 100.00 200.00 200.00 $ 400.67 40% $ 400.67 Dates Amount 12/5/2012 500.00 10/4/2012 400.00 12/9/2012 550.00 4/5/2012 600.00 9/8/2012 520.50 11/11/2012 420.50 9/10/2012 570.50 11/15/2012 620.50 3/12/2012 541.00 8/15/2012 441.00 10/18/2012 591.00 8/17/2012 641.00 10/22/2012 561.50 2/17/2012 461.50 7/22/2012 611.50 9/24/2012 661.50 7/24/2012 582.00 9/28/2012 482.00 1/24/2012 632.00 6/28/2012 682.00 8/31/2012 602.50 6/30/2012 502.50 9/4/2012 652.50 6/4/2012 702.50 8/7/2012 623.00 6/6/2012 523.00 On the sheet name Depreciation Schedule Create a Double declining Depreciation Schedule that restricts: Cost restricted to positive numbers Scrap restricted to positive numbers Less than the cost Life restricted to between 3 and 10 years And shows only years that are equal to or less than life Use Named RangesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started