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.4k 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
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.