Mention the two way of entering …

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

Mention the two way of entering a cell reference in a formula. Explain the difference between them

Posted by Katyayni Sahu 2 years, 9 months ago

CBSE > Class 06 > Computer

2 answers

Smruti Swarup Mohapatra 2 years, 9 months ago

Bal

0Thank You

Sia ? 2 years, 9 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.

0Thank You

ANSWER

Related Questions

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Anurag Mishra 3 weeks, 6 days ago

CBSE > Class 06 > Computer

1 answers

I want all exercise of computer book IT VISION ch 9

Posted by Shonaya Yaduvanshi 1 month ago

CBSE > Class 06 > Computer

0 answers

A virus enters a computer to an attachment with an

Posted by Guddu Gupta 2 weeks ago

CBSE > Class 06 > Computer

2 answers

Write write a steps to export the sprite to a predefined folder

Posted by Virat Shende 2 weeks, 5 days ago

CBSE > Class 06 > Computer

1 answers

Explain the type of ethical issues

Posted by Mubasshir Ahmed 2 days, 18 hours ago

CBSE > Class 06 > Computer

0 answers

Full form of HIIP

Posted by Rishabh Verma 2 weeks, 5 days ago

CBSE > Class 06 > Computer

1 answers

What is mail merge?

Posted by Ishita Panwar 1 week, 1 day ago

CBSE > Class 06 > Computer

1 answers

How are higher level languages different from lower level languages?

Posted by Rewanshi Agrawal 2 weeks ago

CBSE > Class 06 > Computer

1 answers

Which of the following is not an operator option A interpreter option B compiler option C Assembler option D all of the above

Posted by Sushant Honalwad 1 month ago

CBSE > Class 06 > Computer

2 answers

Who launched A.I and who is inventor of A.I

Posted by Aradhya Srivastava 1 day, 22 hours ago

CBSE > Class 06 > Computer

2 answers

myCBSEguide

CBSE, JEE, NEET, CUET

myCBSEguide

Test Generator

CUET Mock Tests

Download myCBSEguide App

All Courses

Other Websites

CBSE Courses

Resources

Corporate

NCERT Solutions

CBSE Sample Papers