Which is the right formula for B5?





a) {=SUM(C2:C4*B2:B4)}

b) =B2*C2+B3*C3+B4*C4

c) =SUMPRODUCT(B2:B4,C2:C4)

d) All of the above

e) None of the above


d) All of the above

Business

You might also like to view...

Roseland Company is trying to decide whether to continue to manufacture a particular component or to buy the component from an outside supplier. Which of the following is irrelevant with respect to this decision?

A) the quality of the component purchased from the outside supplier B) the outside supplier's ability to deliver the component on a timely basis C) the alternative uses of the facilities currently being used to manufacture the component D) the unavoidable fixed manufacturing costs associated with the manufacture of the component

Business

Which of the following statements is true?

A) The budgeted balance sheet is prepared after the cash budget. B) The cash budget is prepared before the direct materials purchases budget. C) The production budget is the first budget to be prepared in the master budget. D) Service firms need not prepare a master budget. E) The cost of goods sold budget is prepared before the direct labor and overhead budgets.

Business

Answer the following statement(s) true (T) or false (F)

1. Trade blocs are groups of countries who form an association for the purpose of facilitating movement of goods across national borders. 2. The global village refers to companies conducting business worldwide without boundaries. 3. The purpose of the World Trade Organization is to open trade for the benefit of all. 4. As companies begin to operate in multiple markets, HR managers should be concerned with complying with only home-country legal requirements. 5. According to the Foreign Corrupt Practices Act, U.S.-based or U.S.-listed companies cannot bribe foreign officials in exchange for business.

Business

Certain acts have been declared crimes by

a. a jury. b. a judge. c. the district attorney. d. the U.S. Congress and state legislatures.

Business