Financial Algebra 11-4a MindTap

Question

Use the table below for Exercises 1 and 2.

	July	Aug	Sept	Oct	Nov	Dec	Average
Groceries	740	800	650	820	820	880	a.
Dining Out	120	150	300	80	100	150	b.
Fuel (car)	200	240	320	300	280	220	c.
Cell Phone	104	108	126	140	120	104	d.
Land Line Phone	80	90	60	80	100	88	e.
Electricity	140	160	120	90	140	160	f.
Water	52	58	62	48	48	62	g.

The Shahs (from Exercise 1) decided they would not use the September amounts, when they were on vacation, nor the December amounts, when cousins stayed with them. Assume the chart is a spreadsheet with row 1 as the month labels and column A as the expense categories.

a. Write a spreadsheet formula to calculate the adjusted average for food. fill in the blank 1

b. What is the adjusted average for food? fill in the blank 2

c. Write a spreadsheet formula to calculate the adjusted average for electricity. fill in the blank 3

d. What is the adjusted average for electricity?

Answer 1

a =AVERAGE(B2,C2,E2,F2)

b = 795

c = =AVERAGE(B7,C7,E7,F7)

d = 132.50