Jones Family Household Expenses for February 2022
	Items		$	Over/Underbudget?
January	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		250
	Medical insurance		230
	Groceries		1000
	Miscellaneaous		125
	TOTAL	Q1
February	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		250
	Medical insurance		1250
	Groceries		300
	Miscellaneaous		95
	TOTAL	Q1
March	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		250
	Medical insurance		230
	Groceries		1100
	Miscellaneaous		80
	TOTAL	Q1
	GRAND TOTAL	Q1
	AVERAGE MONTHLY EXPENSE	Q2
	NUMBER OF ITEMS IN MARCH EXCEEDING $1000	Q3

Requirements
1	Calculate the to total Household Expenses for each month and for the quarter ending March .
2	Calculate the average monthly Household Expense for the quarter.
3	How many items in March exceeded $1000?
4	Assuming the Jones family has a monthly budget of $3000, determine of they are over or underbudget for January, February, and March.
5	The Jones family has five children with the following names. Attach the family name "Brown" to each name using the concatenate function.
	Larry
	Jenny
	Tom
	Jerry
	Jessica
	Note: Input your formula and answers in the designated yellow cells. For Q6, input formula and answers in cells I8 through I12.
	Do not change any amount in Column D.
	Make sure to use the excel formulas when calculating.

	Grade points
Excel Formula
AutoSum ,SUM	25
Average	10
COUNTIF	10
IF	30
CONCATENATE
	5
	5
	5
	5
	5
	100