Question

What formula would you enter into B7 to calculate the total budget?

A. =3B+4B+5B+6B
B. =B3<>B6
C. =B3:B6
D. =B3+B4+B5+B6

Answer 1

D. =B3+B4+B5+B6

This formula would add together the values in the cells B3, B4, B5, and B6 which are the cells containing the budget amounts for Food, Gas, Cable, and Phone respectively. This would give you the total budget by adding up all the values.