answersLogoWhite

0


Best Answer

if you move or copy the formula to another cell, the cells referred formula will changed. Excel adjusts the cell references relative to the new cell in which the formula is pasted. this is called relative referencing.

User Avatar

Wiki User

2013-03-06 12:15:14
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

➡️
See all cards
4.13
188 Reviews

Add your answer:

Earn +20 pts
Q: What is relative reference?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What type of cells reference is C19?

It is a relative cell reference.


A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.?

relative cell reference


When copying or moving formulas in an Excel worksheet the default type of cell reference is called?

A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.A relative reference.


F61 is a relative reference or absolute?

F61 is a relative reference in Excel. $F$61 is an absolute reference.


Is it true F61 is an absolute reference and F61 is a relative reference?

Not quite. F61 is a relative reference. $F$61 is an absolute reference.


What type of cell reference is AB17?

It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.It is a relative cell reference.


Is B17 is an absolute reference and B17 is a relative reference?

B17 is a relative reference. $B$17 is an absolute reference. See the related question below.


Is B17 is a relative reference and B17 is an absolute reference.?

B17 is a relative reference. $B$17 is an absolute reference. See the related question below.


How do you write cell K23 as a relative reference?

K23 is a relative reference. For example: =K23*10


Is B17 is a relative reference and B17 is an absolute reference?

B17 is a relative reference. $B$17 is an absolute reference. See the related question below.


What type of cell reference is N29?

It is a relative reference.


A10 is an example of absolute reference?

No. A10 is a relative reference. $A$10 would be an absolute reference. As a relative reference, it will change when a formula is copied. An absolute reference will not changed in a formula when it is copied.

People also asked