I know this is kind of unrelated to what category this question is asked in, but I would assume some of y'all have used Excel in the past, and so this is an excel question.

What is the purpose and value of inserting functions with an absolute address or a relative address? Few sentences suffice.

How does Excel allow the user to improve and personalize a worksheet?