The problem is to identify which of the provided spreadsheet formulas (A, B, and C) are correctly written. A = MAX(B2:B6) B = MAX(B2:B6, C2, C3:C6) C = MAX(B2+B3, B4+B5, D6)

1. Problem Description

The problem is to identify which of the provided spreadsheet formulas (A, B, and C) are correctly written.

A = MAX(B2:B6)

B = MAX(B2:B6, C2, C3:C6)

C = MAX(B2+B3, B4+B5, D6)

2. Solution Steps

The $MAX$ function in spreadsheets typically finds the maximum value within a given range or set of values.

Formula A: $A = MAX(B2:B6)$. This formula calculates the maximum value within the cell range from B2 to B6, which is a valid use of the MAX function.

Formula B: $B = MAX(B2:B6, C2, C3:C6)$. This formula finds the maximum value among the cells from B2 to B6, the cell C2, and the cells from C3 to C

6. This is a valid use of the $MAX$ function, as it finds the largest number in a list of single cells and a range.

Formula C: $C = MAX(B2+B3, B4+B5, D6)$. This formula calculates the maximum value among three values. The first value is the sum of the values in cells B2 and B

3. The second value is the sum of the values in cells B4 and B

5. The third value is the value in cell D

6. This is also a valid use of the $MAX$ function.

Since all three formulas, A, B, and C, are valid spreadsheet formulas, the answer is (4).

3. Final Answer

(4) All A, B and C