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

The spreadsheet shows the length of 3 movies in each of 3 categories. Choose the formula-example-1

2 Answers

1 vote
B is the correct answer.
User Tsdbrown
by
7.9k points
3 votes

Answer: Option 'B' is correct.

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=\frac{\text{Sum of all observations}}{\text{Total number of observations}}\\\\\\73=(B2+63+84)/(3)\\\\3* 73=B2+63+84\\\\3* E3-(C2+D2)=B2

Hence, Option 'B' is correct.

User Johnlemon
by
8.4k points