{"id":1191,"date":"2018-11-08T16:39:02","date_gmt":"2018-11-08T16:39:02","guid":{"rendered":"http:\/\/lash.utrng.edu.mx\/?p=1191"},"modified":"2018-11-08T17:12:01","modified_gmt":"2018-11-08T17:12:01","slug":"ejercicio-1-hoja-de-calculo","status":"publish","type":"post","link":"https:\/\/lash.utrng.edu.mx\/?p=1191","title":{"rendered":"Ejercicio 1, Hoja de C\u00e1lculo"},"content":{"rendered":"\n<p>Crear un Libro, y en su primera hoja de C\u00e1lculo realizar lo siguiente:<\/p>\n\n\n\n<p>1 Nombrar la \u00abHoja 1\u00bb como \u00abEjercicio 1\u00bb<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/1-4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/1-4.png\" alt=\"\" class=\"wp-image-1192\" width=\"290\" height=\"258\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/1-4.png 391w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/1-4-300x267.png 300w\" sizes=\"auto, (max-width: 290px) 100vw, 290px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>2. Crear la siguiente tabla de datos, seleccionando el rengo(A2:B12) y aplicarle los bordes de las celdas para dejar m\u00e1s presentable dicha tabla:<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/2-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/2-2.png\" alt=\"\" class=\"wp-image-1195\" width=\"306\" height=\"356\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/2-2.png 419w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/2-2-258x300.png 258w\" sizes=\"auto, (max-width: 306px) 100vw, 306px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Seleccionar los n\u00fameros que forman el rango A3:A12 para alinearlos al centro, tanto vertical, como horizontalmente:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/3-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/3-2.png\" alt=\"\" class=\"wp-image-1196\" width=\"269\" height=\"385\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/3-2.png 378w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/3-2-210x300.png 210w\" sizes=\"auto, (max-width: 269px) 100vw, 269px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Vamos a seleccionar la columna de estaturas(B3:B12) para aumentar en uno los decimales y podamos ver \u00ab1.60\u00bb, por ejemplo, en lugar de \u00ab1.6\u00bb<\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4a.png\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"429\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4a.png\" alt=\"\" data-id=\"1203\" data-link=\"http:\/\/lash.utrng.edu.mx\/index.php\/2018\/11\/08\/ejercicio-1-hoja-de-calculo\/4a\/\" class=\"wp-image-1203\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4a.png 238w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4a-166x300.png 166w\" sizes=\"auto, (max-width: 238px) 100vw, 238px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4b.png\"><img loading=\"lazy\" decoding=\"async\" width=\"376\" height=\"222\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4b.png\" alt=\"\" data-id=\"1202\" data-link=\"http:\/\/lash.utrng.edu.mx\/index.php\/2018\/11\/08\/ejercicio-1-hoja-de-calculo\/4b\/\" class=\"wp-image-1202\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4b.png 376w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/4b-300x177.png 300w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><\/a><\/figure><\/li><\/ul>\n\n\n\n<p>Agregar las leyendas de Promedio, Valor m\u00e1s alto y Valor m\u00e1s bajo, para que a su izquierda, ingresar las f\u00f3rmulas correspondientes(PROMEDIO, MAX, MIN) del rango indicado:<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/5-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/5-2.png\" alt=\"\" class=\"wp-image-1205\" width=\"330\" height=\"277\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/5-2.png 487w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/5-2-300x252.png 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/a><\/figure>\n\n\n\n<p>Seleccionar la primer tabla y pegarla a un costado de nuestras leyendas para continuar con ordenar los datos del mayor al menor en estatura:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/6-3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/6-3.png\" alt=\"\" class=\"wp-image-1207\" width=\"385\" height=\"222\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/6-3.png 675w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/6-3-300x173.png 300w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/a><\/figure><\/div>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"838\" height=\"523\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/7-2.png\" alt=\"\" class=\"wp-image-1208\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/7-2.png 838w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/7-2-300x187.png 300w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/7-2-768x479.png 768w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/figure>\n\n\n\n<p>Una vez seleccionado el rango y clickeado el m\u00e9todo de ordenamiento, se preguntar\u00e1 si hay que mover las filas para ordenar a lo cual seleccionaremos \u00ab<strong><em>continuar con la selecci\u00f3n actual<\/em><\/strong>\u00ab<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/8-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/8-1.png\" alt=\"\" class=\"wp-image-1209\" width=\"343\" height=\"161\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/8-1.png 430w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/8-1-300x141.png 300w\" sizes=\"auto, (max-width: 343px) 100vw, 343px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>B\u00e1sicamente, el ejercicio quedar\u00e1 de la siguiente forma:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/9-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"754\" src=\"http:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/9-1.png\" alt=\"\" class=\"wp-image-1210\" srcset=\"https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/9-1.png 839w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/9-1-300x270.png 300w, https:\/\/lash.utrng.edu.mx\/wp-content\/uploads\/2018\/11\/9-1-768x690.png 768w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Crear un Libro, y en su primera hoja de C\u00e1lculo realizar lo siguiente: 1 Nombrar la \u00abHoja 1\u00bb como \u00abEjercicio 1\u00bb 2. Crear la siguiente tabla de datos, seleccionando el rengo(A2:B12) y aplicarle los bordes de las celdas para dejar m\u00e1s presentable dicha tabla:<\/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":[34],"tags":[],"class_list":["post-1191","post","type-post","status-publish","format-standard","hentry","category-segundoparcialtecndigital"],"_links":{"self":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/1191","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=1191"}],"version-history":[{"count":7,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/1191\/revisions"}],"predecessor-version":[{"id":1211,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=\/wp\/v2\/posts\/1191\/revisions\/1211"}],"wp:attachment":[{"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lash.utrng.edu.mx\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}