Question

lesson 6: mystery computations cool down: what does this do? 1. what value will be in cell c1 after the formula is entered? 2. what value will be in cell c1 if the numbers in column a are changed to 1, 2, 3, 4, and 5 in that order?

Explanation:

Step1: Identify values for first - part

In the original problem, A1 = 2, A2 = 5, A3 = 7.

Step2: Calculate value for C1 in first - part

Substitute values into formula $(A1 + A2)\times A3=(2 + 5)\times7=49$.

Step3: Identify values for second - part

When column A values are changed, A1 = 1, A2 = 2, A3 = 3.

Step4: Calculate value for C1 in second - part

Substitute new values into formula $(A1 + A2)\times A3=(1 + 2)\times3 = 9$.

Answer:

1. 49
2. 9