What formula will be obtained when copying the formula from E2 to E4?

Let's analyze the formula in E2 and the movement from E2 to E4.

The formula in cell E2 is f=A2*C2. This formula refers to cell A2 and cell C2.

We are copying this formula from E2 to E4. This means we are moving 2 rows down (from row 2 to row 4).

In spreadsheet formulas, relative cell references change when copied to a different row or column. Absolute cell references (marked with '$$') do not change.

Let's break down the references in the formula =A2*C2:

• A2: This is a relative reference. When copied down 2 rows, the row number will increase by 2. So, '2' will become '2+2 = 4'. The column 'A' will remain 'A' because we are moving vertically.
• C2: This is also a relative reference. When copied down 2 rows, the row number will increase by 2. So, '2' will become '2+2 = 4'. The column 'C' will remain 'C'.

Therefore, when the formula =A2*C2 is copied from E2 to E4, the new formula will be =A4*C4.

Now let's look at the provided options:

1. =$$A$$2*$$C$$4: This uses absolute references for both cells. This would not change when copied.
2. =A2*$$C$$2: This uses a relative reference for A2 and an absolute reference for C2.
3. =$$A$$2*C4: This uses an absolute reference for A2 and a relative reference for C4.
4. =A4*C4: This matches our calculation for relative references moving down 2 rows.

The question asks what formula will be obtained when copying the formula *from E2* to E4. The formula in E2 is shown as f=A2*C2. If we assume 'f=' is just a label and the actual formula is A2*C2, then our analysis holds.

However, let's consider the possibility that the formula in E2 might have absolute references. The image shows f=A2*C2 in the formula bar above the spreadsheet grid, but the question refers to copying *the formula from E2*. Let's assume the formula in E2 is indeed =A2*C2.

If the formula in E2 is =A2*C2, and we copy it to E4 (moving 2 rows down), the relative references will change:

• A2 becomes A(2+2) = A4
• C2 becomes C(2+2) = C4

So the resulting formula in E4 would be =A4*C4.

Let's re-examine the image carefully. The formula bar clearly shows f=A2*C2. This implies the formula in E2 is =A2*C2. The question asks what formula will be obtained *when copying the formula from E2 to E4*. This means we are considering how relative references behave.

Option 1: `=$$A$$2*$$C$$4`. This would be the result if the original formula was something like `= $$A$$2*$$C$$2` and was copied to E4, and also if the original formula was `$$A$$2*C2` and copied to E4. However, the original is `A2*C2`. If the original was `$$A$$2*$$C$$2`, copying to E4 would result in `$$A$$2*$$C$$2` (no change due to absolute references). If the original was `=$$A$$2*C2` and copied to E4, it would become `=$$A$$2*C4`. This doesn't match option 1.

Option 2: `=A2*$$C$$2`. If the original was `=A2*$$C$$2` and copied to E4, it would become `=A4*$$C$$2`.

Option 3: `=$$A$$2*C4`. If the original was `=$$A$$2*C2` and copied to E4, it would become `=$$A$$2*C4`. This looks promising if the original formula in E2 had an absolute reference for A2.

Option 4: `=A4*C4`. If the original formula in E2 is =A2*C2 (all relative), and it's copied to E4 (moving down 2 rows), then A2 becomes A4 and C2 becomes C4. This results in =A4*C4.

Given that the formula bar explicitly shows f=A2*C2, and assuming 'f=' is just a display artifact and the formula is =A2*C2, then the behavior of relative references dictates that copying it down 2 rows will change A2 to A4 and C2 to C4. Thus, the resulting formula is =A4*C4.

Let's check the example values: In E2, the formula `=A2*C2` would calculate `34 * 56 = 1904`. However, the value in E2 is 6930. This suggests that the formula in E2 is NOT `=A2*C2`. Let's re-examine the image, specifically the formula bar. It says `f=A2*C2`. This is highly unusual. Usually, the formula bar shows the formula *used to calculate* the displayed value in the active cell.

Let's assume the formula in cell E2 is actually `=$$A$$2*$$C$$2`. If this formula is copied to E4, since both references are absolute, the formula remains `=$$A$$2*$$C$$2`. This is not among the options.

Let's assume the formula in cell E2 is `=A2*$$C$$2`. If copied to E4, it becomes `=A4*$$C$$2`. Not an option.

Let's assume the formula in cell E2 is `=$$A$$2*C2`. If copied to E4, it becomes `=$$A$$2*C4`. This is option 3.

Let's assume the formula in cell E2 is `=A2*C2`. If copied to E4, it becomes `=A4*C4`. This is option 4.

The provided value in E2 is 6930. Let's see which formula, when placed in E2, would result in 6930 using the values from A2 (34) and C2 (56). None of the options seem to directly calculate 6930 from A2 and C2. However, the question is about copying the formula, not verifying the current value.

Let's rely on the formula bar reading: f=A2*C2. This strongly suggests the formula *in E2* is intended to be =A2*C2. If this is the case, and we copy it to E4 (moving 2 rows down), relative references change: A2 becomes A4, and C2 becomes C4. Thus, the result is =A4*C4.

It's possible there's a typo in the question or the provided formula. However, following standard spreadsheet behavior for relative references:

Original cell: E2

Formula in E2: `=A2*C2` (assuming `f=` is a prefix and `A2*C2` is the core formula)

Target cell: E4

Movement: 2 rows down.

Relative reference A2 moves to A(2+2) = A4.

Relative reference C2 moves to C(2+2) = C4.

Resulting formula: `=A4*C4`.

This matches option 4.

Let's consider if the question implies absolute references from the start. The text for question 19 is: "Какая Формула будет получена при копировании в Е4 формулы из Е2?" (What Formula will be obtained when copying the formula from E2 to E4?). The options provided are formulas themselves. The image shows the formula bar containing f=A2*C2.

If we assume the formula in E2 is actually `=$$A$$2*$$C$$4` (Option 1), and copy it to E4, it remains `=$$A$$2*$$C$$4`. But the question is asking what is OBTAINED. If the formula in E2 was `=A2*$$C$$2` (Option 2) and copied to E4, it would become `=A4*$$C$$2`.

The most standard interpretation is that if the formula bar shows `=A2*C2` in E2, and it's copied to E4, relative references adjust.

Therefore, the formula =A2*C2 copied from E2 to E4 will become =A4*C4.

Ответ: 4) =A4*C4