Exhibit 7.1
The following questions are based on the problem below.
A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.
-Refer to Exhibit 7.1. What formula goes in cell D6?
A) =SUMPRODUCT(B2:B3,B6:B7)
B) =B2*C2+B6*C6
C) =SUMPRODUCT(B2:C2,B10:C10)
D) =SUMPRODUCT(B2:C2,B6:C6)

Question

Exhibit 7.1
The following questions are based on the problem below.
A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet. 
-Refer to Exhibit 7.1. What formula goes in cell D6?
A) =SUMPRODUCT(B2:B3,B6:B7) 
B) =B2*C2+B6*C6 
C) =SUMPRODUCT(B2:C2,B10:C10) 
D) =SUMPRODUCT(B2:C2,B6:C6)

Quizplus · Accepted Answer

Cell D6 is asking for the total cost of producing the desired number of TV and radio ads. The formula that calculates this is the sum product of the number of ads (B2:B3 and B6:B7) and their respective costs (C2:C3 and C6:C7), which is represented by the formula =SUMPRODUCT(B2:C2,B6:C6). Therefore, the best choice is D.

Exhibit 7.1 The Following Questions Are Based on the Problem Below