Flashcards: Apps I - 4.01 Vocabulary List 1
About these flashcards
Created by:
rhonda_siers on November 5, 2009
Subjects:
Log in to favorite or report as inappropriate.All 25 terms
Terms | Definitions |
|---|---|
 Workbook | a file which contains one or more spreadsheets. |
| Spreadsheet | an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. |
| Cells | individual locations on a spreadsheet. |
| Cell address | Cell A4 refers to one specific location. |
| Cell range | A4:A16 refers to a group of adjacent cells. |
| Column | the contents in a vertical range of cells |
| Row | the contents in a horizontal range of cells |
| 'All Years'!A6:E16 | a range of cells in a specific spreadsheet. |
| Cell data | classified according to its intended purpose. |
| Label | classification is used for cells that contain text or for numbers that will not be used in calculations. |
| Value | classification indicates that the data has the potential to be used in calculations. |
| Formula | instructs the software to perform a calculation. |
| Formulas use: | addition, subtraction, multiplication, and division |
| Order of Operations | Parentheses, Exponents, Multiplication and Division, Addition and Subtraction |
| Function | a shortcut for a formula. |
| Cell reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations. |
| Relative reference | cell value changes as the formula is copied |
| Absolute reference | cell value remains static when copied to other locations |
| Mixed reference | combination of an absolute and a relative cell |
| Parentheses | control the Order of Operations |
| Conditions or criteria | tell the function how to calculate the results and what data to use. |
| Sum | adds the range of cells from C4 through C18 |
| Average | determines the average of the range of cells from C4 through C18 |
| Maximum | finds the highest number in the range of cells from C4 through C18 |
| Minimum | finds the lowest number in the range of cells from C4 through C18 |