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.
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.
- Active Cell - The thick-bordered cell where you can enter numbers or formulas.
- Cell - The space at the intersection of a row and a column.
- 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.
- Chart/Graph - Visual representation of data in a spreadsheet
- Types of charts and what they are used for
- Line Graph - A graph used to display trends by lines that connect points of data, used to show changes over a period of time.
- Pie Graph - Circle graph divided into pieces that look like portions of a pie which show relationship of one set of data to the entire data (%).
- Bar Graph - Used to compare individual or sets of values to each other.
- Types of charts and what they are used for
- 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.
- Formula Bar or Data Entry Bar--the bar at the top of the spreadsheet used to enter data into the cell that you have selected
- Graph/Chart - a visual representation of numerical data; can present complex relationships clearly, and make trends and patterns identifiable.
- Grid - Blank setup of rows and columns in a spreadsheet on which data is to be entered
- 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
- Label - The term given to the data entered as text in 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.
- Legend - Text that explains the meaning of colours and patterns used in a graph/chart also called the key.
- 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.