Question

b.
In relation to formulae in Excel, answer these questions.
•Cell B4 contains the formula =A1+A2+B1+B2. What are the contents of
cell D6 if B4 is copied to D6?
•Cell B4 contains the formula =$A$1+$A$2+B1+B2. What are the contents
of cell D6 if B4 is copied to D6?
•Cell B4 contains the formula =A1+$A2+B$1+SB2. What are the contents
of cell D6 if B4 is copied to D6?​

Answer 1

Let’s review what we said in Lesson 2 about rows and columns so that we can explore cell references further.

Cells in the spreadsheet are referred to by rows and columns. Columns are vertical and labeled with letters. Rows are horizontal and labeled with numbers.

The first cell in the spreadsheet is A1, which means column A, row 1, B3 refers to the cell located on the second column, third row, and so on.

For learning purposes about cell references, we will at times write them as row, column, this is not valid notation in the spreadsheet and is simply meant to make things clearer.

Types of cell references

There are three types of cell references.

Absolute – This means the cell reference stays the same if you copy or move the cell to any other cell. This is done by anchoring the row and column, so it does not change when copied or moved.

hope it helps you man kare to tq de dena wrna koi ni ham mare ni ja rhe hai