111k views
5 votes
What is the correct cell range for the command =Average(B2:C6)? 1) B2:C6 2) B2:B6 3) C2:C6 4) C2:B6

User Bouramas
by
8.7k points

1 Answer

4 votes

Final answer:

The correct cell range for the command =Average(B2:C6) is C2:C6. Therefore, the correct option is 3).

Step-by-step explanation:

The correct cell range for the command =Average(B2:C6) is option 3) C2:C6.

The AVERAGE function in Excel calculates the arithmetic mean of a range of cells. In this case, the range is from C2 to C6, which includes cells C2, C3, C4, C5, and C6.

Option 1) B2:C6 is not correct because it includes both columns B and C, while the command specifies only column C. Option 2) B2:B6 only includes column B. Option 4) C2:B6 is not a valid cell range.

Therefore, the correct option is 3).

User Ricardo Henriques
by
8.0k points