Question

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.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 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 the relationship

The February 25 close (\(C\)) is related to the February 24 close (\(F\)) and the change (\(D\)) by the formula: \(C = F + D\). So, to find \(F\) (February 24 close), we rearrange it as \(F = C - D\).

Step2: Apply to the cell

For NETGEAR Inc. (row 8), the February 25 close is in cell \(C8\), the change is in cell \(D8\), and we want to store the formula in cell \(F8\). So the formula is \(=C8 - D8\).

Part b: Ford Motor Co. (Row 5)

Step1: Identify the relationship

Similar to part a, the February 25 close (\(C\)) is \(F + D\) (where \(F\) is February 24 close and \(D\) is change). So \(F = C - D\).

Step2: Apply to the cell

For Ford Motor Co. (row 5), the February 25 close is in cell \(C5\), the change is in cell \(D5\), and we want to store the formula in cell \(F5\). So the formula is \(=C5 - D5\).

Answer:

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