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 to determine the close on february 24 for each of the following. use the left side of the equation to indicate in which cell to store the formula.
a. netgear inc.

b. ford motor co.

Explanation:

Part a: NETGEAR Inc. (Row 8)

Step1: Identify relevant cells

February 25 Close is in cell C8, Change is in cell D8. To find February 24 Close (cell F8), we use the relationship: February 24 Close = February 25 Close - Change.

Step2: Write the formula

In cell F8, the formula is $=C8 - D8$

Step1: Identify relevant cells

February 25 Close is in cell C5, Change is in cell D5. To find February 24 Close (cell F5), we use the relationship: February 24 Close = February 25 Close - Change.

Step2: Write the formula

In cell F5, the formula is $=C5 - D5$

Answer:

F8: =C8 - D8

Part b: Ford Motor Co. (Row 5)