Question

The spreadsheet shows the length of 3 movies in each of 3 categories. Choose the formula that could be used in cell B2.

(Animated Movie 1 - 72 Minutes. This is what is in cell B2.)
Animated Movie 2 - 63 Minutes.
Animated Movie 3 - 84 minutes.
Mean Length - 73

Drama Movie 1- 92 Minutes.
Drama Movie 2 - 104 Minutes.
Drama Movie 3 - 113 Minutes
Mean length -103

Action Movie 1 - 119
Action Movie 2 - 84 Minutes
Action Movie 3 - 109
Mean Length - 104

A. 3 * E2 - (B2 + D2)

B. 3 * E2 - (C2 + D2)

C. 3 * E3 - (C3 + D3)

D. (B3 + C3 + D3)/3

Answer 1

Hm, ok i hate to say this but i cant gurantee 100% correct but i beleive the answear to this question is C. 3*E3 - (C3 + D3)

Answer 2

Cell D has 84 in it and cell E has 73 in it.

Answer 3

If that helps any...