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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 06:00, kiaunarayne808
The width of a piece of rectangular land is 5m shorter rhan 1/3 of its length .find the width of the land if the length is 60m,150m.
Answers: 1
image
Computers and Technology, 23.06.2019 16:00, keyonaemanieevans
Helen is having a meeting with her colleagues in her company. they are working on the goals and objectives for the coming year. they want to ensure that these goals and objectives of the processes involved are properly evaluated. which system can helen and her colleagues apply to evaluate this? helen and her colleagues require a blank to evaluate the goals and objectives.
Answers: 2
image
Computers and Technology, 23.06.2019 23:00, minosmora01
How do you know if the website is secure if you make a purchase
Answers: 2
image
Computers and Technology, 24.06.2019 01:00, Timeisjesus
Answer these and get 40 points and brainliest
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 in other subjects:

Konu
Health, 23.06.2019 00:30