Spreadsheet Software: Features, Tables and Formulas

Spreadsheet Software and Advantages

Spreadsheet: Infomat is a program dedicated to operations from data arranged in tablas. Ventajas: we can store and retrieve operations later. If we entered data incorrectly, we can modify it without repeating the whole process, and it allows us simulaciones. Además, it can also be used in creating databases, graphics and documents that integrate text, images, results of operations, etc. Las spreadsheets used most include Galco, Gnumeric, Lotus 1-2-3 (IBM) and Microsoft Excel. They disponen of tools and a common work environment because many tasks are similar regardless of the type and application you're using.

Elements of a Spreadsheet

Elements spreadsheet: Table: It is an element that is used to store and sort information in a clear and sencilla. The table elements are columns, rows, and the intersection of a column and a row; these intersections are known as cells.

Operations and Priorities

Operations and priorities:

• Suma (Addition): to use this operator we use the + sign on the teclado.
• Resta (Subtraction): this operation is performed by inserting the - sign.
• Multiplicación (Multiplication): the product is identified with the * sign.
• División (Division): to divide two values use the / sign.
• Potencia (Power): use the ^ symbol on the teclado.

Cuando combine varias operaciones, do not forget the paréntesis to ensure correct order of operations.

Ranges and Range Operations

Ranges and operations ranges: El tamaño de la hoja de cálculo is so large and can contain so much data that, a veces, it is necessary that certain operations are performed only sobre alguna celda. Aparece entonces el concepto de rango, which is simply a set of cells that form a rectangular range. By apuntando the directions of the cells located in the upper-left and lower-right corner of the rectangle we want to select, we separate them with a colon character (for example: A1:C10).

Column Width

Column Width: To change the column width there are three procedimientos:

1. Activate any cell in the column whose width you want to modificar.
2. Select the column width option from the menu (ancho) or introduce formato.
3. Accept and click to apply the new width.

Select Multiple Ranges

Select multiple ranges: Used to mark consecutivos. Es ranges not possible to do with any of the possibilities, de celdas, rows, columnas. Para this:

1. Place the pointer in the desired position.
2. Make the selection as has been indicado for the first range.
3. In another position, place the pointer while holding down the Control key.
4. Continue making selections as previously indicado until the multi-range selection is complete.

If a reference address is equivocada (incorrect), revise the cell reference. Example: 5.6375E+15; equivalent to 5.6375 × 10¹⁵. Finally, note that if the data occupies a width greater than the column, it may be displayed truncated or with overflow depending on formatting.