Question

a\tb\tc\td\te\tf\tg\th
1\tsymbol\tstock\tfebruary 25 close\tchange\t% change\tfebruary 24 close\tvolume in 1000s\tvolume in 100s
2\taapl\tapple inc.\t96.76\t0.66\t\t96.1\t27,393\t
3\tbbw\tbuild-a-bear workshop inc.\t13.98\t0.03\t0.22%\t\t188\t
4\tctb\tcooper tire & rubber co.\t40.3\t1.04\t\t39.26\t727\t
5\tf\tford motor co\t12.39\t0.37\t\t\t31,951\t
6\tintc\tintel corp\t28.8\t\t−1.90%\t\t26,432\t
7\tmsft\tmicrosoft corp\t51.18\t\t−2.80%\t52.65\t26,695\t
8\tntgr\tnetgear inc.\t39.66\t0.59\t1.50%\t\t228\t
9\tyhoo\tyahoo! inc.\t31.36\t\t1.30%\t\t19,842\t
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. \t18=g8×1000 \t❌
b. netgear inc. \tblank \t❌

Explanation:

Step1: Identify Volume Columns

Column G is "Volume in 1000s", so to get exact volume, multiply G by 1000. For Netgear Inc. (row 8), G8 is the volume in 1000s.

Step2: Formulate the Calculation

To store in column I (row 8, cell I8), the formula is \( I8 = G8 \times 1000 \).

Answer:

\( I8 = G8 \times 1000 \)