Question

Suppose cell C5 contains the formula =B$6+C1. Match each formula with its respective cell if you copied it.

Answer 1

Answer:

The options are not being given. However, we can place the $ sign in front of letter or number we make it constant across the rows or across the columns. By $B we mean, the column will remain same as B as we move across the rows down or up, and by $6 we mean the row will remain fixed to 6 as you move right or left of the cell where you place $6.

Thus, B$6 + C1,will change to below as you move down:

B$6 + C2

B$6 + C3

B$6 + C5

...... and so on.

and if we move left, it will become:

C$6 +D6

D$6 +E6

E$6 +F6

.........and so on.

Please keep an eye on the letter and number, the way they change in each condition, like if its B the next is C irrespective of columns where the next column starts.

Explanation:

The answer is self explanatory.