spreadsheets

A spreadsheet is a application which displays multiple cells that will work together to make up a grid consisting of rows and columns. In these cells you may type a text, numeric values or formulas. A formula is how the cell will be valued or calculated from the contents from a cell or multiple cells. Shreedsheets are commonly used for financial information because of its ability to calculate or re-calculate a cell after a change has been made.
 * What is a spreadsheet? **

This is what a blank worksheet looks likes. ** What is a cell ** A cell is a box in the shreedsheet and is usually referenced by its column and row such as A5 would represent row A and Column 5 which is a specific cell. As seen in the above picture ** What is a Locked Cell ** When a text, number or formula has been entered it can be optionally locked to prevent accidental overwriting. This is usally done to cells that contain formuals or constants. ** Cell Reference ** Cell Referencing is where you place a alternative cell reference in a named cell. Most cell references indicate another cell in the same spreadsheet, but a cell reference can also refer to a cell in a different sheet within the same spreadsheet or to a cell in another spreadsheet. A cell on a different sheet on the same spreadsheet would usually look something like this: =sheet2!A1 which means the first cell in sheet 2 of the same spreadsheet A cell on a different spreadsheet would usually look like something like this: =c:/My documents/phils spreadsheets/[main sheet]Sheet1!A1 ** Formulas ** A formula is the calculation needed to place the results in the cell it is contained within. A formula will have the formula itself but also the resulting value. An example of a formula is: =sum(A1+B2) which would add the value in cell A1 + B2  ** Protecting Sheets ** Protecting a sheet prevents unwanted changes to the data in the sheets by specifying what information can be changed. An example, you can prevent people from editing locked cells or changing the formatting of the cell.

** Other Functions: ** **Vlookup:** Vlookup searches for a value in the first column of a table array and returns a value in the same row from another column in a table array. An example is: = VLOOKUP(1,A2:C10,2) using this it will search for the value in 1 in column A, finds the matching value and return it to that cell. **Freeze Panes:** Freezing panes keeps a portion of the sheet visible while the rest of the sheet scrolls.