Spreadsheet Terms
Spreadsheet- An application that can be used to do calculations, analyze and present data. It includes tools for organizing, managing, sorting and retrieving data. It has a chart feature that displays numerical data as a graph.
|
|
- Cell Address - the location of a cell on the spreadsheet identified by the column letter and row number.
- Cell Range - a group or block of cells in a spreadsheet. Operations can be performed on a range of cells. The range highlighted below is B3 through D4. It is written as B3:D4
- Cell Reference Error - If a formula is not correctly entered in a spreadsheet the error message #REF will appear in the cell.
|
|
- Line Graph - A graph used to display trends by lines that connect points of data, used to show changes over a period of time.
- Column - The vertical divisions in a spreadsheet that are named with an alphabetical letter.
- Column Heading - The lettered box at the top of a column in a spreadsheet, used to highlight an entire column.
|
|
- Gridlines - The vertical and horizontal lines displayed in the body of a spreadsheet; the intersections of the gridlines forms cells
- There are 3 types of data that can be entered into a spreadsheet
* Values - The term give to the data entered as numbers in a spreadsheet
* Formulas - Mathematical equation consisting of numbers, other cell designators, and symbols for mathematical operations. The result of the formula is displayed in the cell, the formula is displayed in the data entry bar. Formulas are calculated using the normal algebraic rules concerning order of operations.
|
|
- Row - The horizontal divisions in a spreadsheet named with a number.
- Row Heading - The numbered box at the beginning of a row in a spreadsheet, used to highlight an entire row.
- Sort - Arranging information in a specific order (usually ascending and descending)
- Ascending Order - Organizing or sorting information in order from smallest to largest, or A-Z or 1-9.
- Descending Order - Organizing or sorting information in order from largest to smallest, Z-A, or 9-1.