<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2392820458712511103</id><updated>2024-11-02T04:59:02.672-07:00</updated><category term="Dicas do excel"/><category term="Células"/><category term="Excel"/><category term="Excel soma"/><category term="Caixa de diálogo Ir para"/><category term="Excel contagem dos itens"/><category term="Excel divisão"/><category term="Excel formatação de células"/><category term="Excel multiplicação"/><category term="Excel média"/><category term="Excel subtração"/><category term="Formatar"/><category term="Função soma"/><category term="Nomear células"/><category term="Planilha de Excel"/><category term="Potência no Excel"/><category term="Raiz Quadrada"/><category term="Raiz enésima"/><category term="Rótulos em fórmulas"/><category term="VPL"/><category term="Validação de dados"/><category term="Valor presente líquido"/><category term="dar nome a células"/><category term="funções localização e uso"/><category term="somatório"/><title type='text'>Dicas para Excel</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>14</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-7164136325836255560</id><published>2011-02-05T05:40:00.000-08:00</published><updated>2011-02-05T05:40:19.785-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="dar nome a células"/><category scheme="http://www.blogger.com/atom/ns#" term="Nomear células"/><title type='text'>Definir nomes, definir rótulos, criar uma lista de nomes</title><content type='html'>Assim como existem rótulos (&lt;a href=&quot;http://exceldicasgerais.blogspot.com/2011/02/rotulos-em-formulas.html&quot;&gt;link para postagem neste blog&lt;/a&gt;) você pode também dar nomes a uma ou mais células, a uma área toda e a células não contíguas.&lt;br /&gt;
&lt;br /&gt;
Há duas formas para se dar nomes a células: &lt;br /&gt;
&lt;br /&gt;
Para nomear uma célula ou intervalo de células você pode:&lt;br /&gt;
&lt;br /&gt;
dar o nome usando a caixa de nome. Assim: &lt;br /&gt;
&lt;ol&gt;&lt;li&gt;Selecione a célula ou as células a serem nomeadas;&lt;/li&gt;
&lt;li&gt;Use a caixa de nome (canto superior esquerda da planilha) para dar um nome.&lt;/li&gt;
&lt;/ol&gt;A partir daí, ao se referir&amp;nbsp;àquele nome, você estará indicando&amp;nbsp;a célula ou ao conjunto delas que serão afetadas pelo nome.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
﻿ &lt;br /&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7FJWGPoqGipnhRla1kugtfxVvsbuGPDRuX5ZujEjzZvM_OEb6qI8aD0_Pax00SodZ7UZYpF2zly2WL4fCfV4A4akpup_mnKzAr3iMv0c6YQSrrQ_esqeeKBHc8xygqTr4FBgT4BHXvOI/s1600/figura+17+Nome+de+c%25C3%25A9lulas.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; closure_uid_1u2a92=&quot;201&quot; h5=&quot;true&quot; height=&quot;239&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7FJWGPoqGipnhRla1kugtfxVvsbuGPDRuX5ZujEjzZvM_OEb6qI8aD0_Pax00SodZ7UZYpF2zly2WL4fCfV4A4akpup_mnKzAr3iMv0c6YQSrrQ_esqeeKBHc8xygqTr4FBgT4BHXvOI/s400/figura+17+Nome+de+c%25C3%25A9lulas.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Dei o nome de Área para a célula A1.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿&lt;br /&gt;
Você pode nomear, ou dar nome as células, usando uma caixa de diálogo: veja como:&lt;br /&gt;
&lt;ol&gt;&lt;li&gt;Inserir;&lt;/li&gt;
&lt;li style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;Nome&lt;/li&gt;
&lt;/ol&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;Escolha a opção conforme figura abaixo:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8BAIumqqLNqqU1YBX_l6F5lB7KXCwPDwe67nFpoOQ-ppP8ChRnNbuNdHyPih40Sc1qmwplaQDD1bLz5pYVtcHZ-VAuXAVXEXuylK_pywNqPc3804NqAm9AnlkfQNCUhDjm9qGbVn3XuQ/s1600/figura+18+nome+de+uma+c%25C3%25A9lula.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;262&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8BAIumqqLNqqU1YBX_l6F5lB7KXCwPDwe67nFpoOQ-ppP8ChRnNbuNdHyPih40Sc1qmwplaQDD1bLz5pYVtcHZ-VAuXAVXEXuylK_pywNqPc3804NqAm9AnlkfQNCUhDjm9qGbVn3XuQ/s400/figura+18+nome+de+uma+c%25C3%25A9lula.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;Você poderá escolhar:&lt;/div&gt;&lt;ul&gt;&lt;li&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&amp;nbsp;&lt;strong&gt;&lt;em&gt;definir&lt;/em&gt;&lt;/strong&gt;: ﻿ significa que você irá para uma caixa de diálogo que lhe permitira dar nome às células selecionadas. &lt;/div&gt;&lt;/li&gt;
&lt;li&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&lt;em&gt;&lt;strong&gt;Colar&lt;/strong&gt;&amp;nbsp;&lt;/em&gt; significa que você poderá listar todos os nomes que você já deu às células com as respectivas referências (não entraremos com exemplo nesse caso, exercite no seu excel);&lt;/div&gt;&lt;/li&gt;
&lt;li&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&lt;strong&gt;&lt;em&gt;Criar&lt;/em&gt;&lt;/strong&gt; nesta opção você entra numa caixa de diálogo que lhe permite criar rótulos de linhas e colunas, a diferença de criar esses rótulos com essa ferramenta, é que aqui a coluna e a linha não precisam ser a coluna a e a linha 1, como na opção vista na postagem.&lt;/div&gt;&lt;/li&gt;
&lt;/ul&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;Exemplo da caixa de diálogo definir nome na figura a seguir&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ7eeWQcXxBpV-fL5NAtTA9o-IALHatJ7qm0Ioi6DW4sNLmGS691W-hCdqG-mpj2LiEVvHdjWcLherbD_pvxWzYNJmM1C_rh9k6-89Kgs1nm3CkkyATfxvOSWtvhbGca4zUW6SgaVGzS4/s1600/Figura+19+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;250&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ7eeWQcXxBpV-fL5NAtTA9o-IALHatJ7qm0Ioi6DW4sNLmGS691W-hCdqG-mpj2LiEVvHdjWcLherbD_pvxWzYNJmM1C_rh9k6-89Kgs1nm3CkkyATfxvOSWtvhbGca4zUW6SgaVGzS4/s400/Figura+19+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;div align=&quot;left&quot;&gt;Foi dado o nome de &quot;NomeExemplo&quot; para as células&amp;nbsp;&quot;C4 a C20&quot;&amp;nbsp;&amp;nbsp;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div align=&quot;left&quot; class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;﻿&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;Suponha que a planilha tenha o seguinte conteúdo nas células acima nomeadas:&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidrW5_rlLaOj49Uw3OP7nNR-OnlvixjXfufS6rLoHWgA41TPz29PeKCq80sX7audpDC-UEFt2nu8RToKR6L52nGnBT7XzY9BI41JXK_SzoY6F6c66Mp0qMa_iC3ije91JI362jZZxACak/s1600/Figura+20+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;400&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidrW5_rlLaOj49Uw3OP7nNR-OnlvixjXfufS6rLoHWgA41TPz29PeKCq80sX7audpDC-UEFt2nu8RToKR6L52nGnBT7XzY9BI41JXK_SzoY6F6c66Mp0qMa_iC3ije91JI362jZZxACak/s400/Figura+20+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; width=&quot;238&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Exemplo sde algumas fórmulas usando o campo nomeado acima:&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&quot;=SOMA(NomeExemplo)&quot; resultado 627,54&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&quot;=MÉDIA(NomeExemplo)&quot; resultado 36,91&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&quot;=ÍNDICE(NomeExemplo;4)&quot; resultado 28,00&amp;nbsp; (selecione a &lt;strong&gt;&lt;em&gt;função índice&lt;/em&gt;&lt;/strong&gt; e estude a sua estrutura, usando a ajuda de seu Excel)&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&quot;=MAIOR(NomeExemplo;1)&quot; resultado 92 (no caso o resultado se refere ao primeiro maior)&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&quot;=MAIOR(NomeExemplo;2)&quot; resultado 63 (no caso o resultado se refere ao segundo maior)&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;﻿ &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;﻿ &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Criar : quando você seleciona criar abre-se a Caixa de diálogo &quot;&lt;em&gt;&lt;strong&gt;Criar nomes&lt;/strong&gt;&lt;/em&gt;&quot;. Observe no exemplo que antes de você abrir a caixa de díalogo, a área a ser objeto da criação de nomes deve estar selecinado. Conforme aescolha que você fizer, o&amp;nbsp; nome escrito na linha superio, coluna a esquerda, Linha inferior,&amp;nbsp;Coluna direita, &amp;nbsp;passa a ser o nome das células selecionadas.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;﻿﻿ &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgh2uoDAEY_sOtTmy8FCH6eaAk4FsP6X3NcOwOrnBU1gohAHwHey15qYD3clZtZfezR8JDwGTmLJmB-M_ko33atWH1PWnSBO8ILdtU0M6c1tH2NjsAvsbhpSC02NaDEDA0lXrkyGU3VTJQ/s1600/Figura+21+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;400&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgh2uoDAEY_sOtTmy8FCH6eaAk4FsP6X3NcOwOrnBU1gohAHwHey15qYD3clZtZfezR8JDwGTmLJmB-M_ko33atWH1PWnSBO8ILdtU0M6c1tH2NjsAvsbhpSC02NaDEDA0lXrkyGU3VTJQ/s400/Figura+21+exemplo+da+caixa++di%25C3%25A1logo+dar+nome.jpg&quot; width=&quot;312&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;div align=&quot;left&quot;&gt;Neste exemplo e seleção, as células de &quot;A2 a A16&quot; &lt;/div&gt;&lt;div align=&quot;left&quot;&gt;foram agora nomeadas para &quot;Números&quot;&lt;/div&gt;&lt;div align=&quot;left&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div align=&quot;left&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿﻿ &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Criar pode funcionar como a opção&amp;nbsp;aceitar &amp;nbsp;rótulos já visto no link &amp;nbsp;﻿(&lt;a href=&quot;http://exceldicasgerais.blogspot.com/2011/02/rotulos-em-formulas.html&quot;&gt;link para criar rótulo&lt;/a&gt;), a diferença fica por conta da localização, usando a opção aceitar rótulos, você especifica a linha 1 e a coluna A como detentoras dos rótulos, já&amp;nbsp;no caso de criar nomes, você escolhe uma área com células contíguas e especifica a localização dos rótulos se acima ou abaixo, se a direita ou esquerda, no exemplo abaixo isso é bem esclarecido:&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbl6HKkdQJ4zs_g3JqLLZGRukcPZU2uWXBDuff94QV4ycai5cty17y6DdD00VwK9codCumenNEkPMghQDLzLJkUelPg1LRti7uDFo6q9Qx5JApDqUiK8son4fLbU3QAK5sF9KnMKmEgYI/s1600/Figura+22+exemplo+da+criar+nomes.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbl6HKkdQJ4zs_g3JqLLZGRukcPZU2uWXBDuff94QV4ycai5cty17y6DdD00VwK9codCumenNEkPMghQDLzLJkUelPg1LRti7uDFo6q9Qx5JApDqUiK8son4fLbU3QAK5sF9KnMKmEgYI/s320/Figura+22+exemplo+da+criar+nomes.jpg&quot; width=&quot;284&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;div align=&quot;left&quot;&gt;Exemplo de criação de nomes usando a linha superior&lt;/div&gt;&lt;div align=&quot;left&quot;&gt;e a coluna esquerda para definir o nome ou rótulo&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Agora que estamos com alguns nomes já definidos, vejamos como funciona a opção colar: como o nome indica, cola os&amp;nbsp; nomes a partir da célula seleciona, como no exemplo abaixo.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;﻿ &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0uqrhPfkAKoZ4bJCspkq3HO3kMiAxko7m94gX4xhqJJByCw-5qYM8aIwum_e6Z_gidLnUfafOKSeq6755Pe90nF8W2W-Vd-rgmk6AYzhBRKUtA5GE7DmGheMvRQu_mu4qS9GePr8SNfY/s1600/Figura+23+colar+nomes.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; h5=&quot;true&quot; height=&quot;390&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0uqrhPfkAKoZ4bJCspkq3HO3kMiAxko7m94gX4xhqJJByCw-5qYM8aIwum_e6Z_gidLnUfafOKSeq6755Pe90nF8W2W-Vd-rgmk6AYzhBRKUtA5GE7DmGheMvRQu_mu4qS9GePr8SNfY/s400/Figura+23+colar+nomes.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;div align=&quot;left&quot;&gt;Listagem dos nomes dados.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿ &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&amp;nbsp;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/7164136325836255560/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/02/definir-nomes-definir-rotulos-criar-uma.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7164136325836255560'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7164136325836255560'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/02/definir-nomes-definir-rotulos-criar-uma.html' title='Definir nomes, definir rótulos, criar uma lista de nomes'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7FJWGPoqGipnhRla1kugtfxVvsbuGPDRuX5ZujEjzZvM_OEb6qI8aD0_Pax00SodZ7UZYpF2zly2WL4fCfV4A4akpup_mnKzAr3iMv0c6YQSrrQ_esqeeKBHc8xygqTr4FBgT4BHXvOI/s72-c/figura+17+Nome+de+c%25C3%25A9lulas.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-735478842033250368</id><published>2011-02-03T02:08:00.000-08:00</published><updated>2011-02-03T02:29:13.233-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Excel"/><category scheme="http://www.blogger.com/atom/ns#" term="Rótulos em fórmulas"/><title type='text'>Rótulos  em fórmulas</title><content type='html'>O padrão do Excel não permite rótulos em fórmulas, mas se você quiser fazer referência a uma célula usando rótulos, então, deverá primeiro definir isso para o Excel. Como: vá a&lt;strong&gt;&lt;em&gt; Ferramentas&lt;/em&gt;&lt;/strong&gt;, selecione&lt;strong&gt;&lt;em&gt; Opções&lt;/em&gt;&lt;/strong&gt; e a guia &lt;strong&gt;Cálculo&lt;/strong&gt;, depois escolha &lt;em&gt;&lt;strong&gt;Aceitar rótulos em fórmulas&lt;/strong&gt;&lt;/em&gt;. Isso significa que&amp;nbsp; o que você lançar na primeira linha e o que lançar na primeira coluna será considerado rótulo no âmbito&amp;nbsp;da planilha corrente.&amp;nbsp;&amp;nbsp;Abaixo a caixa de díalogo para isso:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW3XSZtvfKJ5TC62lQUpYkBYLQlj4_rsRiQuj4Xrqj4pPorAoiTaXya-_AZPxcr1v13FmRtk6ZZqHRf_z-tNfsQEpOShOgHhWMkSLzZc311IgixymWqX-xXP0Yy51pxiNLtowEcmMM9T0/s1600/Figura+15+r%25C3%25B3tulos+em+formulas.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;318&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW3XSZtvfKJ5TC62lQUpYkBYLQlj4_rsRiQuj4Xrqj4pPorAoiTaXya-_AZPxcr1v13FmRtk6ZZqHRf_z-tNfsQEpOShOgHhWMkSLzZc311IgixymWqX-xXP0Yy51pxiNLtowEcmMM9T0/s400/Figura+15+r%25C3%25B3tulos+em+formulas.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;Ao clicar ok, você agora poderá usar rótulos de fórmulas na sua planilha.&lt;br /&gt;
Na planilha abaixo:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1swDsxKgI_oHqdDI-m48ipIrzQKBIqENq1nicyj4L0Mku80Ciq2-V5bzDIkeyynmmUXc0WGiWpUAJ-Cb9AgBQloLPYDvNQRQytWKxyJ693q6sApO9F8qeQrJucRuPbk6or7MlO6dNytA/s1600/Figura+16+r%25C3%25B3tulos+dos+dados.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;391&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1swDsxKgI_oHqdDI-m48ipIrzQKBIqENq1nicyj4L0Mku80Ciq2-V5bzDIkeyynmmUXc0WGiWpUAJ-Cb9AgBQloLPYDvNQRQytWKxyJ693q6sApO9F8qeQrJucRuPbk6or7MlO6dNytA/s400/Figura+16+r%25C3%25B3tulos+dos+dados.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div align=&quot;left&quot; class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div align=&quot;left&quot; class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;para a fórmula &quot;= Luiz Salário&quot; o resultado será 1500&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;para a fórmula &quot;=Salário Luiz&quot; o resultado será 1500&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para a fórmula &quot;= Josefa Salário + Luiz Salário&quot; o resultado será 4000&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para a fórmula &quot;=Soma(Salário) o resulado será 18100&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para a fórmula &quot;=ÍNDICE(Salário;2)&quot; o resultado será 4000&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para a fórmula &quot;=Pedro Salário * Pedro PercContrib&quot; o resultado será 60&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para a fórmula &quot;﻿=PercContrib Josefa&quot; o resultado será 0,01 ou 1%&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/735478842033250368/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/02/rotulos-em-formulas.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/735478842033250368'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/735478842033250368'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/02/rotulos-em-formulas.html' title='Rótulos  em fórmulas'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW3XSZtvfKJ5TC62lQUpYkBYLQlj4_rsRiQuj4Xrqj4pPorAoiTaXya-_AZPxcr1v13FmRtk6ZZqHRf_z-tNfsQEpOShOgHhWMkSLzZc311IgixymWqX-xXP0Yy51pxiNLtowEcmMM9T0/s72-c/Figura+15+r%25C3%25B3tulos+em+formulas.jpg" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-3766615763820672777</id><published>2011-01-27T04:18:00.000-08:00</published><updated>2011-01-27T04:21:50.058-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Células"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel"/><category scheme="http://www.blogger.com/atom/ns#" term="Formatar"/><title type='text'>Formatar células no Excel</title><content type='html'>Na barra de ferramentas padrão, clique em &lt;em&gt;&lt;strong&gt;Formatar&lt;/strong&gt;&lt;/em&gt;&amp;nbsp; a seguir em&lt;strong&gt;&lt;em&gt;&amp;nbsp; células,&lt;/em&gt; &lt;/strong&gt;isso abre a caixa abaixo: &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2z1GEdOo2TNLZJ7VYg3rJ5r10JUsc6sf3IQkhNO1t8_f6B17VHTiHg_elfQ1re9udxAUbxigWk1Y6Mx9D53CYlofb28qu6eGbjszfHfTTaenZ0i5CBa_ma3aO5Ym2hpjFCSplMKbhs5Q/s1600/Caixa+de+di%25C3%25A1logo+formatar+c%25C3%25A9lula.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;378&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2z1GEdOo2TNLZJ7VYg3rJ5r10JUsc6sf3IQkhNO1t8_f6B17VHTiHg_elfQ1re9udxAUbxigWk1Y6Mx9D53CYlofb28qu6eGbjszfHfTTaenZ0i5CBa_ma3aO5Ym2hpjFCSplMKbhs5Q/s400/Caixa+de+di%25C3%25A1logo+formatar+c%25C3%25A9lula.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Para formatar um número, selecione &lt;strong&gt;&lt;em&gt;número&lt;/em&gt;&lt;/strong&gt;, escolha a &lt;strong&gt;&lt;em&gt;categoria&lt;/em&gt;&lt;/strong&gt; e depois o formato desejado.﻿ A cada escolha de um formato,&amp;nbsp;a maneira como o número irá se apresentar na célula é mostrada na &lt;em&gt;&lt;strong&gt;janela Exemplo&lt;/strong&gt;&lt;/em&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Se nenhuma das categorias listadas não o atender, selecione &lt;strong&gt;Personalizado &lt;/strong&gt;e desenvolva o formato: digite na &lt;strong&gt;&lt;em&gt;Janela tipo&lt;/em&gt;&lt;/strong&gt; o formato desejado, considerando-se que o símbolo # indica a eliminação de zeros à esquerda, &amp;nbsp;incluindo a posição em que foi colocado, exemplo:&amp;nbsp; se célula &quot;A1=50&quot;, &amp;nbsp;e você criar o formato &quot;##0,00&quot; o resultado será &quot;0,50&quot; , mas se você criar o formato &quot;###,00&quot; o resultado será&amp;nbsp; &quot;,50&quot;. &lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Observação: alguns desses formatos, por serem muito usados, já estão na barra de ferramentas &quot;Formatação&quot;.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Agora, faça você mesmo algumas formatações &amp;nbsp;para: &amp;nbsp;moeda, percentagem etc. Caso tenha alguma dúvida, mande-me um comentário que respondo.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/3766615763820672777/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/formatar-celulas-no-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/3766615763820672777'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/3766615763820672777'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/formatar-celulas-no-excel.html' title='Formatar células no Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2z1GEdOo2TNLZJ7VYg3rJ5r10JUsc6sf3IQkhNO1t8_f6B17VHTiHg_elfQ1re9udxAUbxigWk1Y6Mx9D53CYlofb28qu6eGbjszfHfTTaenZ0i5CBa_ma3aO5Ym2hpjFCSplMKbhs5Q/s72-c/Caixa+de+di%25C3%25A1logo+formatar+c%25C3%25A9lula.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-5530927244981673765</id><published>2011-01-26T08:39:00.000-08:00</published><updated>2011-01-26T08:39:08.854-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dicas do excel"/><category scheme="http://www.blogger.com/atom/ns#" term="Valor presente líquido"/><category scheme="http://www.blogger.com/atom/ns#" term="VPL"/><title type='text'>Cálculo do Valor Presente líquido no Excel</title><content type='html'>Suponha que você tenha&amp;nbsp;uma &amp;nbsp;série histórica que representa as entradas e saídas de dinheiro por data, seja dia,&amp;nbsp; mês,&amp;nbsp;ou ano. O valor presente líquido considera a essa série histórica a uma taxa de desconto e traz o valor&amp;nbsp; para hoje. Quanto valeria essas entradas e saídas financeiras&amp;nbsp;do&amp;nbsp;futuro ao valor de hoje, considerando uma taxa. &lt;br /&gt;
No caso, suponha que série tenha sido lançada nas colunas&amp;nbsp;A e&amp;nbsp;B de uma&amp;nbsp;planilha,&amp;nbsp; sendo que na coluna A foram colacas a ordem sequencial dos fatos, &amp;nbsp;e os valores relevantes para a fórmula&amp;nbsp;foram lançados nas&amp;nbsp;células &quot;B2:B26&quot;&lt;br /&gt;
A função é repreentada pela seguinte &amp;nbsp;&quot;=VPL(Taxa;série dos valores)&quot;.&lt;br /&gt;
No exemplo abaixo&amp;nbsp;a fórmula é &quot;=VPL(3%;B2:B26)&quot; e o resultado =1.849,19&amp;nbsp;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;﻿ &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyewwlDCItUGXWvsQY5QM6pWpvNRPFfX3kIE9BGIwtIcqkCfB99QiWUXvxbgP-N1YG2AdTtO0Gwt9KpR_WSs3FlsL7JPt4zOugXnxfnnq2Z4oS3lmw5ca5FX8r1_TURnxuc96ciYEP70/s1600/Figura+14+Fun%25C3%25A7%25C3%25A3o+VPL.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;225&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyewwlDCItUGXWvsQY5QM6pWpvNRPFfX3kIE9BGIwtIcqkCfB99QiWUXvxbgP-N1YG2AdTtO0Gwt9KpR_WSs3FlsL7JPt4zOugXnxfnnq2Z4oS3lmw5ca5FX8r1_TURnxuc96ciYEP70/s400/Figura+14+Fun%25C3%25A7%25C3%25A3o+VPL.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Dados e caixa da função VPL&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/5530927244981673765/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/calculo-do-valor-presente-liquido-no.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5530927244981673765'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5530927244981673765'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/calculo-do-valor-presente-liquido-no.html' title='Cálculo do Valor Presente líquido no Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyewwlDCItUGXWvsQY5QM6pWpvNRPFfX3kIE9BGIwtIcqkCfB99QiWUXvxbgP-N1YG2AdTtO0Gwt9KpR_WSs3FlsL7JPt4zOugXnxfnnq2Z4oS3lmw5ca5FX8r1_TURnxuc96ciYEP70/s72-c/Figura+14+Fun%25C3%25A7%25C3%25A3o+VPL.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-7770026067175462712</id><published>2011-01-23T05:16:00.000-08:00</published><updated>2011-01-23T13:44:23.637-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Caixa de diálogo Ir para"/><title type='text'>Caixa de diálogo Ir para</title><content type='html'>A Caixa de diálogo &quot;Ir para&quot; do Excel tem diversas finalidades, como veremos no exemplo abaixo.&lt;br /&gt;
&lt;br /&gt;
Selecione uma área da planilha que tenha conteúdo sobre as quais você deseja saber alguns informações e localizar determinadas categorias de dados e fórmulas. &lt;br /&gt;
&lt;br /&gt;
Passo 1: clique em F5, a caixa de diálogo abaixo irá aparecer. Esta caixa permite-lhe repetir ações já foram &amp;nbsp;realizadas na planilha e tem&amp;nbsp; outras habilidades, como veremos:&lt;br /&gt;
&lt;br /&gt;
﻿﻿﻿ &lt;br /&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB9mSNFH0Bf9GD4aRWaEak_YKGvlto8FoRO8WgOCjEl7p2NDEFE23rZEFJy90yyxhzH0FCUI728JuRJWxlgT7FYhwipUQMvj1e2VEZ232g683c2c3VnZzNpwT-XNzk61hnQUr6X9Ubx3s/s1600/Figura+11.1+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;370&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB9mSNFH0Bf9GD4aRWaEak_YKGvlto8FoRO8WgOCjEl7p2NDEFE23rZEFJy90yyxhzH0FCUI728JuRJWxlgT7FYhwipUQMvj1e2VEZ232g683c2c3VnZzNpwT-XNzk61hnQUr6X9Ubx3s/s400/Figura+11.1+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 1&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿﻿﻿ &lt;br /&gt;
&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;Passo 2: clique em especial,&amp;nbsp;aparecerá a caixa abaixo. &lt;/div&gt;﻿﻿﻿﻿ ﻿﻿﻿﻿﻿﻿﻿﻿ &lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyBXa5Qv-qcj4xkWzaToCJeis-r77j1NpyMkszqHXpNSMZX57qI0E6VaaIngIkEZGcJOJ1Gzg3SHrfU6jJF68SA9iPvQz_CJMZ6b6GvqhzaR4dUz1xbipwVZ2n9fYpc7NOKQ9iRstH83c/s1600/Figura+11.2+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;225&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyBXa5Qv-qcj4xkWzaToCJeis-r77j1NpyMkszqHXpNSMZX57qI0E6VaaIngIkEZGcJOJ1Gzg3SHrfU6jJF68SA9iPvQz_CJMZ6b6GvqhzaR4dUz1xbipwVZ2n9fYpc7NOKQ9iRstH83c/s400/Figura+11.2+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 2&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿﻿﻿﻿﻿﻿﻿﻿ Passo 3: selecione uma habilidade, por exemplo &quot;Fórmulas&quot; e dê o OK. O Excel ira selecionar todas as células onde houver a presença de fórmula.&lt;br /&gt;
&lt;br /&gt;
Outro exemplo:&amp;nbsp;observe que o segmento de planilha Excel abaixo tem duas células em branco, poderia ter centenas. Suponha que você queira colocar em toda célula branca, na coluna de marca, a frase &quot;Sem Marca&quot;, para fazer isso: (1) selecione a área de pesquisa; (2) clique em F5; &amp;nbsp;(3) clique em Especial (vide figura 1); &amp;nbsp;(4) selecione&amp;nbsp;a habilidade &amp;nbsp;&quot;em branco&quot; e elas serão selecionadas,&amp;nbsp;&amp;nbsp; (5) digite &quot;Sem Marca&quot; numa delas e&amp;nbsp; clique Ctrl+ Enter. Resultado: todas as células selecionas passarão a ter&amp;nbsp; &quot;Sem Marca&quot;.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEialYhj3wNscHZYfTQ5OlaCNDe8B0N7SL4hjMkl_YtfFajdn2k2gNpYINV32yXpThOZHg82vcQc6LkGyQxiQaxIESZ30_4_ObKKEqbqQwrtfO01pzEYEbaeEe5GoHYsnq4RZ3a09XSh2vI/s1600/Figura+11.3+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;130&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEialYhj3wNscHZYfTQ5OlaCNDe8B0N7SL4hjMkl_YtfFajdn2k2gNpYINV32yXpThOZHg82vcQc6LkGyQxiQaxIESZ30_4_ObKKEqbqQwrtfO01pzEYEbaeEe5GoHYsnq4RZ3a09XSh2vI/s400/Figura+11.3+Caixa+de+di%25C3%25A1logo+Ir+para.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/7770026067175462712/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/caixa-de-dialogo-ir-para.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7770026067175462712'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7770026067175462712'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/caixa-de-dialogo-ir-para.html' title='Caixa de diálogo Ir para'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB9mSNFH0Bf9GD4aRWaEak_YKGvlto8FoRO8WgOCjEl7p2NDEFE23rZEFJy90yyxhzH0FCUI728JuRJWxlgT7FYhwipUQMvj1e2VEZ232g683c2c3VnZzNpwT-XNzk61hnQUr6X9Ubx3s/s72-c/Figura+11.1+Caixa+de+di%25C3%25A1logo+Ir+para.jpg" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-5253766242461142023</id><published>2011-01-21T03:40:00.000-08:00</published><updated>2011-01-21T03:40:26.704-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Validação de dados"/><title type='text'>Validação de dados no Excel</title><content type='html'>﻿﻿﻿﻿ &lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: right; margin-left: 1em; text-align: right;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD_iXxgKHz3LMuyhTebBGGKKY5ljzIclOQSoq18wMSxiyWGDuPkPIdfMN_VydpAhDNtc9tzrtkZ_tcvjbTlr3igthzHu0BEbH7BuOoDzGLvk7gq7WfF7TZyq1VeipgEI7QkP7kj4gPUKc/s1600/Figura+10.1+Valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; cssfloat: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;198&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD_iXxgKHz3LMuyhTebBGGKKY5ljzIclOQSoq18wMSxiyWGDuPkPIdfMN_VydpAhDNtc9tzrtkZ_tcvjbTlr3igthzHu0BEbH7BuOoDzGLvk7gq7WfF7TZyq1VeipgEI7QkP7kj4gPUKc/s200/Figura+10.1+Valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; width=&quot;200&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 1&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿﻿﻿﻿ Você pode restringir os dados que serão &amp;nbsp;digitados numa célula, ou numa área qualquer. Quando a célula receber um dado, o Excel irá verificar se aquele dado passa pelo crivo da validação.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;&lt;strong&gt;Como estabelecer as referências para validação:&lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
1) Selecione as &quot;células&quot; que&amp;nbsp;sofrerão os efeitos&amp;nbsp;das restrições a serem definidas;&lt;br /&gt;
&lt;br /&gt;
2) Selecione &quot;Dados&quot;, aparecerá a caixa Figura 1, clique em &quot;Validação&quot;;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: right; margin-left: 1em; text-align: right;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwRvlBORmqenAL1bTbypCzpHMP6PTimC9k4fxEh_2DQ5m9029tmGbFEOrNtsoddHrzEdUXxDtQBnXslszvV-wGlwOtZ7ICadl3Y3M3R2dP9tJ5XHoN8EjsHE9MmYsFIyhtKJ_bTa32ww4/s1600/Figura+10.2+valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; cssfloat: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;163&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwRvlBORmqenAL1bTbypCzpHMP6PTimC9k4fxEh_2DQ5m9029tmGbFEOrNtsoddHrzEdUXxDtQBnXslszvV-wGlwOtZ7ICadl3Y3M3R2dP9tJ5XHoN8EjsHE9MmYsFIyhtKJ_bTa32ww4/s200/Figura+10.2+valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; width=&quot;200&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 2&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
3) Aparecerá a caixa da figura 2, você, então, configura a validação. No exemplo, restringimos as células para aceitarem datas no intervalo entre 21/01/2011 e 01/02/2011;&lt;br /&gt;
&lt;br /&gt;
4) Após definir as restrições, você pode também adicionar mensagens personalizadas etc, (estude está caixa de diálogo da figura 2 e faça exercícios);&lt;br /&gt;
﻿﻿ &lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;﻿ &lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;clear: right; cssfloat: right; float: right; margin-bottom: 1em; text-align: right;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggLEmYos2OsRcOCI4vSfVFVOJZ0xKiV2v9l03wru8AHjLNrYESjIRRbkcGm_uxzOAK2TZL4oZAmwW8_5qpYyF8FhwYtDmOPaUy8_W8Pf1A_TnugGWXLndDNSkkLR2ga6P_s9T57ijVlXA/s1600/Figura+10.3+valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; cssfloat: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;112&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggLEmYos2OsRcOCI4vSfVFVOJZ0xKiV2v9l03wru8AHjLNrYESjIRRbkcGm_uxzOAK2TZL4oZAmwW8_5qpYyF8FhwYtDmOPaUy8_W8Pf1A_TnugGWXLndDNSkkLR2ga6P_s9T57ijVlXA/s200/Figura+10.3+valida%25C3%25A7%25C3%25A3o+de+dados.jpg&quot; width=&quot;200&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 3&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿ &lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;5) Quando houver uma entrada de dados nas células com restrições, aparecerá esta mensagem (figura 3), ou outra definida por você na caixa de diálogo da figura 2.&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;﻿ ﻿&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/5253766242461142023/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/validacao-de-dados-no-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5253766242461142023'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5253766242461142023'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/validacao-de-dados-no-excel.html' title='Validação de dados no Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD_iXxgKHz3LMuyhTebBGGKKY5ljzIclOQSoq18wMSxiyWGDuPkPIdfMN_VydpAhDNtc9tzrtkZ_tcvjbTlr3igthzHu0BEbH7BuOoDzGLvk7gq7WfF7TZyq1VeipgEI7QkP7kj4gPUKc/s72-c/Figura+10.1+Valida%25C3%25A7%25C3%25A3o+de+dados.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-4169281807769789394</id><published>2011-01-21T02:48:00.000-08:00</published><updated>2011-01-21T02:52:22.115-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dicas do excel"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel formatação de células"/><title type='text'>Excel formatação de células</title><content type='html'>Formatação das células em Excel&lt;br /&gt;
&lt;br /&gt;
1) Selecione&amp;nbsp;a célula ou o conjunto de células a serem formatadas;&lt;br /&gt;
2) Clique do lado direito do mouse, aparece a caixa de diálogo abaixo;&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFNhqmg6OB7P-_Wlhv_wYtim4hI3yt7G8apSYlNuQ4XwOhp2OlOkETQ5Az6cOQDu8LFCXh46D-7yeHM-edS1x02GENgOMhe4GbGWwZuaDtsIqlAL9IAmb2ViV2vVgrO9e6KokM0koknf8/s1600/Formata%25C3%25A7%25C3%25A3o+10.1.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;320&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFNhqmg6OB7P-_Wlhv_wYtim4hI3yt7G8apSYlNuQ4XwOhp2OlOkETQ5Az6cOQDu8LFCXh46D-7yeHM-edS1x02GENgOMhe4GbGWwZuaDtsIqlAL9IAmb2ViV2vVgrO9e6KokM0koknf8/s320/Formata%25C3%25A7%25C3%25A3o+10.1.jpg&quot; width=&quot;233&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;3) Clique em Formatar células﻿, surge a caixa de diálogo abaixo:&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr3A5DPg8mboAHpmX8kIDW4_JMPDR0BaGkUTFgstNfI6OADmw9BrjOoDxk-Y9TemO-O4yT026CNo3f49qTwHwmO50xH2tHz7sEjQMV5qjzdsdYEKNjI74PKbW7CMzUbZPIqC-kSHk0zzE/s1600/Formata%25C3%25A7%25C3%25A3o+10.2+caixa+de+di%25C3%25A1logo.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;303&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr3A5DPg8mboAHpmX8kIDW4_JMPDR0BaGkUTFgstNfI6OADmw9BrjOoDxk-Y9TemO-O4yT026CNo3f49qTwHwmO50xH2tHz7sEjQMV5qjzdsdYEKNjI74PKbW7CMzUbZPIqC-kSHk0zzE/s320/Formata%25C3%25A7%25C3%25A3o+10.2+caixa+de+di%25C3%25A1logo.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;4) Escolha a categoria de formatação e o tipo desejados, fique de olho na janela do&amp;nbsp;exemplo que dá a dica de como ficará sua formatção. Quando não encontrar a categoria desejada, use a categoria Personalizada, ao dar o OK, a célula selecionada receberá o formato.﻿&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/4169281807769789394/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-formatacao-de-celulas.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/4169281807769789394'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/4169281807769789394'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-formatacao-de-celulas.html' title='Excel formatação de células'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFNhqmg6OB7P-_Wlhv_wYtim4hI3yt7G8apSYlNuQ4XwOhp2OlOkETQ5Az6cOQDu8LFCXh46D-7yeHM-edS1x02GENgOMhe4GbGWwZuaDtsIqlAL9IAmb2ViV2vVgrO9e6KokM0koknf8/s72-c/Formata%25C3%25A7%25C3%25A3o+10.1.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-984761135215302865</id><published>2011-01-21T02:31:00.000-08:00</published><updated>2011-01-21T02:31:59.215-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Excel contagem dos itens"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel média"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel soma"/><title type='text'>Excel soma, média e número de itens sem contas</title><content type='html'>Você não precisa inserir nenhuma fórmula ou&amp;nbsp; função par obter uma soma rápida no Excel 2000 e 2003, no Excel 2007. além da soma rápida você também obtem a média e a contagem dos itens.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1SRpDZ84Nl6AJ1pqBV9jhI7cfp5N_0hu5X8bqBZUYtopR1YSaUt7l3mPQ1qi7mJgR5QHCwEfcQcFtwSEU3EJC7Kre_bMIH6XdIP4r4irFTSIEHjrwip5_WkNVwR81kISTnlw0KR3tzwM/s1600/Figura+9+Soma+na+barra+de+status.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;382&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1SRpDZ84Nl6AJ1pqBV9jhI7cfp5N_0hu5X8bqBZUYtopR1YSaUt7l3mPQ1qi7mJgR5QHCwEfcQcFtwSEU3EJC7Kre_bMIH6XdIP4r4irFTSIEHjrwip5_WkNVwR81kISTnlw0KR3tzwM/s400/Figura+9+Soma+na+barra+de+status.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;Para isso basta selecionar as células para as quais você quer essas operações e olhar na barra de Status, lá estarão os resultados. Vide figura acima&amp;nbsp;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/984761135215302865/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-soma-media-e-numero-de-itens-sem.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/984761135215302865'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/984761135215302865'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-soma-media-e-numero-de-itens-sem.html' title='Excel soma, média e número de itens sem contas'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1SRpDZ84Nl6AJ1pqBV9jhI7cfp5N_0hu5X8bqBZUYtopR1YSaUt7l3mPQ1qi7mJgR5QHCwEfcQcFtwSEU3EJC7Kre_bMIH6XdIP4r4irFTSIEHjrwip5_WkNVwR81kISTnlw0KR3tzwM/s72-c/Figura+9+Soma+na+barra+de+status.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-8447051111164776941</id><published>2011-01-19T02:48:00.000-08:00</published><updated>2011-01-21T03:59:00.832-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Potência no Excel"/><category scheme="http://www.blogger.com/atom/ns#" term="Raiz enésima"/><category scheme="http://www.blogger.com/atom/ns#" term="Raiz Quadrada"/><title type='text'>Funções do Excel: potência,  raiz quadrada e a raiz enésima</title><content type='html'>:&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;A potência é uma função já disponibilizada pelo Excel que tem a seguinte notação: &lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;=POTÊNCIA(Base;Expoente)&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;No exemplo seguinte, se &quot;B19 = 3&quot; e &quot;B20 = 2&quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;então&amp;nbsp; &quot;=POTÊNCIA(B19;B20)&quot; &amp;nbsp;resultado = 9&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;Uma fórmula correspondente que você mesmo pode inserir é: &quot;=B19^B20&amp;nbsp;&quot; ou seja o símbolo &quot;^ &quot; entre dois números ou funções eleva o número&amp;nbsp;da esquerda segundo o expoente que fica à direita.&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;Então a fórmula &quot;=2^3&quot;&amp;nbsp;resultado =&amp;nbsp;8&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;Nós sabemos que todo número elevado a zero = 1, então, a fórmula &#39;= 60 ^ 0&#39;&amp;nbsp;&amp;nbsp;resultado = 1 e a fórmula &quot;= X ^0&quot;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&lt;/span&gt;resultado =1&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;A raiz quadrada tem a seguinte notação: &quot;=Raiz(Número)&quot;, onde número é o valor para o qual queremos extrair a raiz quadrada.&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;Exemplo: &quot;=Raiz(9)&quot; resultado = 3&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;A dedução a seguir é importante para o entendimento da raiz enésima:&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Arial&amp;quot;, &amp;quot;sans-serif&amp;quot;;&quot;&gt;A raiz quadrada de&amp;nbsp;&amp;nbsp;x = x ^ &lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;MS Reference 2&amp;quot;; font-size: 10pt;&quot;&gt;1&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Arial&amp;quot;, &amp;quot;sans-serif&amp;quot;; font-size: 10pt;&quot;&gt; (em palavras: a raiz quadrada de&amp;nbsp;X é igual a&amp;nbsp;X elevado à potência de meio).&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Arial&amp;quot;, &amp;quot;sans-serif&amp;quot;; font-size: 10pt;&quot;&gt;A raiz cúbica de&amp;nbsp;X,&amp;nbsp;então, &amp;nbsp;é&amp;nbsp;&amp;nbsp;X ^ &lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;MS Reference 2&amp;quot;;&quot;&gt;2 &lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Arial&amp;quot;, &amp;quot;sans-serif&amp;quot;; font-size: 10pt;&quot;&gt;(em palavras: a raiz cúbica de&amp;nbsp;X é igual a&amp;nbsp;X elevado à potência de um terço).&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Arial&amp;quot;, &amp;quot;sans-serif&amp;quot;;&quot;&gt;Generalizando: a raiz n de um X é igual a X^(1/n)&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;No Excel você pode também extrair &lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&lt;/span&gt;a raiz cúbica, e a raiz enésima. &lt;br /&gt;
A fórmula para raiz enésima é a seguinte &quot;= Número ^(1/enésima)&quot;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0cm 0cm 0pt;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;, &amp;quot;serif&amp;quot;; font-size: 12pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: PT-BR;&quot;&gt;Abra uma planilha do seu Excel e tente os exemplos abaixo, depois, exercite criando suas próprias fórmulas:&lt;/span&gt;&lt;/div&gt;﻿ &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJCX2hyphenhyphen6UAhIeIyDgCy9R8R8LZotHjiDnkUDR5qTCLt4GfQ99p1Wq6iuhojIVWSNam_qem1cQx7lUqCkd_heyNcs4eaAh24dzJiMKmGWQg-MsQf0Lpng9cRaA7YjR86xwQs-t4Z6V6t8M/s1600/Figura+8+Raizes+e+potencia.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;135&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJCX2hyphenhyphen6UAhIeIyDgCy9R8R8LZotHjiDnkUDR5qTCLt4GfQ99p1Wq6iuhojIVWSNam_qem1cQx7lUqCkd_heyNcs4eaAh24dzJiMKmGWQg-MsQf0Lpng9cRaA7YjR86xwQs-t4Z6V6t8M/s400/Figura+8+Raizes+e+potencia.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Clique na figura acima para ampliá-la&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;﻿ &lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;﻿ &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;﻿</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/8447051111164776941/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/funcoes-do-excel-potencia-raiz-quadrada.html#comment-form' title='3 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/8447051111164776941'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/8447051111164776941'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/funcoes-do-excel-potencia-raiz-quadrada.html' title='Funções do Excel: potência,  raiz quadrada e a raiz enésima'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJCX2hyphenhyphen6UAhIeIyDgCy9R8R8LZotHjiDnkUDR5qTCLt4GfQ99p1Wq6iuhojIVWSNam_qem1cQx7lUqCkd_heyNcs4eaAh24dzJiMKmGWQg-MsQf0Lpng9cRaA7YjR86xwQs-t4Z6V6t8M/s72-c/Figura+8+Raizes+e+potencia.jpg" height="72" width="72"/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-4343779166124673448</id><published>2011-01-18T15:00:00.000-08:00</published><updated>2011-01-19T02:48:11.397-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Função soma"/><category scheme="http://www.blogger.com/atom/ns#" term="somatório"/><title type='text'>A função   SOMA ou SOMATÓRIO</title><content type='html'>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm36o6VFJx0rzcGiwEFMxoL9Wz9aiiexyNk8SvC1R3trKNmYEPqKCmyqU3bHHrDHBR8iqd5m7OZv-ZB9Ui8XEV_JC5ODYz6ML-OMXnSEOS0372SeJH5CmylGtzJXBbEos1o8HTk0u6KqA/s1600/Figura+do+somat%25C3%25B3rio.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;200&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm36o6VFJx0rzcGiwEFMxoL9Wz9aiiexyNk8SvC1R3trKNmYEPqKCmyqU3bHHrDHBR8iqd5m7OZv-ZB9Ui8XEV_JC5ODYz6ML-OMXnSEOS0372SeJH5CmylGtzJXBbEos1o8HTk0u6KqA/s200/Figura+do+somat%25C3%25B3rio.jpg&quot; width=&quot;167&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;strong&gt;&lt;u&gt;Função soma do Excel&lt;/u&gt;&lt;/strong&gt;&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;Tem a seguinte notação: =SOMA(n1,n2;n3...n30)&lt;br /&gt;
Note que não pode haver mais que trinta argumentos, mas cada argumento pode incluir várias células ou até somas ou outras funções.&lt;br /&gt;
Isso é uma importante característica do Excel em geral, pois permite a montagem de fórmulas que podem ter diversas funções (um verdadeiro ninho de fórmulas).&lt;br /&gt;
A função soma é tão usada para adições de colunas ou linhas inteiras que lhe é reservada destaque na barra de ferramentas e é arrolada entre as funções que fazem parte do &quot;Padrão&quot;. Aparece na barra padrão com o símbolo de somatório. Ao clicar no ícone (vide&amp;nbsp;acima) &amp;nbsp;o Excel assume a &lt;span style=&quot;font-family: &amp;quot;Calibri&amp;quot;, &amp;quot;sans-serif&amp;quot;;&quot;&gt;Adjacência &lt;/span&gt;para montar automaticamente o somatório. Exemplo: Na planilha abaixo clicando no símbolo do somatório para preenhcer a célula A7, o Excel assumiu&amp;nbsp;a adjacência e montou a fórmula e a inseriu na célula ativa, ou seja, onde estava o cursor, no exemplo seguinte note que a célula não preenchida em B2 interrompe a contiguidade e faz com&amp;nbsp; que a adjacência seja B3:B6&lt;br /&gt;
Teste essa característica da SOMA e você notará que ela funciona nos 4 sentidos de um planilha, para o que estiver acima, abaixo, do lado direito e do lado esquerdo da célula ativa, onde você vai inserir a função.&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin: 0cm 0cm 10pt;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHQ7496tlD3Tv0P1SAEF0ibvkZnYXIneJOMC66ptF0eC-plyvYCfKX3AC3OaO9qFePyqryL7Wu1a-VbDIcfe_UToJ4OSTFokSW_-jwQ1M0uriFUrHuBiJGn6n5TwLAWM2YjE2-jZ9aE9s/s1600/Figura+7+a+soma+assume+a+adjasc%25C3%25AAncia.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;287&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHQ7496tlD3Tv0P1SAEF0ibvkZnYXIneJOMC66ptF0eC-plyvYCfKX3AC3OaO9qFePyqryL7Wu1a-VbDIcfe_UToJ4OSTFokSW_-jwQ1M0uriFUrHuBiJGn6n5TwLAWM2YjE2-jZ9aE9s/s400/Figura+7+a+soma+assume+a+adjasc%25C3%25AAncia.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 7 - montagem automática da&amp;nbsp; função soma&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/4343779166124673448/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/funcoes-do-excel-mais-usadas-soma.html#comment-form' title='4 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/4343779166124673448'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/4343779166124673448'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/funcoes-do-excel-mais-usadas-soma.html' title='A função   SOMA ou SOMATÓRIO'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm36o6VFJx0rzcGiwEFMxoL9Wz9aiiexyNk8SvC1R3trKNmYEPqKCmyqU3bHHrDHBR8iqd5m7OZv-ZB9Ui8XEV_JC5ODYz6ML-OMXnSEOS0372SeJH5CmylGtzJXBbEos1o8HTk0u6KqA/s72-c/Figura+do+somat%25C3%25B3rio.jpg" height="72" width="72"/><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-6549356859802124818</id><published>2011-01-18T02:21:00.000-08:00</published><updated>2011-01-18T02:21:27.716-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Excel divisão"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel multiplicação"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel soma"/><category scheme="http://www.blogger.com/atom/ns#" term="Excel subtração"/><title type='text'>As quatro operações em Excel</title><content type='html'>Toda fórmula em Excel é iniciada pelo sinal &amp;nbsp;&quot;=&quot;,&amp;nbsp; na matématica 2=1+1 em Excel&amp;nbsp;&amp;nbsp;&amp;nbsp; =1+1 resultado 2&lt;br /&gt;
Os sinais usados nas quatro operações são:&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;Adição &quot;+&quot;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;Subtração &quot;-&quot;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;Multiplicação &quot;*&quot;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;Divisão &quot;/&quot;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Assim, se&amp;nbsp;houver na célula C1 o valor 100, e na célua C2 o valor 50&lt;br /&gt;
Poderíamos ter as seguintes operações em qualquer outra célula da planilha&lt;br /&gt;
Adição&amp;nbsp; &quot;=C1+ C2&quot; o resultado será 150&lt;br /&gt;
Subração &quot;=C1&amp;nbsp;- C2&quot; o resultado será 100&quot;&lt;br /&gt;
Multiplicação &quot;=C1&amp;nbsp;* C6&quot; o resultado será 100&quot; o resultado será 5000&lt;br /&gt;
Divisão&amp;nbsp;&amp;nbsp; &quot;=C1/ C2&quot; o resultado será 100&quot; o resultado será 2&lt;br /&gt;
No segmento de uma planilha Excel, lançou-se abaixo esses exemplos.&lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh19E8mGW3ZnlHcwli1JDBOPdyhTAYPyuf4yxZgROr-QOX4Gz8M1wHjkXihGRncmtOeEtl5PyUQbmzRSDCtGCxIzRwGnBMHjS1WHcqaJD52a6r3Kiov82Io9SCRv9uiAMZj4MyEbXXlXIg/s1600/Figura+2+as+quatro+opera%25C3%25A7%25C3%25B5es.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;141&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh19E8mGW3ZnlHcwli1JDBOPdyhTAYPyuf4yxZgROr-QOX4Gz8M1wHjkXihGRncmtOeEtl5PyUQbmzRSDCtGCxIzRwGnBMHjS1WHcqaJD52a6r3Kiov82Io9SCRv9uiAMZj4MyEbXXlXIg/s400/Figura+2+as+quatro+opera%25C3%25A7%25C3%25B5es.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Exemplo das quatro operações - clique para ampliar a figura&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/6549356859802124818/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/as-quatro-operacoes-em-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/6549356859802124818'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/6549356859802124818'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/as-quatro-operacoes-em-excel.html' title='As quatro operações em Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh19E8mGW3ZnlHcwli1JDBOPdyhTAYPyuf4yxZgROr-QOX4Gz8M1wHjkXihGRncmtOeEtl5PyUQbmzRSDCtGCxIzRwGnBMHjS1WHcqaJD52a6r3Kiov82Io9SCRv9uiAMZj4MyEbXXlXIg/s72-c/Figura+2+as+quatro+opera%25C3%25A7%25C3%25B5es.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-7516528664299685859</id><published>2011-01-17T17:05:00.000-08:00</published><updated>2011-01-17T17:05:59.364-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dicas do excel"/><category scheme="http://www.blogger.com/atom/ns#" term="funções localização e uso"/><title type='text'>Como localizar e usar uma função no Excel</title><content type='html'>Para localizar uma função é preciso inicialmnete ir na barra do Excel e localizar o ìcone fx, ou seja, funções disponíveis para serem coladas em qq célula.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5cDFbDM1gRUuAmkt05YNxYycjBsixyaKk9J-cdMim6gyb5M8gUKQaWs2w9ZkUyLnkVNrQZtgRY017QFfczz3jGrgrgCWB2tMQOEle1yg9qSbnlbldj6aqAs2or44F6iXWtyWJqpg8Nxg/s1600/Fun%25C3%25A7%25C3%25A3o+1.1+colar.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;81&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5cDFbDM1gRUuAmkt05YNxYycjBsixyaKk9J-cdMim6gyb5M8gUKQaWs2w9ZkUyLnkVNrQZtgRY017QFfczz3jGrgrgCWB2tMQOEle1yg9qSbnlbldj6aqAs2or44F6iXWtyWJqpg8Nxg/s320/Fun%25C3%25A7%25C3%25A3o+1.1+colar.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
A célula em que você posicionar o cursor será a que irá receber a função.﻿﻿ &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;﻿﻿Ao clicar no comando, ou ícone fx o Excel abrirá um caixa de diálogo com o título &lt;strong&gt;Colar função﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿, &lt;/strong&gt;essa caixa lhe permite buscar uma funçao por categória. Escolhida a categoria, então você poderá selecionar a função desejada. &lt;br /&gt;
&lt;div style=&quot;text-align: right;&quot;&gt;&lt;/div&gt;﻿﻿ &lt;br /&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCGcHqVmUFYYglhyozwSwBhSAHj8ZRVG3QPmeFhEGpZZ6Veq2kWU8M4KvmT-Erto-I-ncakPsUgvgNDW9NwzBeT6j6PkbRUAmI6tY7Lfi7x-GmVY_cJhF3xg4qY5A8AQBkuAk4z1N6ZS4/s1600/Fun%25C3%25A7%25C3%25A3o+1.2+Caixa+de+sele%25C3%25A7%25C3%25A3o+da+fun%25C3%25A7%25C3%25A3o+desejada.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;219&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCGcHqVmUFYYglhyozwSwBhSAHj8ZRVG3QPmeFhEGpZZ6Veq2kWU8M4KvmT-Erto-I-ncakPsUgvgNDW9NwzBeT6j6PkbRUAmI6tY7Lfi7x-GmVY_cJhF3xg4qY5A8AQBkuAk4z1N6ZS4/s320/Fun%25C3%25A7%25C3%25A3o+1.2+Caixa+de+sele%25C3%25A7%25C3%25A3o+da+fun%25C3%25A7%25C3%25A3o+desejada.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 1.2 Caixa de diálogo para escolher a função&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
﻿﻿ &lt;br /&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;&lt;/div&gt;Vamos a um exemplo de escolha de função nesta rápida animação.﻿﻿ &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;br /&gt;
&lt;iframe allowfullscreen=&#39;allowfullscreen&#39; webkitallowfullscreen=&#39;webkitallowfullscreen&#39; mozallowfullscreen=&#39;mozallowfullscreen&#39; width=&#39;320&#39; height=&#39;266&#39; src=&#39;https://www.blogger.com/video.g?token=AD6v5dz7az1T7lS3JE9zcboHMf9zzY_ZHvqT52FGolEho416Az0uPLV9retM9474UCEJ9EERhrdbpBeaY5TSua_GYA&#39; class=&#39;b-hbp-video b-uploaded&#39; frameborder=&#39;0&#39;&gt;&lt;/iframe&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/7516528664299685859/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/como-localizar-e-usar-uma-funcao-no.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7516528664299685859'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/7516528664299685859'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/como-localizar-e-usar-uma-funcao-no.html' title='Como localizar e usar uma função no Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5cDFbDM1gRUuAmkt05YNxYycjBsixyaKk9J-cdMim6gyb5M8gUKQaWs2w9ZkUyLnkVNrQZtgRY017QFfczz3jGrgrgCWB2tMQOEle1yg9qSbnlbldj6aqAs2or44F6iXWtyWJqpg8Nxg/s72-c/Fun%25C3%25A7%25C3%25A3o+1.1+colar.jpg" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-3016820572287776449</id><published>2011-01-17T09:47:00.000-08:00</published><updated>2011-01-17T15:31:28.129-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Células"/><category scheme="http://www.blogger.com/atom/ns#" term="Dicas do excel"/><title type='text'>Excel para principiantes - Células e utilização</title><content type='html'>Na grande maioria do uso do Excel, as células irão conter dados ou fórmulas. &lt;br /&gt;
Os dados mais usados são&amp;nbsp;os números e&amp;nbsp;alfanuméricos.&lt;br /&gt;
As fórmulas são as que o usuário inserir na célula ou as que o Excel já disponibiliza como&amp;nbsp; função.&lt;br /&gt;
Exemplos:&lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2KqUevf-GrUxJlPG966yHGt0OdnZzsZH4iZYt9gorEo2Gk4X-1ByeFmjLzNVXMjwbGGevakZ4y1Yp6hBuezWuKfzaSVX_6H7H_90ETvv3xLh7_hNVy9OOCUSe4zH8Q1pWsRGEBgW5Yrg/s1600/Figura+5+C%25C3%25A9lulas.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;125&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2KqUevf-GrUxJlPG966yHGt0OdnZzsZH4iZYt9gorEo2Gk4X-1ByeFmjLzNVXMjwbGGevakZ4y1Yp6hBuezWuKfzaSVX_6H7H_90ETvv3xLh7_hNVy9OOCUSe4zH8Q1pWsRGEBgW5Yrg/s320/Figura+5+C%25C3%25A9lulas.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 5&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;Observe que na Figura 5 apresenamos um&amp;nbsp; um exemplo simples, que mostra como podemos usar as células e fazer cálculos fazendo referência as seus endereços, ou seja, ao número da coluna e da linha. Na célua B3 inserimos uma multiplicação, na C3 uma divisão e na célula B4 a função soma. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: red;&quot;&gt;CLIQUE NAS FIGURAS PARA AMPLIÁ-LAS&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh58Yn3pTDgnm9oYuZu0TqKQkjuD4sQJveqzFYCs0KwSUqJU9ibGdl0kfTICXkhhy8_GfAwYQ9k96YL_AgbtovEFjzIKBBel7jtCf0FgYsxCYzrgmVK4IkYe7-KXFBpcX_qfDTwF7dIK1k/s1600/Figura+6+C%25C3%25A9lulas.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;132&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh58Yn3pTDgnm9oYuZu0TqKQkjuD4sQJveqzFYCs0KwSUqJU9ibGdl0kfTICXkhhy8_GfAwYQ9k96YL_AgbtovEFjzIKBBel7jtCf0FgYsxCYzrgmVK4IkYe7-KXFBpcX_qfDTwF7dIK1k/s320/Figura+6+C%25C3%25A9lulas.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figura 6&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;As&amp;nbsp;notações acima das fórmulas e das função soma daria o resultado da figura aí do lado.&lt;br /&gt;
Sugestão para os principantes: abra um planilha Excel, repita entre com estas fórmulas e com a função Soma verifique os resultados. Depois faça o mesmo, usando outras fórmulas e funções.&lt;br /&gt;
Um relevante dificuldade que tem o princiante é a de localizar a fórmula de que precisa, para tirar sua dúvida veja o link tal</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/3016820572287776449/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-para-principiantes-celulas-e.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/3016820572287776449'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/3016820572287776449'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/excel-para-principiantes-celulas-e.html' title='Excel para principiantes - Células e utilização'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2KqUevf-GrUxJlPG966yHGt0OdnZzsZH4iZYt9gorEo2Gk4X-1ByeFmjLzNVXMjwbGGevakZ4y1Yp6hBuezWuKfzaSVX_6H7H_90ETvv3xLh7_hNVy9OOCUSe4zH8Q1pWsRGEBgW5Yrg/s72-c/Figura+5+C%25C3%25A9lulas.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2392820458712511103.post-5867830816330226588</id><published>2011-01-16T16:57:00.000-08:00</published><updated>2011-01-16T16:57:02.460-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Planilha de Excel"/><title type='text'>O que é um a planilha Excel</title><content type='html'>Uma matriz de duas dimensões que contém 65536 linhas e 256 colunas que podem ser utilizadas para armazenar dados e outros tipos de informações e que podem ser endereçadas de forma a permitir cruzamento de dados dos mais simples até os mais complexos.</content><link rel='replies' type='application/atom+xml' href='http://exceldicasgerais.blogspot.com/feeds/5867830816330226588/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/o-que-e-um-planilha-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5867830816330226588'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2392820458712511103/posts/default/5867830816330226588'/><link rel='alternate' type='text/html' href='http://exceldicasgerais.blogspot.com/2011/01/o-que-e-um-planilha-excel.html' title='O que é um a planilha Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>