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 B9?
A) =SUM(B6:B8)
B) =B6+B7-B8
C) =B6-B7+B8
D) =B10-B8

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 B9?
A) =SUM(B6:B8) 
B) =B6+B7-B8 
C) =B6-B7+B8 
D) =B10-B8

Quizplus · Accepted Answer

Cell B9 is the total cost for all the ads, which includes the cost for the TV ads (B6) and the radio ads (B7), minus any discounts (B8). Therefore, the correct formula is =B6+B7-B8.

Exhibit 7.1 The Following Questions Are Based on the Problem Below