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, 3 months ago
- 2 answers
Sia ? 4 years, 3 months 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 A Sanjay Kumar 3 months, 3 weeks ago
- 1 answers
Posted by A.. Jatav 1 year, 3 months ago
- 1 answers
Posted by Vineet Tomar 1 year, 3 months ago
- 1 answers
Posted by Preetam Nath 1 year, 3 months ago
- 2 answers
Posted by Riddhi Meghani 1 year, 3 months ago
- 1 answers
Posted by Viraj Mane 1 year, 3 months ago
- 0 answers
Posted by Sanvi Sanvi 10 months, 1 week ago
- 0 answers
Posted by Riddhi Meghani 1 year, 3 months ago
- 0 answers
Posted by Sanvi Sanvi 11 months ago
- 0 answers
Posted by Ravneet Reet 1 year, 3 months ago
- 0 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, 3 months ago
0Thank You