Question

1 a b c d e f g h 1 symbol stock february 25 close change % change february 24 close volume in 1000s volume in 100s 2 aapl apple inc. 96.76 0.66 96.1 27,393 3 bsw build-a-bear workshop inc. 13.98 0.03 0.22% 188 4 ctb cooper tire & rubber co. 40.3 1.04 39.26 727 5 f ford motor co 12.39 0.37 31,951 6 intc intel corp 28.8 −1.90% 26,432 7 msft microsoft corp 51.18 −2.80% 52.65 26,695 8 ntgr netgear inc. 39.66 0.59 1.50% 228 9 yhoo yahoo! inc. 31.36 1.30% 19,842 write a formula that will store the exact volume for each stock in column i. use the left side of the equation to indicate in which cell to store the formula. a. build-a-bear workshop inc. blank b. netgear inc. blank

Explanation:

Part a: Build - A - Bear Workshop Inc.

Step 1: Identify the volume column

The volume for Build - A - Bear Workshop Inc. is in column G, row 3 (cell G3) and it is in 1000s. To get the exact volume, we multiply the value in G3 by 1000. The cell where we want to store the formula for Build - A - Bear Workshop Inc. is I3 (since it's row 3, column I).

Step 2: Write the formula

The formula to calculate the exact volume is $I3 = G3\times1000$. For the specific cell (I3) and the value in G3 (188), the formula is $I3 = 188\times1000$.

Step 1: Identify the volume column

The volume for NETGEAR Inc. (row 8) is in column G, cell G8 and it is in 1000s. To get the exact volume, we multiply the value in G8 by 1000. The cell where we want to store the formula for NETGEAR Inc. is I8 (row 8, column I).

Step 2: Write the formula

The formula to calculate the exact volume is $I8 = G8\times1000$. For the specific cell (I8) and the value in G8 (228), the formula is $I8 = 228\times1000$.

Answer:

$I3 = G3\times1000$ (or $I3 = 188\times1000$)

Part b: NETGEAR Inc.