subject

In Assignment 1, you created a weekly budget for your family and in Assignment 2, you added various formats to the spreadsheet. In this assignment, you will add some analysis to your budget. Open the last assignment, and save it as Weekly_Budget_3_Your_Name. Instructions 1. For each family member in your budget, calculate the total amount spent. In Cell A14, place the title “Total Spent.” • In cells B14 through E14, place the correct formula that will calculate how much money each family member spent. (Hint: You will have a separate number for each family member.) 2. For each family member in your budget, calculate the number of expenses each family member had (you will use the =COUNT function for this). In Cell A15, place the title “Number of Expenses.”  In cells B15 through E15 place the correct formula that will calculate how many items each family member spent money on. 3. For each expense item, calculate the total amount spent on that item. In Cell F3, place the title “Item Total.”  In cells F4 through F13, place the correct formula that will calculate how much money was spent on each expense item. 4. For each expense item, calculate the number of family members that have this expense (you will use the =COUNT function for this). In Cell G3, place the title “# of Times Used.”  In cells G4 through G13, place the correct formula that will calculate how many times each expense was used. 5. Calculate the total Expense. In Cell D16, place the title “Total Spent.”  In Cell E16, place the correct formula that will calculate the total spent for the entire family. 6. Make sure the layout of your spreadsheet is neat and clear, by adjusting the borders to include the new information.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 01:30
What kind of motivation is katrina showing? use the drop-down menu to complete the statement. katrina is using motivation because she is personally interested in learning more.
Answers: 2
question
Computers and Technology, 22.06.2019 23:30
What does 21 pilots middle aged name as a band 15 years prior to them naming their band 21 pilots?
Answers: 1
question
Computers and Technology, 23.06.2019 05:30
Sally is editing her science report about living things. she needs to copy a paragraph from her original report. order the steps sally needs to do to copy the text to her new document.
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
Anul 2017 tocmai s-a încheiat, suntem trişti deoarece era număr prim, însă avem şi o veste bună, anul 2018 este produs de două numere prime, 2 şi 1009. dorel, un adevărat colecţionar de numere prime, şi-a pus întrebarea: “câte numere dintr-un interval [a,b] se pot scrie ca produs de două numere prime? “.
Answers: 3
You know the right answer?
In Assignment 1, you created a weekly budget for your family and in Assignment 2, you added various...
Questions
question
Mathematics, 10.12.2020 03:50
question
Mathematics, 10.12.2020 04:00
question
Mathematics, 10.12.2020 04:00
question
English, 10.12.2020 04:00
question
English, 10.12.2020 04:00
Questions on the website: 13722367