Answer:
= SUM(B4:B7) * 12
Explanation:
Required
Enter a formula in B10
First we need to sum up cells B4 to B7;
Cells B4, B5, B6 and B7 are on the same column and are in a sequential order.
To sum them up, we make use of
SUM(B4:B7)
Which means add contents of cell B4 to cell B7
Next, we multiply the result by 12
This is done by:
SUM(B4:B7) * 12
In Excel, the equality sign (=) indicates that we are writing a formula.
So, the formula will be written in cell B10 as:
=SUM(B4:B7)
