{"id":187,"date":"2023-11-12T18:51:05","date_gmt":"2023-11-12T18:51:05","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/"},"modified":"2023-12-25T10:25:31","modified_gmt":"2023-12-25T10:25:31","slug":"calificacion-de-estrellas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/","title":{"rendered":"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1297402922\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p class=\"has-text-align-left\">A continuaci\u00f3n se ofrece un consejo r\u00e1pido que le ayudar\u00e1 a crear una plantilla de calificaci\u00f3n de estrellas en Excel. Para crear esta plantilla de calificaci\u00f3n con estrellas, todo lo que necesita es la funci\u00f3n REPT. La funci\u00f3n REPT es \u00fatil cuando desea repetir un texto determinado un n\u00famero determinado de veces.<\/p>\n<h2 id=\"h-steps-to-create-a-star-rating-template\" class=\"wp-block-heading\"> Pasos para crear una plantilla de calificaci\u00f3n de estrellas<\/h2>\n<ol>\n<li> Inserta dos tipos diferentes de estrellas (\u2606\u2605) en tu hoja de c\u00e1lculo y col\u00f3calas en dos celdas diferentes.<\/li>\n<li> Inserte cinco botones de opci\u00f3n (control de formulario) desde la pesta\u00f1a de desarrollador. Y cree un enlace de celda \u00fanica para todos los botones. Col\u00f3quelos en cinco celdas en direcci\u00f3n vertical.<\/li>\n<li> Fusiona 5 celdas, solo una columna antes, donde tienes botones.<\/li>\n<li> Ingrese \u00ab=REPT(H11,5-K11)&amp;REPT(I11,K11)\u00bb en la celda combinada.<\/li>\n<li> Cambie la orientaci\u00f3n del texto de la celda a texto vertical, luego cambie la alineaci\u00f3n del texto al centro y al fondo.<\/li>\n<\/ol>\n<p> Tu modelo est\u00e1 listo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" sizes=\"\" srcset=\"\" alt=\"plantilla de calificaci\u00f3n de estrellas en excel\"><\/figure>\n<\/div>\n<h2 id=\"h-how-it-works\" class=\"wp-block-heading\"> C\u00f3mo funciona<\/h2>\n<p> La primera parte de la f\u00f3rmula le dar\u00e1 estrellas descritas. Por ejemplo, cuando haces clic en una calificaci\u00f3n de 3 estrellas, se te dar\u00e1 el resto de las dos estrellas del plan.<\/p>\n<p> La segunda parte de la f\u00f3rmula te dar\u00e1 estrellas rellenas. Por ejemplo, cuando haces clic en la calificaci\u00f3n de 4 estrellas, obtendr\u00e1s 4 estrellas completas.<\/p>\n<p class=\"content-box-green\"> Tambi\u00e9n puede insertar s\u00edmbolos en la propia f\u00f3rmula o tambi\u00e9n puede utilizar otros tipos de s\u00edmbolos como desee. <\/p>\n<div class=\"gb-container gb-container-bafb25cc gb-container-download-2\">\n<div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\">\n<div class=\"gb-grid-column gb-grid-column-15a917ef\">\n<div class=\"gb-container gb-container-15a917ef\">\n<h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Obtener el archivo Excel <\/h2>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-18357188\">\n<div class=\"gb-container gb-container-18357188\">\n<div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/modele-devaluation-par-etoiles-excel-2.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/filtro-horizontal\/\">Crear un filtro horizontal en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-nombre-de-archivo\/\">Obtener nombre de archivo en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-el-nombre-de-la-hoja\/\">Obtener el nombre de la hoja en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/generar-letras-aleatorias\/\">Genera r\u00e1pidamente letras aleatorias en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aleatorizar-la-lista\/\">Aleatorizar una lista (clasificaci\u00f3n aleatoria) en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A continuaci\u00f3n se ofrece un consejo r\u00e1pido que le ayudar\u00e1 a crear una plantilla de calificaci\u00f3n de estrellas en Excel. Para crear esta plantilla de calificaci\u00f3n con estrellas, todo lo que necesita es la funci\u00f3n REPT. La funci\u00f3n REPT es \u00fatil cuando desea repetir un texto determinado un n\u00famero determinado de veces. Pasos para crear [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-187","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?\" \/>\n<meta property=\"og:description\" content=\"A continuaci\u00f3n se ofrece un consejo r\u00e1pido que le ayudar\u00e1 a crear una plantilla de calificaci\u00f3n de estrellas en Excel. Para crear esta plantilla de calificaci\u00f3n con estrellas, todo lo que necesita es la funci\u00f3n REPT. La funci\u00f3n REPT es \u00fatil cuando desea repetir un texto determinado un n\u00famero determinado de veces. Pasos para crear [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/\",\"name\":\"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"datePublished\":\"2023-11-12T18:51:05+00:00\",\"dateModified\":\"2023-12-25T10:25:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?","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:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?","og_description":"A continuaci\u00f3n se ofrece un consejo r\u00e1pido que le ayudar\u00e1 a crear una plantilla de calificaci\u00f3n de estrellas en Excel. Para crear esta plantilla de calificaci\u00f3n con estrellas, todo lo que necesita es la funci\u00f3n REPT. La funci\u00f3n REPT es \u00fatil cuando desea repetir un texto determinado un n\u00famero determinado de veces. Pasos para crear [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/","url":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/","name":"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","datePublished":"2023-11-12T18:51:05+00:00","dateModified":"2023-12-25T10:25:31+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/calificacion-de-estrellas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo crear una plantilla de calificaci\u00f3n de estrellas en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/187\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/187\/revisions\/1071"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}