Question

Explain absolute cell referencing with an example. ​

Answer 1

$\huge\tt\pink{\boxed{\tt{\blue{★\:Answer}}}}$

Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill. Dollar signs are used to hold a column and/or row reference constant........^

Answer 2

I hope my answer is right