Question

how will you use absolute cell referencing to compare the increase in salaries of ten employees if the percentage of increase is 10%,20% and 30%?​

Answer 1

Answer:

Hey mate,

here is your 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