What is the formula on cell B$6$ that will allow you to calculate the average annual stock

return using the GEOMEAN function from $2007$ to $2011?$

a$.=$ GEOMEAN$($B$5$:E$5)$

b$.=$ GEOMEAN$($B$5$:E$5)-1$

c$.=$ GEOMEAN$($B$4$:E$4)$

d$.=$ GEOMEAN$($B$4$:E$4)-1$

e$.=$ GEOMEAN$($B$4$:E$4)+1$ What custom category was used to format cell A$2$ using the data on cell A$1?$

a$.$ #$,$##$0\mathrm{.}00,$

b$.$ #$,$##$0\mathrm{.}00$

c$.$ #$,$###$\mathrm{.}00$

d$.$ #$,$##$0,$

e$.$ #$,$##$0$ Which of the following is the correct formula for cell B$8$ to calculate the cash dividends paid

to shareholders?

a$.=-(B2+(B5-C5))$

b$.=-(B2-(B6-C6))$

c$.=B2-(B5-C5)$

d$.=-$ B$2-($B$5-$C$5)$

e$.$ B$2-($B$5-$C$5))$Which of the following is the correct formula for cell B$5$ to calculate the earnings per share?

a$.=B2-B3**B\frac{2}{B}4$

b$.=\frac{B2-B3}{B}4$

c$.=B2**\frac{1-B3}{B}4$

d$.=\frac{B2+B3**B2}{B}4$

e$.=B2**\frac{1+B3}{B}4$What is the formula on cell B$5$ that will allow you to calculate the arithmetic mean stock

return from $2007$ to $2011?$

a$.\frac{?}{S}=UM\frac{B4\text{:}E4}{4}$

b$.=\frac{B4+C4+D4+E4}{4}$

c$.=$ AVERAGE$($B$4$:E$4)$

d$.$ None of the above

e$.a,b,$ and c