Question

25. See the screenshot below. What function can be used in cell G8 to compute total revenue? =PRODUCT(G3:G6,H3:H6) =PRODUCT(G3:G6*H3:H6) =PRODUCT(G3:H6) =SUMPRODUCT(G3:G6,H3:H6) =SUMPRODUCT(G3:G6*H3:H6) =SUMPRODUCT(G3:H6) =MMULT(G3:G6,H3:H6) =MMULT(G3:G6*H3:H6) =MMULT(G3:H6)

Answer 1

Answer:

See the complete question in the picture attached:

The answer is:

• =SUMPRODUCT(G3:G6,H3:H6)

Explanation:

The revenue is the sum of the products of the price and the number of units sold for each item (product).

The prices are in colum G and rows 3 through 6. This is, cells G3:G6

The number of units sold are in column H, and in the same rows as the prices, of course. This is, cells H3:H:6.

The function SUMPRODUCT, in a workseet like Excel, returns the sum of the products of multiples cells in an array.

The correct format is:

• =SUMPRODUCT(G3:G6,H3:H6)

You might also use :

• +SUMPRODUCT(G3:G6,H3:H6); as the symbol + has the same function as the symbol =.

That function, first, multiplies the content of G3 by H3, the content of G4 by H4, the content of G5 by H5, and the content of G6 by H6. Then, it adds up every product, yielding the desired result: the total revenue.