ZuoTi.Pro
Question

I need help on Excel

create a named range called, "expenses" that references the cell that calculates the total income in your budget.

excel   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

HERE I AM ATTACHING THE REQUIRED PICTURES FROM EXCEL BUDGET SUMMARY FOR A MONTH.

HOPE THIS IS HELPFUL TO YOU.

Home Insert Page Layout Formulas Data Review View fo Σ Insert Function AutoSum Recently Financial Logical Text Date & LookupHome Insert Page Layout Formulas Data Review View fix A B Den Insert Function fP Use AutoSum Recently Financial Logical Text

Home Book Microsoft Ece Insert Page Layout Formulas Data Review View fix Σ a Define Name - Insert Function AutoSum Recently F WITH FORMULAS -Home Insert Page Layout Formulas Data Review View Georgia v 11 A A Paste * Cut En Copy Format Painter Clipboard Wrap Text GenHome Insert Page Layout Formulas Data Review View fo Σ Insert Function AutoSum Recently Financial Logical Text Date & LookupA B 13 14 15 16 17 18 1550 67 42 18 35 19 20 20 10 21 RENDITURE ITEMS 1. GROCERY 2. ELECTRICITY 3. GAS AND OIL 4. INTERNET 5.Page Layout Formulas Data Review View Trace Precedents Show Formulas Financial Logical Text Date & Lookup & Math More Time ReLyd Function MOE Used Time - Reference - & Trig Functions Function Library Name Manager Create from Selection Wat Remove Arro


answered by: ANURANJAN SARSAM
0 0
Add a comment
Know the answer?
Add Answer to:
I need help on Excel
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The question asks to create a named range “income” that references the cell that calculates the total income in the b...

    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...

  • please help me create this excel sheet. thank you. this is all that the teacher provided...

    please help me create this excel sheet. thank you. this is all that the teacher provided she would like us to answer in excel. Sheet 1: Name sheet Budget 2020. Create a 2020 Budget for yourself. It should include the following: Income, Total Income, Expenses (can include mortgage, electricity, cable or dish, college (tuition, books), insurance, car payment, food, entertainment, etc), Total Expenses, Net Income (Income minus Expenses). Formulas must be designed that calculate accurately. Formulas to include Sum, Min,...

  • i need help with this question Preparing an Income Statement using Excel's SUM, Basic Math Functions...

    i need help with this question Preparing an Income Statement using Excel's SUM, Basic Math Functions and Cell Referencing Great Taste Restaurants, Inc. has provided a list of select accounts as of March 31, 2016. The Controller has asked you to prepare the company's Income statement at the month ended March 31, 2016. Use the information included in the Excel Simulation and the Excel functions described below to complete the task . Cell Reference Allows you to refer to data...

  • I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and...

    I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and sells high quality certified sustainable coffee beans. The final one pound bags of roasted whole coffee beans has two direct materials – coffee beans and packaging. GBCoffee is preparing budgets for the fourth quarter ending December 31, 2019. For each requirement below prepare budgets by month for October, November, and December, and a total budget for the quarter. 1. The previous year’s sales for...

  • Need help on making these formulas !!! 4. In cell-B8, create a formula without using a...

    Need help on making these formulas !!! 4. In cell-B8, create a formula without using a function that multiplies the value.in.cell.B7. by the value-in-cell-B6-andthen adds-the-value in B7..Update.the-cell-reference to cell: B6, from a relative reference to a mixed-reference by making an absolute-reference to row.6..Copy-the-formula-from-cell-B8-to-the-range-B9:B11-and-then-copy-the-formulas. from the range-B8:B11-to-the-range-C8:H11.1 13. SALO extend the list of years to the range A15:A17.1 In-cell-B13, create-a formula without a function using absolute references that subtracts the values of cells.B5 and B7.from.cell-B6 and then multiplies the result.by.cell-B8. Copy...

  • Create a sub in excel vba called "RandomColors" that assigns colors in a random way to...

    Create a sub in excel vba called "RandomColors" that assigns colors in a random way to each cell of the range d4:h8. (hint:set the colorindex property of each cell in the range to a random integer between 1 and 10)

  • I need help with JUST 5,6, and 7 please 3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000...

    I need help with JUST 5,6, and 7 please 3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a sales budget. 2018 4 Budget #1: Sales Budget Jan Feb Mar 01 Total April May 5 Budgeted units to be...

  • Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as...

    Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as Excel_Ch11HW_LastNameFirstName. b. Click cell H4, the cell containing the ending date for the first loan. Enter the formula to compute the ending date, based on the starting date and the term of the loan. For the sake of simplicity, you don’t have to account for leap year. To compute the ending date, multiply the term of the loan by 365 and add that result...

  • please so how you got the answers thanks for you help ELS - Hurdy Headphones Wireless...

    please so how you got the answers thanks for you help ELS - Hurdy Headphones Wireless Models Wire Units Mes plenes Pront Analys Totales Total Gris Profit 4 5 0 Units Sold Price Per Unit Total Sales 25,000 120.00 ,475.000.00 5 4 15,000 5 2.425,000 $2,520,000 20,000 53.530,000 3,250,000 25,000 5 4.475,000 $4,010,0005 30,000 $9,270,000 $4.700.000 $ 15.000 56,205,000 5 5510,000 5 175,000 30,000 455,000 10.000 155,000 8 Expenses 9 Varia Expand 10 Un Manufactured 11 Variable Cost per un...

  • I need help with this. Can someone please show me the solution. Declaring and Initializing Java...

    I need help with this. Can someone please show me the solution. Declaring and Initializing Java Variables Summary In this lab, you declare and initialize variables in a Java program. The program file named NewAge.java, calculates your age in the year 2050. Instructions Declare an integer variable named newAge. Declare and initialize an integer variable named currentAge. Initialize this variable with your current age. Declare and initialize an integer variable named currentYear. Initialize this variable with the value of the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT