Question

elizabeth monthly budget
elizabeth is making the following budget table using an electronic spreadsheet.
what formula should elizabeth use to calculate the \difference ($)\ between the \expected total income\ and the \actual total income\ in cell \et\?
= c7 - d7
= sum(c7:d7)
= sum(e3:e4)
= c18 - d18

Explanation:

Step1: Analyze the formula purpose

The goal is to find the difference between "Expected Total Income" (in cell \(C7\)) and "Actual Total Income" (in cell \(D7\)).

Step2: Evaluate each formula option

• For \(=C7 - D7\): This formula subtracts the value in \(D7\) (Actual Total Income) from the value in \(C7\) (Expected Total Income), which is exactly what is needed to calculate the difference.
• For \(=\text{sum}(C7:D7)\): The \(\text{sum}\) function adds the values in \(C7\) and \(D7\), which is not for calculating a difference.
• For \(=\text{sum}(E3:E4)\): This sums values in column \(E\) (which are differences of sub - categories), not the total income difference.
• For \(=C18 - D18\): \(C18\) and \(D18\) are related to total income - expenses, not the total income difference.

Answer:

\(=C7 - D7\)