NC Computer Apps 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.
Set Champions
Scatter Champion
24.3 secs by QianQian
Space Race Champion
33,790 points by QianQian
Speller Champion
97.8% correct by terijowatkins