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.

Write a program to analyze student’s scores. each student’s id and 4 original test scores are saved in the attached file “student_id_scores.txt”. assume there are exactly 15 students in the class.• the program first opens the file, reads student’s ids and scores from the file and saves them in two arrays: o create a one-dimensional string array “ids” to store the student’s ids.o create a (parallel) two-dimensional int array “scores” to store student’s original test scores. this array has 5 columns, the original 4 test scores should be saved in the first 4 columns, and the last column will be used to save the average score after the calculation in next step.• the program then retrieves test scores from the array “scores”, calculates average score and determines the final letter grade based on the rules in the table below for each student. assume average score is integer value.average score = (score1 + score2 + score3 + score4) / 4average score letter grade90 ~ 100 a80 ~ 89 b70 ~ 79 c60 ~ 70 d0 ~ 60 f• the average score should be saved back in the 5th column of “scores” array.• create a new parallel one-dimensional char array “grades” to save each student’s letter grade.• program also needs to find the number of a, number of b, number of c, number of d and number of f grade. as well as the highest, lowest and average score of the class.• finally, program will display all of the original scores and all results on the computer screen using the format shown as the sample output below.• the program must contain at least the following functions: (1) a function “getscores” to read and store data into “ids” and “scores” arrays.(2) a function “analyzescores” to calculate student’s average score, determine letter grade, get the number of a, b, c, d and f, find the highest, lowest and average score of the class.(3) a function “displayresults” to display all of the results