{"id":54657,"date":"2016-11-10T15:37:33","date_gmt":"2016-11-10T18:37:33","guid":{"rendered":"https:\/\/www.estrategiaconcursos.com.br\/blog\/?p=54657"},"modified":"2018-09-27T18:13:55","modified_gmt":"2018-09-27T21:13:55","slug":"referencia-absoluta-e-referencia-relativa-aula-gratuita","status":"publish","type":"post","link":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/","title":{"rendered":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa &#8211; Aula gratuita"},"content":{"rendered":"<p style=\"text-align: justify;\">Ol\u00e1 meus alunos e alunas!<\/p>\n<p style=\"text-align: justify;\"><strong>Refer\u00eancia absoluta e refer\u00eancia relativa<\/strong>, do Microsoft Excel e LibreOffice Calc, \u00e9 um t\u00f3pico dessas mat\u00e9rias que cada vez mais aparece em quest\u00f5es de concursos.<\/p>\n<p style=\"text-align: justify;\">Observando as quest\u00f5es sobre esses assuntos dos \u00faltimos anos, de todas as bancas, percebi que dominar refer\u00eancia absoluta e relativa \u00e9 PREMISSA para resolver a quest\u00e3o. Ou seja, sem o devido conhecimento desses assuntos, n\u00e3o \u00e9 poss\u00edvel sequer iniciar a resolu\u00e7\u00e3o dos exerc\u00edcios.<\/p>\n<p style=\"text-align: justify;\">Pensando nesta dificuldade natural que muitos candidatos possuem com a ferramenta, resolvi gravar esse v\u00eddeo GRATUITO no qual eu explico detalhadamente esse assunto, e ainda, ao final, trago uma quest\u00e3o de concurso que ilustra exatamente n\u00e3o somente o conhecimento, mas o racioc\u00ednio que ser\u00e1 exigido de voc\u00eas em prova.<\/p>\n<p>Bons estudos!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ol\u00e1 meus alunos e alunas! Refer\u00eancia absoluta e refer\u00eancia relativa, do Microsoft Excel e LibreOffice Calc, \u00e9 um t\u00f3pico dessas mat\u00e9rias que cada vez mais aparece em quest\u00f5es de concursos. Observando as quest\u00f5es sobre esses assuntos dos \u00faltimos anos, de todas as bancas, percebi que dominar refer\u00eancia absoluta e relativa \u00e9 PREMISSA para resolver a [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"post_tipo":"article","footnotes":""},"categories":[1],"tags":[],"tax_estado":[],"class_list":["post-54657","post","type-post","status-publish","format-standard","hentry","category-cursos-e-concursos"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita\" \/>\n<meta property=\"og:description\" content=\"Ol\u00e1 meus alunos e alunas! Refer\u00eancia absoluta e refer\u00eancia relativa, do Microsoft Excel e LibreOffice Calc, \u00e9 um t\u00f3pico dessas mat\u00e9rias que cada vez mais aparece em quest\u00f5es de concursos. Observando as quest\u00f5es sobre esses assuntos dos \u00faltimos anos, de todas as bancas, percebi que dominar refer\u00eancia absoluta e relativa \u00e9 PREMISSA para resolver a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\" \/>\n<meta property=\"og:site_name\" content=\"Estrat\u00e9gia Concursos\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-10T18:37:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-27T21:13:55+00:00\" \/>\n<meta name=\"author\" content=\"Coordena\u00e7\u00e3o\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EstratConcursos\" \/>\n<meta name=\"twitter:site\" content=\"@EstratConcursos\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Coordena\u00e7\u00e3o\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"NewsArticle\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\"},\"author\":{\"name\":\"Coordena\u00e7\u00e3o\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/person\/cdad40b5818eb228a838461fcd656da7\"},\"headline\":\"Refer\u00eancia Absoluta e Refer\u00eancia Relativa &#8211; Aula gratuita\",\"datePublished\":\"2016-11-10T18:37:33+00:00\",\"dateModified\":\"2018-09-27T21:13:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\"},\"wordCount\":148,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization\"},\"articleSection\":[\"Concursos P\u00fablicos\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#respond\"]}],\"copyrightYear\":\"2016\",\"copyrightHolder\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\",\"url\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\",\"name\":\"Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita\",\"isPartOf\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#website\"},\"datePublished\":\"2016-11-10T18:37:33+00:00\",\"dateModified\":\"2018-09-27T21:13:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Refer\u00eancia Absoluta e Refer\u00eancia Relativa &#8211; Aula gratuita\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#website\",\"url\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/\",\"name\":\"Estrat\u00e9gia Concursos\",\"description\":\"O blog da Estrat\u00e9gia Concursos traz not\u00edcias sobre concursos e artigos de professores oferecendo cursos para concursos (pdf + videaulas) no site.\",\"publisher\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization\",\"name\":\"Estrat\u00e9gia Concursos\",\"url\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dhg1h5j42swfq.cloudfront.net\/2025\/06\/03203428\/logo_concursos-1.jpg\",\"contentUrl\":\"https:\/\/dhg1h5j42swfq.cloudfront.net\/2025\/06\/03203428\/logo_concursos-1.jpg\",\"width\":230,\"height\":60,\"caption\":\"Estrat\u00e9gia Concursos\"},\"image\":{\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/EstratConcursos\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/person\/cdad40b5818eb228a838461fcd656da7\",\"name\":\"Coordena\u00e7\u00e3o\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g\",\"caption\":\"Coordena\u00e7\u00e3o\"},\"url\":\"https:\/\/www.estrategiaconcursos.com.br\/blog\/author\/contatoestrategiaconcursos-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/","og_locale":"pt_BR","og_type":"article","og_title":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita","og_description":"Ol\u00e1 meus alunos e alunas! Refer\u00eancia absoluta e refer\u00eancia relativa, do Microsoft Excel e LibreOffice Calc, \u00e9 um t\u00f3pico dessas mat\u00e9rias que cada vez mais aparece em quest\u00f5es de concursos. Observando as quest\u00f5es sobre esses assuntos dos \u00faltimos anos, de todas as bancas, percebi que dominar refer\u00eancia absoluta e relativa \u00e9 PREMISSA para resolver a [&hellip;]","og_url":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/","og_site_name":"Estrat\u00e9gia Concursos","article_published_time":"2016-11-10T18:37:33+00:00","article_modified_time":"2018-09-27T21:13:55+00:00","author":"Coordena\u00e7\u00e3o","twitter_card":"summary_large_image","twitter_creator":"@EstratConcursos","twitter_site":"@EstratConcursos","twitter_misc":{"Escrito por":"Coordena\u00e7\u00e3o","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#article","isPartOf":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/"},"author":{"name":"Coordena\u00e7\u00e3o","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/person\/cdad40b5818eb228a838461fcd656da7"},"headline":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa &#8211; Aula gratuita","datePublished":"2016-11-10T18:37:33+00:00","dateModified":"2018-09-27T21:13:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/"},"wordCount":148,"commentCount":0,"publisher":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization"},"articleSection":["Concursos P\u00fablicos"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#respond"]}],"copyrightYear":"2016","copyrightHolder":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/","url":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/","name":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa - Aula gratuita","isPartOf":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#website"},"datePublished":"2016-11-10T18:37:33+00:00","dateModified":"2018-09-27T21:13:55+00:00","breadcrumb":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/referencia-absoluta-e-referencia-relativa-aula-gratuita\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.estrategiaconcursos.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Refer\u00eancia Absoluta e Refer\u00eancia Relativa &#8211; Aula gratuita"}]},{"@type":"WebSite","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#website","url":"https:\/\/www.estrategiaconcursos.com.br\/blog\/","name":"Estrat\u00e9gia Concursos","description":"O blog da Estrat\u00e9gia Concursos traz not\u00edcias sobre concursos e artigos de professores oferecendo cursos para concursos (pdf + videaulas) no site.","publisher":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.estrategiaconcursos.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#organization","name":"Estrat\u00e9gia Concursos","url":"https:\/\/www.estrategiaconcursos.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/dhg1h5j42swfq.cloudfront.net\/2025\/06\/03203428\/logo_concursos-1.jpg","contentUrl":"https:\/\/dhg1h5j42swfq.cloudfront.net\/2025\/06\/03203428\/logo_concursos-1.jpg","width":230,"height":60,"caption":"Estrat\u00e9gia Concursos"},"image":{"@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/EstratConcursos"]},{"@type":"Person","@id":"https:\/\/www.estrategiaconcursos.com.br\/blog\/#\/schema\/person\/cdad40b5818eb228a838461fcd656da7","name":"Coordena\u00e7\u00e3o","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a413b22da0f5009c634f6c4586a2dbe5207074fd5becd88db5183b8069ef25e4?s=96&d=mm&r=g","caption":"Coordena\u00e7\u00e3o"},"url":"https:\/\/www.estrategiaconcursos.com.br\/blog\/author\/contatoestrategiaconcursos-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/posts\/54657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/comments?post=54657"}],"version-history":[{"count":2,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/posts\/54657\/revisions"}],"predecessor-version":[{"id":143850,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/posts\/54657\/revisions\/143850"}],"wp:attachment":[{"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/media?parent=54657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/categories?post=54657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/tags?post=54657"},{"taxonomy":"tax_estado","embeddable":true,"href":"https:\/\/www.estrategiaconcursos.com.br\/blog\/wp-json\/wp\/v2\/tax_estado?post=54657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}