¿Cómo aprender Los conceptos básicos de una hoja de cálculo usando openoffice.org calc?
La hoja de cálculo
Aprende qué significa una celda dentro de una hoja de cálculo. Ingresa datos. Borra los datos. Ponle formato a los datos

La celda es el elemento fundamental dentro de una hoja de cálculo. Es aquí donde se ven y se agregan las cosas. La dirección de una celda en una hoja de cálculo identifica la ubicación de la celda dentro de la hoja. La dirección de una celda es la combinación de la letra de la columna y su número de fila, como por ejemplo A2 o B16. Cuando identifiques una celda por su dirección, la letra de la columna siempre se lista antes que el número de fila. La dirección de celda del ejemplo que se encuentra a continuación es A5.     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-6Bullet1.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-6Bullet1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-6Bullet1.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-6Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"} Haz clic en la celda A1 (esta se encuentra en el extremo superior izquierdo de la hoja de cálculo).     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f8\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet1.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f8\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet1.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Presta atención al borde negro que rodea a la celda A1. Este borde negro indica que A1 es la celda activa. (A se encuentra en el extremo superior de la primera columna y 1 en la primera fila. Ambos signos están resaltados. Esto también indica que A1 es la celda activa.)     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/97\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet2.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/97\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet2.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Escribe "Hola Mundo" (sin las comillas) y presiona Enter.     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7e\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet3.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7e\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet3.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"} Ahora la celda activa es A2. (Las palabras "Hola Mundo" están en A1.)   Cuando escribes algo en una celda y presionas enter, lo que escribes se podrá ver en esa celda y la celda inferior se convierte en la próxima celda activa.    {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cd\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet4.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cd\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet4.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-7Bullet4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"} Haz clic nuevamente sobre A1.     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4e\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet1.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4e\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet1.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Presiona la tecla Supr o haz clic derecho sobre la celda y selecciona "Eliminar contenidos". (Aparecerá la ventana "Eliminar contenidos".)    {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/51\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet2.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/51\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet2.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Haz clic en "Eliminar todo" y luego presiona "Aceptar". (Las palabras "Hola Mundo" fueron eliminadas de A1)     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ab\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet3.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ab\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet3.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-8Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"} Separa los miles, coloca dos espacios decimales y marca los números negativos en rojo. Haz clic sobre la celda A1. > Escribe el número -9999.129 > Presiona Enter. (El cursor se moverá a A2)     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet1.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet1.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Haz clic derecho sobre la celda A1. (Aparecerá un pequeño menú) > haz clic en "Formatear celdas". (Aparecerá la ventana "Formato de celdas")    {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e0\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet2.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e0\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet2.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Haz clic sobre la pestaña "Números". En la sección categoría, haz clic en "Número". En la sección "Formato", haz clic en -1,234.12. Haz clic en la opción "Números negativos en rojo". (Aparecerá una marca sobre el casillero) > Presiona "Aceptar". (En la celda A1 aparecerá el número "-9,999.13")    {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet3.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet3.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}  Para alinear a la izquierda, primero haz clic sobre la pestaña "Alineación". En el menú desplegable "Horizontal", selecciona "Izquierda". Presiona "Aceptar". (Los números se moverán hacia el borde izquierdo de la celda)     {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f5\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet4.jpg\/v4-460px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f5\/Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet4.jpg\/v4-760px-Learn-Spreadsheet-Basics-with-OpenOffice.org-Calc-Step-9Bullet4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":760,"bigHeight":570,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
The Spreadsheet Itself