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

 

A

B

C

D

E

1

Type of Movie

Movie 1
(min. long)

Movie 2
(min. long)

Movie 3
(min. long)

Mean Length

2

Animated

72

63

84

73

3

Drama

92

104

113

103

4

Action

119

84

109

104

 

A. 3 * E2 - (B2 + D2)

 

B. 3 * E2 - (C2 + D2)

 

C. 3 * E3 - (C3 + D3)

 

D. (B3 + C3 + D3)/3