Question

cell e2 in this spreadsheet most likely contains which formula?

	a	b	c	d	e
2	apples	case	4	$30.00	$120.00
3	oranges	case	13	$35.00	$455.00
4	bananas	box	19	$29.00	$551.00
5	tomatoes	case	24	$40.00	$960.00
6	eggplants	each	2	$1.00	$2.00
7	purple onions	each	7	$0.50	$3.50
8					$2,091.50

a. =sum(e2:e7)
b. =e2/d2
c. =c2*d2
d. =sum(a8:d8)

Explanation:

Step1: Analyze Columns

Column C is Quantity, Column D is Cost, Column E is Value. For row 2, E2 is $120, C2 is 4, D2 is $30. 4*30=120.

Step2: Evaluate Options

• Option A: SUM(E2:E7) would be in E8 (total), not E2. Eliminate.
• Option B: E2/D2 = 120/30=4, which is C2, not Value. Eliminate.
• Option C: C2D2 = 430=120, matches E2. Correct.
• Option D: SUM(A8:D8) – A8-D8 are empty, irrelevant. Eliminate.

Answer:

C. =C2*D2