In Lab $7\mathrm{.}7$ Excel, Prescriptive Analytics: Calculating Internet CPM Rate Using Goal Seek, you used Excel's Goal Seek to determine how much should be spent on internet advertising. Specifically, the maximum CPM $($cost$-$per$-$mille$)$ rate for $8,000,000$ views. The output for the Goal Seek is shown below. In the Goal Seek, which cell was the Set cell?

$\backslash$table$[[,$A$,$B$],[1,$Total Marketing Budget,$10,000\mathrm{.}00],[2,,],[3,(1)$ Print Ads Percentage of Total Marketing Budget,$0\mathrm{.}2],[4,$Print Ads Budget,$2,000\mathrm{.}00],[5,,],[6,(2)$ Internet Ads Percentage of Total Marketing Budget,$0\mathrm{.}8],[7,$Internet Ads Budget,$8,000\mathrm{.}00],[8,$Cost per $1,000$ views $($CPM$),8,000],[9,$Cost per $1$ view,$0\mathrm{.}0010],[10,$Total Views,$8,000,000\mathrm{.}00]]$

Multiple Cholce

B$8$

B$10$

B$7$

B$6$