Question

В ячейке D7 записана формула (С3+С5)/С6. Как она изменится при переносе этой формулы на ячейку: а) D8 б) E7 в) C6 г) F10 как это решить без компьютера? не используя Excel

Answer 1

A) (C4+C6)/D7

б) (D3+D5)/E6

в) (B2+B4)/C5

г) (E6+E8)/F9

Answer 2

Understanding the Formula in Cell D7

The formula in cell D7 is `(C3 + C5) / C6`. This formula calculates the sum of the values in cells C3 and C5, and then divides that sum by the value in cell C6.

How the Formula Changes when Transferred to Different Cells

Let's analyze how the formula `(C3 + C5) / C6` would change when transferred to different cells:

a) D8: If the formula is transferred to cell D8, the formula would adjust automatically to reflect the new cell references. The new formula in cell D8 would be `(C4 + C6) / C7`. The cell references have shifted by one row downwards.

b) E7: If the formula is transferred to cell E7, the formula would adjust automatically to reflect the new cell references. The new formula in cell E7 would be `(D3 + D5) / D6`. The cell references have shifted by one column to the right.

c) C6: If the formula is transferred to cell C6, the formula would adjust automatically to reflect the new cell references. The new formula in cell C6 would be `(B2 + B4) / B5`. The cell references have shifted by one column to the left.

d) F10: If the formula is transferred to cell F10, the formula would adjust automatically to reflect the new cell references. The new formula in cell F10 would be `(E6 + E8) / E9`. The cell references have shifted by one column to the left and one row downwards.

Solving the Problem without Using Excel

To solve this problem without using Excel, you can manually adjust the cell references based on the given instructions. Here's how you can do it:

1. For transferring the formula to cell D8, you need to shift the cell references by one row downwards. So, the new formula would be `(C4 + C6) / C7`.

2. For transferring the formula to cell E7, you need to shift the cell references by one column to the right. So, the new formula would be `(D3 + D5) / D6`.

3. For transferring the formula to cell C6, you need to shift the cell references by one column to the left. So, the new formula would be `(B2 + B4) / B5`.

4. For transferring the formula to cell F10, you need to shift the cell references by one column to the left and one row downwards. So, the new formula would be `(E6 + E8) / E9`.

By following these steps, you can manually adjust the formula without using Excel.