Question: The question asks to create a named range income that references the cell that calculates the total income in the budget sheet pictured above. Im
The question asks to create a named range income that references the cell that calculates the total income in the budget sheet pictured above. Im just having trouble understanding since there is no total income cell. Home Insen Draw Page Layout Formulas Data Review View Help Asignment Tell me what you want to do 2 Logical AutoSum Lookup & Reference- CB Define Name Trace Precedents 9Show Formulas Recently Used A Text Math & Trig- Trace Dependents Error Checking Use in Formula rt Name Watch Calculation Date & Time More Functions on Financial- Remove Arrows Create from Selection Evaluate Formula Manager Options Window Function Library Defined Names Formula Auditing Calculation www. Assignment Tasks X A Budget Jun Create a named range called, "Income" that references the cell that calculates the total 1 Line of Credit Needed nee income in your budget. [3 points] Than December April February January March ay June Beginning Cash Balance $5,000.00 Cash Inflows (Income): Customer Payments $35,000.00 $45,000.00 $53,000.00 $64,680.00 $76,540.00 $90,540.00 $52,000.00 $62,000.00 $73,500.00 $ 86,000.00 $100,600.00 $117,700.00 Cash Sales Total Cash Inflows Cash Outflows (Expenses): Advertising Loan Interest $20,000.00 $30,000.00 $35,000.00 $40,000.00 $50,000.00 $60,000.00 Insurance Inventory Purchases Office Supplies Payroll $4,500.00 $46,000.00 $53,000.00 $54,500.00 $59,800.00 $71,900.00 $83,300.00 $3,200.00 $11,000.00 $12,000.00 $13,500.00 $18,100.000 $17,700.00 $23,200.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $2,700.00 $4,500.00 $4,500.00 $4,500.00 $4,500.00 $4,500.00 $3,200.00 $3,200.00 $3,500.00 $4,000.00 $4,000.00 Rent or Lease $3,200.00 $3,000.00 $3,100.00 Utilities & Telephone Total Expenses $3,500.00 $5,000.00 CashFlow Budget Cellular Calls Data Messages ITT 11:24 Type here to search 6/7/2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
