Question

symbol\tstock\tfebruary 25 close\tchange\t% change\tfebruary 24 close\tvolume in 1000s\tvolume in 100s
aapl\tapple inc.\t96.76\t0.66\t\t96.1\t27,393\t
bbw\tbuild-a-bear workshop inc.\t13.98\t0.03\t0.22%\t\t188\t
ctb\tcooper tire & rubber co.\t40.3\t1.04\t\t39.26\t727\t
f\tford motor co\t12.39\t0.37\t\t\t31,951\t
intc\tintel corp\t28.8\t\t−1.90%\t\t26,432\t
msft\tmicrosoft corp\t51.18\t\t−2.80%\t52.65\t26,695\t
ntgr\tnetgear inc.\t39.66\t0.59\t1.50%\t\t228\t
yhoo\tyahoo! inc.\t31.36\t\t1.30%\t\t19,842\t
write a formula to determine the net change for each. use the left side of the equation to indicate in which cell to store the formula.
a. microsoft corp.
b. apple inc.

Explanation:

Part a: Microsoft Corp.

Step1: Identify cells for Microsoft

Microsoft is in row 7. February 25 Close is in C7, February 24 Close is in F7. Change (net change) is Close on 25th minus Close on 24th. So the formula for cell D7 (where change is stored for Microsoft) is =C7 - F7.

Step2: Verify

For Microsoft, C7 is 51.18, F7 is 52.65. 51.18 - 52.65 = -1.47 (which matches the context of negative % change, so the formula makes sense as net change = current close - previous close).

Step1: Identify cells for Apple

Apple is in row 2. February 25 Close is in C2, February 24 Close is in F2. Net change is Close on 25th minus Close on 24th. So the formula for cell D2 (where change is stored for Apple) is =C2 - F2.

Step2: Verify

For Apple, C2 is 96.76, F2 is 96.1. 96.76 - 96.1 = 0.66 (which matches the given change value, so the formula is correct).

Answer:

D7: =C7 - F7

Part b: Apple Inc.