Question

Use a SUM formula to create a ledger for column G. Anything in column E should be added while anything in column F should be subtracted. Copy the correct formula to the entire column G.

a) =SUM(E1:F1)
b) =SUM(E1-F1)
c) =SUM(E:E)-SUM(F:F)
d) =SUM(G1:Gn)

Answer 1

The correct formula to create a ledger in column G by adding values from column E and subtracting values from column F is =SUM(E1)-SUM(F1). This formula should be copied down the entire column G. No options provided in the question are suitable for this ledger creation requirement.

Step-by-step explanation:

To create a ledger in column G using a SUM formula that adds values from column E and subtracts values from column F, you need to write a formula that individually handles the addition and subtraction for each row. The correct formula would be =SUM(E1)-SUM(F1) for the first row. This formula adds the value from cell E1 and subtracts the value in cell F1. You would then copy this formula down the entire column G to apply it to all subsequent rows.

The options provided in the question, such as =SUM(E:E)-SUM(F:F), would sum up the entire columns E and F, and =SUM(E1:F1) would simply add both the values in E1 and F1 together, which isn't what we want. Option =SUM(G1:Gn) doesn't make sense in this context as it would attempt to sum the values in column G, which is the column we are trying to calculate. Therefore, none of the options provided in the question are correct for this specific ledger creation task.