Question

1
a symbol b stock c february 25 close d change e % change f february 24 close g volume in 1000s h volume in 100s
2 aapl apple inc. 96.76 0.66 96.1 27,393
3 bbw 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. intel corp: select
b. yahoo! inc: select

Explanation:

Part a: Intel Corp.

Step1: Identify the cell and column

Intel Corp. is in row 6. We need to calculate the volume in column I (let's assume I6 as the cell to store the formula). The volume in 1000s is in column G (G6 for Intel Corp.). To get the exact volume, we multiply the volume in 1000s by 1000.

Step2: Write the formula

The formula for cell I6 (Intel Corp.) would be to take the value in G6 and multiply by 1000. So the formula is $I6 = G6 * 1000$. For Intel Corp., G6 is 26,432. So $I6 = 26432 * 1000$.

Step1: Identify the cell and column

Yahoo! Inc. is in row 9. We need to calculate the volume in column I (cell I9). The volume in 1000s is in column G (G9 for Yahoo! Inc.). To get the exact volume, we multiply the volume in 1000s by 1000.

Step2: Write the formula

The formula for cell I9 (Yahoo! Inc.) is to take the value in G9 and multiply by 1000. So the formula is $I9 = G9 * 1000$. For Yahoo! Inc., G9 is 19,842. So $I9 = 19842 * 1000$.

Answer:

For Intel Corp. (row 6), the formula to store in cell I6 is $I6 = G6 * 1000$ (or numerically, $I6 = 26432\times1000$)

Part b: Yahoo! Inc.