Computer Science, asked by shivanitrisha9, 9 months ago

explain the difference with an example between relative absolute and mixed reference need correct answer only​

Answers

Answered by smaranika21
2

Answer:

Hey mate,here's your answer

Explanation:

In Absolute Cell Referencing the cell references remain constant and does not change with change in formula position, when copied to a new position. ... In Mixed Cell Referencing either a column or a row is made absolute or fixed with help of $(Dollar) sign.

Hope it helps u

Please mark me a brainlist. ☺☺

Answered by ridahussain86
5

Switch between relative, absolute, and mixed references

If the reference is: It changes to:

$A$1 (absolute column and absolute row) $A$1 (the reference is absolute)

A$1 (relative column and absolute row) C$1 (the reference is mixed)

$A1 (absolute column and relative row) $A3 (the reference is mixed)

Similar questions