{"id":15103,"date":"2016-04-03T21:13:35","date_gmt":"2016-04-03T21:13:35","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=15103"},"modified":"2016-04-03T21:13:35","modified_gmt":"2016-04-03T21:13:35","slug":"spreadsheets-relative-referencing","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-relative-referencing\/","title":{"rendered":"Spreadsheets:  relative referencing"},"content":{"rendered":"<h1>The tutor points out an elegant feature of spreadsheets.<\/h1>\n<p>Formulas in Excel default to relative referencing.  Consider the following illustration:<\/p>\n<p>Let&#8217;s imagine you input 101 in cell e10.  Then, in f11, you input the formula <span style=\"font-family:monospace\">=e10<\/span>.  Of course, when you press Enter, f11 will show the value 101 from e10.<\/p>\n<p>Now, suppose you go to g2 and type in the value 105.  Then, you return to f11, right-click, and select Copy.  Next, you go to h3, right click, then select Paste.  Likely, you&#8217;ll see 105 (not 101) appear in h3.  The reason is that the formula <span style=\"font-family:monospace\">=e10<\/span>, placed in f11, has a relative meaning:<\/p>\n<p style=\"font-family:monospace\">=the value in the cell left one, and up one, from this one<\/p>\n<p>Therefore, when that formula is copied to h3, it gives the value from g2.<\/p>\n<p>Relative referencing has powerful consequences.  I&#8217;ll be talking more about it in future posts:)<\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The tutor points out an elegant feature of spreadsheets. Formulas in Excel default to relative referencing. Consider the following illustration: Let&#8217;s imagine you input 101 in cell e10. Then, in f11, you input the formula =e10. Of course, when you &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-relative-referencing\/\"> <span class=\"screen-reader-text\">Spreadsheets:  relative referencing<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1009,1065],"tags":[1544,1543,1542],"class_list":["post-15103","post","type-post","status-publish","format-standard","hentry","category-home-computer-use","category-spreadsheets","tag-relative-referencing-in-formulas","tag-relative-referencing-in-spreadsheets","tag-relative-referencing-of-cells"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/15103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=15103"}],"version-history":[{"count":12,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/15103\/revisions"}],"predecessor-version":[{"id":15115,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/15103\/revisions\/15115"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=15103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=15103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=15103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}