{"id":215,"date":"2016-10-28T02:14:02","date_gmt":"2016-10-28T02:14:02","guid":{"rendered":"http:\/\/lash.utrng.edu.mx\/?p=215"},"modified":"2016-10-28T03:28:03","modified_gmt":"2016-10-28T03:28:03","slug":"algunos-ejercicios-de-excel","status":"publish","type":"post","link":"https:\/\/lash.utrng.edu.mx\/?p=215","title":{"rendered":"Algunos ejercicios de Excel"},"content":{"rendered":"<h2><span style=\"color: #0000ff;\"><strong>Ejercicio Tabla de Multiplicar<\/strong><\/span><\/h2>\n<p>Crear un documento de Excel\u00a0con las f\u00f3rmulas necesarias para que al modificar la celda <strong>B1<\/strong> de la hoja de c\u00e1lculo, calcule de manera autom\u00e1tica la tabla de multiplicar correspondiente al n\u00famero introducido en dicha celda.<\/p>\n<p><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/001.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-216 size-medium\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/001-300x206.png\" alt=\"001\" width=\"300\" height=\"206\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/001-300x206.png 300w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/001-768x527.png 768w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/001.png 877w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n<p>Recordar el uso del <strong>\u00ab=\u00bb<\/strong> para indicar que vamos a hacer referencia al valor de otra celda. Por favor, nombrar a sus archivos con su nombre para mejor control de portafolio. P. ej. LuisAntonioSaucedoH.xlsx o LASaucedoH.xlsx, etc.<\/p>\n<h2><span style=\"color: #0000ff;\"><strong>Ejercicio Presupuesto<\/strong><\/span><\/h2>\n<p>Al ejercicio anterior agregar una hoja\u00a0con las f\u00f3rmulas necesarias para\u00a0que calcule el total un\u00a0presupuesto como el que se indica en la siguiente imagen:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-220 aligncenter\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/002-300x243.png\" alt=\"002\" width=\"300\" height=\"243\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/002-300x243.png 300w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2016\/10\/002.png 699w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ejercicio Tabla de Multiplicar Crear un documento de Excel\u00a0con las f\u00f3rmulas necesarias para que al modificar la celda B1 de la hoja de c\u00e1lculo, calcule de manera autom\u00e1tica la tabla de multiplicar correspondiente al n\u00famero introducido en dicha celda.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-segundoparcialmecainfo"],"_links":{"self":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=215"}],"version-history":[{"count":4,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":222,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions\/222"}],"wp:attachment":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}