Question

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

Answer 1

B is the correct answer.

Answer 2

Answer: Option 'B' is correct.

Step-by-step explanation:

Since we have given that

There are three types of movies :

1) Animated

2) Drama

3) Action.

Since At B2 cell, there is Animated movie.

Since we have given the average of three animated movies = 73

Length of 1 movie is at B2 cell.

Length of 2nd movie = 63

Length of 3 rd movie = 84

As we know the formula for "average":

$Average=\dfrac{\text{Sum of all observations}}{\text{Total number of observations}}\\\\\\73=\dfrac{B2+63+84}{3}\\\\3\times 73=B2+63+84\\\\3\times E3-(C2+D2)=B2$

Hence, Option 'B' is correct.