contestada

Enter a formula using arithmetic operators and parentheses in cell B10 that adds the grant amounts in cells B4, B5, B6, and B7, and then multiplies that result by 12

Respuesta :

MrRoyal

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)

Otras preguntas