Exhibit 3.2
The following questions are based on this problem and accompanying Excel windows.
The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.
-Refer to Exhibit 3.2. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?
A) =B4*C4+B5*C5
B) =SUMPRODUCT(B4:C4,B5:C5)
C) =SUM(B5:C5)
D) =SUM(E8:E10)

Question

Exhibit 3.2
The following questions are based on this problem and accompanying Excel windows.
The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.   
-Refer to Exhibit 3.2. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?
A) =B4*C4+B5*C5 
B) =SUMPRODUCT(B4:C4,B5:C5) 
C) =SUM(B5:C5) 
D) =SUM(E8:E10)

Quizplus · Accepted Answer

The SUMPRODUCT function multiplies the corresponding cells in the two ranges and then adds the products. In this case, the formula in cell E5 should be =SUMPRODUCT(B4:C4,B5:C5) to compute total profit.

Exhibit 3.2 The Following Questions Are Based on This Problem and Accompanying