The image contains two math problems related to spreadsheet formulas. Problem 22: Evaluate the spreadsheet formula $=2^3 / (5-1^3) * 5$. Problem 23: Determine which formula, when written in cell A4 and copied to D4, will result in the correct values in the spreadsheet. Problem 24: Determine what number will be displayed in cell A5 if the formula =MAX(A1:A3, D3) is entered.

1. Problem Description

The image contains two math problems related to spreadsheet formulas.

Problem 22: Evaluate the spreadsheet formula $=2^3 / (5-1^3) * 5$.

Problem 23: Determine which formula, when written in cell A4 and copied to D4, will result in the correct values in the spreadsheet.

Problem 24: Determine what number will be displayed in cell A5 if the formula =MAX(A1:A3, D3) is entered.

2. Solution Steps

Problem 22:

We need to evaluate the expression $=2^3 / (5-1^3) * 5$.

First, evaluate the exponents: $2^3 = 8$ and $1^3 = 1$.

Then, the expression becomes $=8 / (5 - 1) * 5$.

Next, evaluate the parentheses: $(5 - 1) = 4$.

The expression is now $=8 / 4 * 5$.

Perform the division: $8 / 4 = 2$.

Finally, perform the multiplication: $2 * 5 = 10$.

Problem 23:

A4 has value

4. B4 has value

8. C4 has value

1

2. D4 has value

1

6. A1 has value

4. A3 has value

1. If cell A4 has formula $=A1*A3$, so $=4*1=4$. When you copy this formula from A4 to B4, cell B4 will have formula $=B1*B3=$empty$*1=0$. Which is not

8. If cell A4 has formula =$A1*A3, so =$A1*A3=$4*1=4$. When you copy this formula from A4 to B4, cell B4 will have formula =$A1*B3=$4*2=

8. When you copy this formula from A4 to C4, cell C4 will have formula =$A1*C3=$4*3=

1

2. When you copy this formula from A4 to D4, cell D4 will have formula =$A1*D3=$4*4=

1

6. If cell A4 has formula =A$1*A3, so =A$1*A3=$4*1=

4. When you copy this formula from A4 to B4, cell B4 will have formula =B$1*B3=$empty*1=

0. This is not

8. If cell A4 has formula =$A1*$A3, so =$A1*$A3=$4*$1=

4. This formula will not change when copied.

Therefore, the correct formula is =$A1*A

3.

Problem 24:

The formula is =MAX(A1:A3, D3).

A1:A3 represents the cells A1, A2, A

3. Their values are 4, empty, and

1. D3 has value

3. The values being considered by the MAX function are 4, empty, 1, and

3. Assuming the empty cell is treated as zero.

The maximum of these values is

4.

3. Final Answer

Problem 22: 2) 10

Problem 23: 2) =$A1*A3

Problem 24: 3) 4