The _________ function pairs each element of the first array with its counterpart in the second array, multiplies the elements of the pairs together, and adds the results

a. SUM b. SUMPRODUCT
c. SUMIF d. VLOOKUP


b
RATIONALE: The SUMPRODUCT function returns the sum of the products of elements in a set of arrays.

Business

You might also like to view...

Estimated residual value is ignored entirely under which of the following methods of depreciation?

a. Production b. Straight-line c. Tax depreciation d. Double-declining-balance

Business

In the U.S., employers have the right to hire permanent strike replacements in:

A. an economic strike B. an unfair labor practice strike C. any strike that would create an economic hardship for the employer D. a noneconomic strike

Business

What are the advantages of a computerized payroll system over a manual system?

What will be an ideal response?

Business

These funds try to invest in companies that will not cause harm to humans, animals, or the environment.

A) Large Capitalization Funds B) Mid-Size Capitalization Funds C) Sector Funds D) Small Capitalization Funds E) Socially Responsible Funds

Business