Question

note: please make sure to properly format your answers. all dollar figures in the answers need to include the dollar sign and any amount over 1,000 should include the comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.06).

	a	b	c	d	e	f	g	h
2	aapl	apple inc.	96.76	0.68		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 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. f8 = c8 - d8 (with a red cross)
b. ford motor co. f5 = c5 - d5 (with a red cross)

Explanation:

Part a: NETGEAR Inc. (Row 8)

Step1: Understand the relationship

The February 24 close (cell F8) is equal to the February 25 close (cell C8) minus the change (cell D8), because \( \text{Change} = \text{Feb 25 Close} - \text{Feb 24 Close} \), so rearranging gives \( \text{Feb 24 Close} = \text{Feb 25 Close} - \text{Change} \).

Step2: Formulate the cell formula

For cell F8 (February 24 close for NETGEAR Inc.), the formula is \( F8 = C8 - D8 \). Wait, but the original answer was marked wrong? Wait, maybe I mixed up. Wait, \( \text{Change} = \text{Feb 25 Close} - \text{Feb 24 Close} \), so \( \text{Feb 24 Close} = \text{Feb 25 Close} - \text{Change} \) is correct. Wait, maybe the error is in the cell reference? Wait, NETGEAR is row 8. C8 is Feb 25 close (39.66), D8 is change (0.59). So F8 should be C8 - D8 = 39.66 - 0.59 = 39.07. Wait, but maybe the formula is correct? Wait, maybe the system has a different expectation? Wait, no, let's re-express. The change is (Feb 25 Close - Feb 24 Close), so Feb 24 Close = Feb 25 Close - Change. So the formula \( F8 = C8 - D8 \) is correct. Wait, maybe the original answer was marked wrong by mistake? Or maybe I misread the columns. Let's check the table:

Columns: C is Feb 25 Close, D is Change, F is Feb 24 Close. So yes, F8 (Feb 24 Close for row 8) = C8 (Feb 25 Close) - D8 (Change). So the formula is \( F8 = C8 - D8 \).

Part b: Ford Motor Co. (Row 5)

Step1: Understand the relationship

Similarly, for Ford Motor Co. (row 5), February 24 close (cell F5) is equal to February 25 close (cell C5) minus the change (cell D5), since \( \text{Change} = \text{Feb 25 Close} - \text{Feb 24 Close} \), so \( \text{Feb 24 Close} = \text{Feb 25 Close} - \text{Change} \).

Step2: Formulate the cell formula

For cell F5 (February 24 close for Ford Motor Co.), the formula is \( F5 = C5 - D5 \). Let's verify: C5 is 12.39, D5 is 0.37. So 12.39 - 0.37 = 12.02. So the formula \( F5 = C5 - D5 \) is correct.

Answer:

s:
a. \( F8 = C8 - D8 \)
b. \( F5 = C5 - D5 \)