Tags Microsoft Excel

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

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

Anonymous

∙ 8y ago

Updated: 10/3/2023

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

Kyleigh Kling ∙

Lvl 10

∙ 3y ago

Still curious? Ask our experts.

Chat with our AI personalities

Lao

The path is yours to walk; I am only here to hold up a mirror.

Chat with Lao

Jordan

Looking for a career mentor? I've seen my fair share of shake-ups.

Chat with Jordan

Vivi

Your ride-or-die bestie who's seen you through every high and low.

Chat with Vivi

More answers

Yes. An absolute reference is $B$17.

Wiki User

∙ 15y ago

true

tintswaloayanda ∙

Lvl 2

∙ 3y ago

Add your answer:

Earn +20 pts

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

Write your answer...

Submit

Still have questions?

imp

Trending Questions

What is the symbol above the comma on a keyboard called? What is the value of a 20 gallon hand painted western stoneware crock? What is the dot on a screen that contains color? What features is the most important characteristic that distinguishes a computer from some of the simpler and less versatile calculating devices like calculators? How does the distinction between monitor mode and user mode function as form of protection system? What causes a computer glitch? Excel is an example of? Who are the top 100 soccer players? Where can one buy a new monitor speaker? What city is halfway between Plano TX and Abilene TX? How do you include a field in an access query? To start a program from an icon you would? How is Linux growing? What does csv mean? If on a Windows 2000 server this error occured while starting Windows 'tcpscvs exe-application error memory could not be read ' how can this be fixed? How can you find out how much crucial ram a computer needs? Where can one purchase toner for an HP 3600? Why is it doubling of the system processor speed does not resulting in doubling of the system performance? Where can you get ink cartridges refilled? What terms refers to the number of horiontal and vertical pixels in a display device?

Related Questions

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.

F61 is a relative reference or absolute?

F61 is a relative reference in Excel. $F$61 is an absolute 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.

Is c6 an absolute or a rellative cell reference?

C6 is a relative reference. $C$6 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.

Is a1 an example fo an absolute reference?

No. a1 is a relative reference. $a$1 is an absolute reference.

What is an example of an absolute cell reference?

Relative cell reference: A2 Absolute cell reference: $A$2

What characters is used in Excel to change a relative cell reference to an absolute cell reference?

The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.The $ is used to make a mixed or absolute reference.A1 is a relative reference.$A1 and A$1 are mixed references.$A$1 is an absolute reference.

A cell reference of B17 is?

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.

What formula that excel use to adjust the cell reference as it to the destination area?

Yes it does. This is because reference "B20" is relative and not absolute. You can change a cell reference so that the column and/or the row reference is absolute and then it will not change when copied to another cell. Click on the help icon and search for "relative absolute" and read the help article for further information.

In Excel a cell reference of B17 is it an invalid cell reference?

No it is not invalid. It is the cell address of the cell where column B meets row 17. It is a relative cell address.

What is the difference between an relative reference?

absolute reference is the adress or pointer that does not changes while relative reference changes when the target item is moved or the relationship to it has changed

What is a cell reference with two dollar signs?

If there is only one dollar used like $A1 or A$1 then it is known as a mixed reference. A relative reference has no dollars, like A1, and an absolute reference has two dollar signs, like $A$1.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.