Below is a record of the Brown's Family Expenses for Quarter 3 2022 You are required to complete the following using the suggested Excel Formulas: Requirement Excel Formula 1 Calculate the to total Household Expenses for each month and for the quarter ending September . AutoSum ,SUM 2 Calculate the average monthly Household Expense for the quarter. Average 3 How many items in September Expenses exceeded $300? COUNTIF 4 Assuming the Green family has a monthly budget of $4000, determine if they are overbudget or underbudget for the months of July, August, September IF 5 The Green family has five children with the following names. Attach the family name "Green" to each name using the concatenate function. CONCATENATE Joel Esther Jheena Kenny Sean Note: Input your formula and answers in the designated yellow cells. For Requirement 5, input formula and answers in cells H9 through H14. Do not change any amount in Column D. Make sure to use the excel formulas when calculating. Manually calculated/determined answers will not receive any mark. Brown Family Household Expenses for Quarter 3, 2022 Items $ Overbudget/Underbudget? July Electricity & Water Bill 250 Phone Bill 150 Internet 90 Gas 60 Apartment rental 1,450 Donation 150 Car maintenance 100 Car Repairs 800 Car Insurance 350 Medical insurance 230 Groceries 1000 Miscellaneaous 125 TOTAL Requirement 1 Requirement 4 August Electricity & Water Bill 230 Phone Bill 150 Internet 90 Gas 65 Apartment rental 1,450 Donation 50 Car maintenance 100 Car Repairs 0 Car Insurance 350 Medical insurance 1250 Groceries 300 Miscellaneaous 95 TOTAL Requirement 1 Requirement 4 September Electricity & Water Bill 380 Phone Bill 150 Internet 90 Gas 65 Apartment rental 1,450 Donation 50 Car maintenance 100 Car Repairs 0 Car Insurance 350 Medical insurance 230 Groceries 1100 Miscellaneous 80 TOTAL Requirement 1 Requirement 4 GRAND TOTAL Requirement 1 AVERAGE MONTHLY EXPENSE Requirement 2 NUMBER OF ITEMS IN SEPTEMBER EXCEEDING $300 Requirement 3