Tareas

| Spreadsheets: Features |
Columns and Rows |
* A spreadsheet is a grid consisting of columns and rows. Rows are labeled with numbers, and columns are labeled with letters, giving each cell aunique address consisting of a number and a letter. If you are familiar with the old game "Battleship", you'll be quite comfortable with cell addressing. * A cell may contain labels or values. Alabel is a text entry, such as TOTAL, that can not be manipulated by the spreadsheet. A value can be a number, a date, a formula, or the answer of a formula. * A single "grid", or page, is usuallyreferred to as a worksheet. |
Formulas |
* Formulas are used to express mathematical relationships between cells. For example, C1=A1+B1 would calculate and display the sum of cells A1 and B1into cell C1. It could also be a simple mathematical formula, such as (100 * 3) / 40. Formulas are not displayed on spreadsheets. What you see in the cell is the result of the formula. * Don't forgetabout order of operations; anything inside parenthesis happens first, followed by multiplication and division, followed by addition and subtraction. When in doubt, use parenthesis to say exactly whatyou mean. |
Functions |
Functions are used as shortcuts when performing mathematical calculations. They are pre-programmed formulae that give power and flexibility to spreadsheet calculations.They prevent the user from having to continually enter long and cumbersome expressions. Some examples are SUM, AVERAGE, MAX, and MIN. |
Ranges |
A range is a block of cells. Formulas can act onsingle cells or be directed to act on a range of cells. For example, the range A1:D1 includes the cell A1, B1, C1 and D1. Any calculation performed in A1 will also be performed in B1, C1 and D1. |Graphs and charts |
* Data in spreadsheets can be displayed in a graphic form. Spreadsheets allow theÊ numerical data in the cells to be displayed as a graph or chart. These graphics, which...