Question

shanaya has written the formula =$B$1*A1 in cell C1 (in Excel).
(Q1) What will be the formula in cells C2, C3 and C4, if she selects cell C1 and drags the fill handle through C2:C4?
(Q2) What type of cell referencing does the formula =$B$1*A1 specify?
​

Answer 1

Answer:

Ans No 1: the formula will in cell C2 will  =$B$1*A2

                 the formula will in cell C3 will  =$B$1*A3

                the formula will in cell C4 will  =$B$1*A4

Ans No 2: absolute formulas

Explanation:

Each of these types of formulas has a name.  Formulas where both the row and column are locked with a dollar sign are called absolute formulas.