Mention the two way of entering …
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Katyayni Sahu 4 years, 1 month ago
- 2 answers
Sia ? 4 years, 1 month ago
Two ways of entering a cell reference in a formula:
a. Relative reference: In this method, reference to a cell is based on the position relative to the cell.
Example: A3 = A1 + A2
b. Mixed reference: In this type of reference, either row or column is fixed by placing a dollar sign ($) before it.
Example: A3 = $A1 + AS2 .
The difference between the two ways becomes visible when the formula is copied to other cells. In case of relative reference, the cell reference automatically gets changed whereas the fixed column or row remains unchanged in case of mixed reference.
Related Questions
Posted by Sanvi Sanvi 8 months, 3 weeks ago
- 0 answers
Posted by Riddhi Meghani 1 year, 2 months ago
- 0 answers
Posted by Riddhi Meghani 1 year, 2 months ago
- 1 answers
Posted by Ravneet Reet 1 year, 1 month ago
- 0 answers
Posted by Sanvi Sanvi 9 months, 2 weeks ago
- 0 answers
Posted by A Sanjay Kumar 2 months ago
- 1 answers
Posted by Viraj Mane 1 year, 1 month ago
- 0 answers
Posted by Preetam Nath 1 year, 1 month ago
- 2 answers
Posted by Vineet Tomar 1 year, 2 months ago
- 1 answers
Posted by A.. Jatav 1 year, 1 month ago
- 1 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Smruti Swarup Mohapatra 4 years, 1 month ago
0Thank You