Computer Science, asked by suyashdubey948, 5 months ago

Define Absolute referencing in spreadsheet with an example.​

Answers

Answered by Aeslvah
1

Answer:

In Microsoft Excel and other spreadsheet programs, an absolute cell reference or ACR is a spreadsheet cell that remains the same even if it's copied or moved. Absolute cell reference overview. Examples of an absolute cell reference.

example:

Absolute references are noted by a dollar sign in front of the cell reference. So a relative cell reference might look like =A1+A2 but an absolute reference might look like =$A$1+$A$2. (Actually, the formula can also look like =$A1+$A2 or =A$1+A$2, but let's not get ahead of ourselves.)

Answered by Shrisha7576
1
Absolute reference is the designated in the formula by the addition of a dollar sign Some of the example are A$2, $ A$2 , etc..... Plz mark me as the brainliest
Similar questions