2. Define the following cell references with an example:
a. Absolute reference
b. Relative reference
b.Mixed reference
Share
2. Define the following cell references with an example:
a. Absolute reference
b. Relative reference
b.Mixed reference
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
I hope you have understood..
Answer:
i)Absolute Cell References. 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.
example:-=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell
ii) All cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
iii)A mixed cell reference is either an absolute column and relative row or absolute row and relative column. For example, $A1 is absolute for column A and relative for row 1, and A$1 is absolute for row 1 and relative for column A.