Question

How will you use absolute cell refrencing to compare the increase in salaries of ten employees if the percentage of increase is 10%,20%,30,

Answer 1

Answer:

hat jaa re chokre bheja naa thok re

Answer 2

Answer:

assume the column in which you have written the salaries is A and that is there principal amount

let the increase of particular person be in column B

and write 100 in some other cell suppose h1

so use dollar sign

like this : = ($B1 / $A1) * $H$1

now select the cell and by keeping your curser on + that comes on side and extend down the length till wherever you want and then you can get your answer