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, 23.06.2019 05:00
Jason works as an accountant in a department store. he needs to keep a daily record of all the invoices issued by the store. which file naming convention would him the most?
Answers: 2
question
Computers and Technology, 23.06.2019 09:00
Which best describes the role or restriction enzymes in the analysis of edna a. to break dna into fragments that vary in size so they can be sorted and analyzed b. to amplify small amounts of dna and generate large amounts of dna for analysis c. to purify samples of dna obtained from the environment so they can be analyzed d. to sort different sizes of dna fragments into a banding pattern that can be analyzed
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
How to do this programming flowchart?
Answers: 3
question
Computers and Technology, 24.06.2019 14:30
Two students are discussing electricity that has a frequency of 60 hz. student a says that this type of electricity is referred to as ac. student b says that in this type of electricity, the electrons flow in only one direction. which of the following statements is correct? a. only student a is correct b. only student b is correct c. both of the two students are correct d. neither of the two students is correct
Answers: 1
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, 29.06.2021 18:50
question
Mathematics, 29.06.2021 18:50
question
Social Studies, 29.06.2021 19:00
question
History, 29.06.2021 19:00
Questions on the website: 13722367