CA I 4.01 Spreadsheet Components
Order by
22 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 | refers to one specific location, such as A4. |
| Cell range | refers to a group of adjacent cells, such as A4:A16. |
| Column | refers to all of the contents in a vertical range of cells of the spreadsheet. |
| Row | refers to all of the contents in a horizontal range of cells. |
| Cell data | classified according to its intended purpose. |
| Label | used for cells that contain text or for numbers that will not be used in calculations. |
| Value | indicates that the data has the potential to be used in calculations. |
| Formula | instructs the software to perform a calculation. |
| Order of Operations | Calculations are performed according to this |
| Basic 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 Cell Reference | cell value changes as the formula is copied |
| Absolute Cell Reference | cell value remains static when copied to other locations |
| Mixed Cell Reference | combination of an absolute and a relative cell |
| Parentheses | control the Order of Operations |
| Sum | adds the range of cells |
| Average | determines the average of the range of cells |
| Maximum | finds the highest number in the range of cells |
| Minimum | finds the lowest number in the range of cells |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.