{"id":21964,"date":"2024-12-08T10:26:14","date_gmt":"2024-12-08T10:26:14","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/?p=21964"},"modified":"2025-01-19T13:19:05","modified_gmt":"2025-01-19T13:19:05","slug":"how-to-create-a-quiz-in-excel-the-ultimate-guide-7","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/","title":{"rendered":"Como criar um question\u00e1rio no Excel &#8211; O guia definitivo para 2025"},"content":{"rendered":"<p>Cada universidade, escola e empresa usa diferentes tipos de question\u00e1rio para testar seus alunos ou funcion\u00e1rios. Um quiz \u00e9 usado para testar o conhecimento do funcion\u00e1rio sobre seu trabalho e para que os alunos saibam se entenderam a li\u00e7\u00e3o.<\/p>\n<p>Portanto, criar question\u00e1rios \u00e9 essencial e h\u00e1 v\u00e1rias maneiras de criar um question\u00e1rio. Voc\u00ea poderia gerar question\u00e1rios em papel, que \u00e9 o m\u00e9todo antigo, um documento Word, que agora est\u00e1 digitalizado, mas quase igual ao papel ou Excel. Sim, voc\u00ea pode usar o Excel para criar question\u00e1rios gra\u00e7as \u00e0s suas ferramentas vers\u00e1teis, e esta tamb\u00e9m tem sido a forma mais comum e popular de fazer um!<\/p>\n<div class=\"article_toc\">Table of Contents<\/div>\n<ul class=\"article_index\">\n<li><a href=\"#a1\">Excel Can Be Used to Create A Quiz<\/a><\/li>\n<li><a href=\"#a2\">OnlineExamMaker: An Easier Way to Create Online Quiz Using AI<\/a><\/li>\n<li><a href=\"#a3\">Step-by-step Guide to Create A Quiz Using Excel<\/a><\/li>\n<\/ul>\n<h2 id=\"a1\">Excel Can Be Used to Create A Quiz<\/h2>\n<p>Como afirmado, o Excel tem muitos usos vers\u00e1teis que voc\u00ea pode usar em qualquer \u00e1rea. A forma mais comum de usar o Excel \u00e9 na contabilidade. Gra\u00e7as aos seus c\u00f3digos integrados, voc\u00ea pode acompanhar os registros e calcul\u00e1-los automaticamente.<\/p>\n<p>Voc\u00ea tamb\u00e9m pode usar o Excel no gerenciamento e an\u00e1lise de dados. O Excel pode armazenar grandes quantidades de dados e, por causa das planilhas, tamb\u00e9m pode categorizar os dados corretamente. Tamb\u00e9m com o c\u00f3digo, o Excel analisa automaticamente os dados fornecidos.<\/p>\n<p>Ent\u00e3o, como o Excel pode ser usado na cria\u00e7\u00e3o de question\u00e1rios? Por causa do recurso de codifica\u00e7\u00e3o do Excel, voc\u00ea pode criar question\u00e1rios facilmente e calcular automaticamente as pontua\u00e7\u00f5es totais, mesmo com muitas perguntas. O vasto armazenamento do Excel tamb\u00e9m ajuda voc\u00ea a criar o maior n\u00famero poss\u00edvel de perguntas. Voc\u00ea pode at\u00e9 <strong>categorizar seus testes<\/strong> usando planilhas diferentes ou simplesmente colocando todos os exames em planilhas separadas. Devido a esses recursos, torna-se mais f\u00e1cil e conveniente para os professores, pois eles podem registrar facilmente grandes quantidades de pontua\u00e7\u00f5es instantaneamente.<\/p>\n<h2 id=\"a2\">OnlineExamMaker: An Easier Way to Create Online Quiz Using AI<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/06\/onlineexammaker-testmaker-june.webp\" alt=\"\"  \/><\/p>\n<p>Creating quizzes has never been easier now, thanks to advances in technology. You can easily create a quiz and automatically get the result fast, and it comes with a detailed report. And because of the past year, schools and universities need to conduct exams online, and they can do this with the help of online exam software.<\/p>\n<p>One particular in mind is the best software called OnlineExamMaker software. This software advances exam creation by making it more secure thanks to its anti-cheating system, making quizzes more interactive and fun using different media and comprehensive questions, and its automated reports system reports detailed and analyzed results.<\/p>\n<p><strong>Create a responsive quiz using AI<\/strong><br \/>\nBy using OnlineExamMaker AI Question Generator, creating quizzes has never been easier. You can easily <a href=\"https:\/\/onlineexammaker.com\/help\/question-bank-management\/ai-question-generator\/\">generate professional questions by keywords or texts<\/a> in seconds. More over, their <a href=\"https:\/\/onlineexammaker.com\/features\/ai-exam-grader.html\">AI Exam Grader<\/a> can calculate the quiz score automatically once the student submit the exam. <\/p>\n<p>In the software dashboard, you click exam list, press new exam, and then quickly create one. Their user-friendly interface also makes it easy to create a test templates, and the option for different questions, as well as handy in <strong>making comprehensive exams<\/strong>.<\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/bv7AAAyFOo4\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Crie seu pr\u00f3ximo question\u00e1rio\/exame com OnlineExamMaker<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Comece gratuitamente<\/a><\/div>\n<div class=\"p-style-b\">SAAS, gr\u00e1tis para sempre<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/lan.html?refer=blog_btn\">No local: baixar<\/a><\/div>\n<div class=\"p-style-b\">100% de propriedade de dados<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>\nOs relat\u00f3rios automatizados, conforme declarado, tamb\u00e9m s\u00e3o um dos melhores neste <a href=\"https:\/\/pt.onlineexammaker.com\/solutions\/online-test-generator.html\">software gerador de testes online<\/a>; voc\u00ea pode obter informa\u00e7\u00f5es detalhadas sobre o desempenho do aluno em uma quest\u00e3o espec\u00edfica e os resultados gerais da aula. O <strong>relat\u00f3rio automatizado<\/strong> tamb\u00e9m inclui relat\u00f3rios analisados e estat\u00edsticos para mostrar com precis\u00e3o o que precisa ser melhorado.<\/p>\n<p>Um recurso \u00fatil \u00e9 que voc\u00ea tamb\u00e9m pode monetizar seu question\u00e1rio para outros professores e para a universidade. \u00c9 uma excelente maneira de obter renda adicional enquanto faz seu pr\u00f3prio teste. No geral, este pr\u00e1tico software de exame online facilita sua vida com seus muitos recursos e ferramentas para ajud\u00e1-lo a criar question\u00e1rios para seus alunos.<\/p>\n<h2 id=\"a3\">Step-by-step Guide to Create A Quiz Using Excel<\/h2>\n<p>Voc\u00ea pode usar qualquer Excel para fazer um teste. Pode ser o Word Excel, um Excel online ou qualquer outro aplicativo que possa abrir e usar o Excel. Abaixo est\u00e1 o m\u00e9todo mais f\u00e1cil para criar um question\u00e1rio<\/p>\n<h3>Etapa 1: Configurando a Planilha<\/h3>\n<p>Na primeira parte, crie duas planilhas pressionando o sinal de mais ao lado da planilha1, que fica na parte inferior. Nomeie folha1 e folha2 em Teste e Nota, respectivamente.<\/p>\n<p>Clique no sinal de mais para criar outra planilha:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-1.png\" alt=\"\" width=\"624\" height=\"564 \" class=\"alignnone size-full wp-image-8749\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-1.png 624w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-1-300x271.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>Clique com o bot\u00e3o direito na planilha1 e clique em renomear para mudar para teste e o mesmo procedimento da planilha2:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-2.png\" alt=\"\" width=\"624\" height=\"536 \" class=\"alignnone size-full wp-image-8750\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-2.png 624w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-2-300x258.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-3.png\" alt=\"\" width=\"624\" height=\"540 \" class=\"alignnone size-full wp-image-8751\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-3.png 624w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-3-300x260.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3>Etapa 2: Formule sua pergunta<\/h3>\n<p>Na planilha de teste, coloque sua pergunta em qualquer linha e coluna. Voc\u00ea pode deixar uma c\u00e9lula em branco para que os participantes insiram suas respostas e destac\u00e1-la para que os participantes possam ver facilmente onde responder\u00e3o. Voc\u00ea pode inserir tantas perguntas quanto poss\u00edvel e deixar instru\u00e7\u00f5es, se necess\u00e1rio.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-4vt.png\" alt=\"\" width=\"624\" height=\"488 \" class=\"alignnone size-full wp-image-8752\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-4vt.png 624w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-4vt-300x235.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3>Etapa 3: configurar a folha de notas<\/h3>\n<p>Nesta parte, v\u00e1 em frente na Folha de Notas ao lado da Folha de Teste. Fa\u00e7a a coluna A para a folha de respostas, a coluna B para o resultado e qualquer c\u00e9lula para a pontua\u00e7\u00e3o total. Em seguida, insira tamb\u00e9m todas as respostas nesta folha de notas.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-5.png\" alt=\"\" width=\"687\" height=\"592 \" class=\"alignnone size-full wp-image-8753\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-5.png 687w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-5-300x259.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/p>\n<div class=\"refer_box\">\n<p class=\"refer_box_title\">S\u00f3 para voc\u00ea ficar sabendo<\/p>\n<p class=\"refer_box_text\">Inscreva-se para um<a href=\"https:\/\/onlineexammaker.com?refer=blog_refer\"> conta OnlineExamMaker gratuita<\/a> para criar um question\u00e1rio on-line interativo em minutos &#8211; avalia\u00e7\u00e3o autom\u00e1tica e compat\u00edvel com dispositivos m\u00f3veis.<\/p>\n<\/div>\n<h3>Etapa 4: Fa\u00e7a o c\u00f3digo<\/h3>\n<p>V\u00e1 para a planilha de pontua\u00e7\u00e3o, na coluna de resultados, selecione a primeira c\u00e9lula, escreva &#8220;=IF( &#8220;ent\u00e3o v\u00e1 para a planilha de teste, clique na c\u00e9lula de resposta, pressione =, v\u00e1 para a planilha de notas e clique na resposta abaixo da resposta folha, depois escreva &#8220;Correto&#8221;,&#8221; Incorreto&#8221;).<br \/>\nNa aba Notas escreva =IF(:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-6.png\" alt=\"\" width=\"687\" height=\"596 \" class=\"alignnone size-full wp-image-8754\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-6.png 687w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-6-300x260.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/p>\n<p>V\u00e1 para testar e clique na resposta:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-7.png\" alt=\"\" width=\"682\" height=\"586 \" class=\"alignnone size-full wp-image-8755\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-7.png 682w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-7-300x258.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p>Digite = na barra de f\u00f3rmulas:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-8.png\" alt=\"\" width=\"688\" height=\"595 \" class=\"alignnone size-full wp-image-8756\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-8.png 688w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-8-300x259.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/p>\n<p>Em seguida, clique na resposta:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-9.png\" alt=\"\" width=\"680\" height=\"592 \" class=\"alignnone size-full wp-image-8757\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-9.png 680w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-9-300x261.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/p>\n<p>Em seguida, continue o c\u00f3digo \u201cCorreto\u201d, \u201cIncorreto\u201d):<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-10.png\" alt=\"\" width=\"685\" height=\"590 \" class=\"alignnone size-full wp-image-8758\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-10.png 685w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-10-300x258.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/p>\n<p>O c\u00f3digo geralmente ficaria assim =IF(Test!Cell=Score!Cell,&#8221; Correct&#8221;,&#8221; Incorrect&#8221;) onde a c\u00e9lula \u00e9 o local onde as respostas e a folha de respostas est\u00e3o<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-11.png\" alt=\"\" width=\"685\" height=\"590 \" class=\"alignnone size-full wp-image-8759\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-11.png 685w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-11-300x258.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/p>\n<p>A seguir est\u00e1 a pontua\u00e7\u00e3o total na planilha de pontua\u00e7\u00e3o. Clique na c\u00e9lula onde estaria a pontua\u00e7\u00e3o total e digite &#8220;=COUNTIF(&#8220;em seguida, arraste o cursor pela coluna B onde estaria o resultado e digite &#8220;correto&#8221;. O c\u00f3digo inteiro geralmente ficaria assim &#8220;=COUNTIF(Cell :Cell,&#8221; Correct&#8221;)&#8221; onde a c\u00e9lula \u00e9 o intervalo do resultado.<\/p>\n<p>Digite CONT.SE:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-12.png\" alt=\"\" width=\"686\" height=\"588 \" class=\"alignnone size-full wp-image-8760\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-12.png 686w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-12-300x257.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/p>\n<p>Arraste o intervalo:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-13.png\" alt=\"\" width=\"687\" height=\"588 \" class=\"alignnone size-full wp-image-8761\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-13.png 687w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-13-300x257.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/p>\n<p>Complete o c\u00f3digo:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-14.png\" alt=\"\" width=\"688\" height=\"595 \" class=\"alignnone size-full wp-image-8762\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-14.png 688w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-14-300x259.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/p>\n<p>O c\u00f3digo finalizado:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-15.png\" alt=\"\" width=\"685\" height=\"598 \" class=\"alignnone size-full wp-image-8763\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-15.png 685w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-15-300x262.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/p>\n<h3>Etapa 5 Bloquear e ocultar a folha de notas<\/h3>\n<p>A parte mais importante \u00e9 esta etapa, pois ajuda a evitar que os alunos saibam a resposta e sua pontua\u00e7\u00e3o.<\/p>\n<p>Fa\u00e7a isso simplesmente selecionando a coluna arrastando o cursor pela folha de respostas e resultados e pressionando o bot\u00e3o direito do mouse e, em seguida, no menu, selecione Ocultar. Isso oculta toda a coluna e voc\u00ea pode exibi-las simplesmente pressionando ctrl + A, clique com o bot\u00e3o direito e selecione exibir<\/p>\n<p>Arrastando a folha de respostas e o resultado:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-16.png\" alt=\"\" width=\"687\" height=\"588 \" class=\"alignnone size-full wp-image-8764\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-16.png 687w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-16-300x257.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/p>\n<p>Clique com o bot\u00e3o direito para ocultar:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-17.png\" alt=\"\" width=\"685\" height=\"603 \" class=\"alignnone size-full wp-image-8744\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-17.png 685w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-17-300x264.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/p>\n<p>Depois de se esconder:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-18.png\" alt=\"\" width=\"689\" height=\"597 \" class=\"alignnone size-full wp-image-8745\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-18.png 689w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-18-300x260.png 300w\" sizes=\"(max-width: 689px) 100vw, 689px\" \/><\/p>\n<p>Quanto a bloquear a pr\u00f3pria planilha para impedir qualquer acesso, voc\u00ea pode clicar com o bot\u00e3o direito na aba Folha de Notas e selecionar proteger no menu; um pop ser\u00e1 aberto, em seguida desmarque todos os acessos existentes para evitar que qualquer pessoa veja esta planilha, por \u00faltimo insira a senha para bloquear a planilha de notas.<\/p>\n<p>Clicando com o bot\u00e3o direito na planilha de notas:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-19.png\" alt=\"\" width=\"689\" height=\"602 \" class=\"alignnone size-full wp-image-8746\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-19.png 689w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-19-300x262.png 300w\" sizes=\"(max-width: 689px) 100vw, 689px\" \/><\/p>\n<p>Ao selecionar proteger:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-20.png\" alt=\"\" width=\"687\" height=\"598 \" class=\"alignnone size-full wp-image-8747\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-20.png 687w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-20-300x261.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/p>\n<p>Remova o acesso e adicione uma senha:<br \/>\n<img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-21.png\" alt=\"\" width=\"692\" height=\"600 \" class=\"alignnone size-full wp-image-8748\" srcset=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-21.png 692w, https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-21-300x260.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/p>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Crie seu pr\u00f3ximo question\u00e1rio\/exame com OnlineExamMaker<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Comece gratuitamente<\/a><\/div>\n<div class=\"p-style-b\">SAAS, gr\u00e1tis para sempre<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/lan.html?refer=blog_btn\">No local: baixar<\/a><\/div>\n<div class=\"p-style-b\">100% de propriedade de dados<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cada universidade, escola e empresa usa diferentes tipos de question\u00e1rio para testar seus alunos ou funcion\u00e1rios. Um quiz \u00e9 usado para testar o conhecimento do funcion\u00e1rio sobre seu trabalho e para que os alunos saibam se entenderam a li\u00e7\u00e3o. Portanto, criar question\u00e1rios \u00e9 essencial e h\u00e1 v\u00e1rias maneiras de criar um question\u00e1rio. Voc\u00ea poderia gerar [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":8752,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5139],"tags":[],"class_list":["post-21964","post","type-post","status-publish","format-standard","hentry","category-online-quiz-tips-pt"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog<\/title>\n<meta name=\"description\" content=\"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-08T10:26:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-19T13:19:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-4vt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"624\" \/>\n\t<meta property=\"og:image:height\" content=\"488\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rebecca\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rebecca\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/\",\"name\":\"Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2024-12-08T10:26:14+00:00\",\"dateModified\":\"2025-01-19T13:19:05+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\"},\"description\":\"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como criar um question\u00e1rio no Excel &#8211; O guia definitivo para 2025\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\",\"name\":\"Rebecca\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"caption\":\"Rebecca\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog","description":"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/","og_locale":"en_US","og_type":"article","og_title":"Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog","og_description":"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.","og_url":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2024-12-08T10:26:14+00:00","article_modified_time":"2025-01-19T13:19:05+00:00","og_image":[{"width":624,"height":488,"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2022\/12\/create-quiz-in-excel-4vt.png","type":"image\/png"}],"author":"Rebecca","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rebecca","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/","url":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/","name":"Como criar um question\u00e1rio no Excel - O guia definitivo para 2025 - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2024-12-08T10:26:14+00:00","dateModified":"2025-01-19T13:19:05+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2"},"description":"Learn how to make a quiz in Excel with easy-to-follow steps. You can also create a responsive online quiz using OnlineExamMaker with AI.","breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/pt\/how-to-create-a-quiz-in-excel-the-ultimate-guide-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Como criar um question\u00e1rio no Excel &#8211; O guia definitivo para 2025"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2","name":"Rebecca","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","caption":"Rebecca"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/21964"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=21964"}],"version-history":[{"count":4,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/21964\/revisions"}],"predecessor-version":[{"id":49264,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/21964\/revisions\/49264"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/8752"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=21964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=21964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=21964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}