Flashcards: excel terms
About these flashcards
Created by:
drogers0510 on October 19, 2010
Subjects:
Log in to favorite or report as inappropriate.All 34 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 |
| Chart Types | The types of charts that can be created, pie , column, bars, pyramid, radar, line, cone, etc. |
| Formula Bar | Provides information about the active cell. formulas can be entered and edited in Formula Bar |
| wrap data | A way to display information in a cell that is tooo long for the cell by allowing it to contue onto multiple lines. |
| Fill handle | When selected it can copy or fill a value or formula |
| Sheet Tab | There is a tab for each Excel Worksheet in the Workbook This is located at the bottom of the spreadsheet. |
| Gridlines - | The gray vertical and horizontal lines that define the cells in the worksheet area are called gridlines |
| cell address | The name given to the cell's location in the spreadsheet. Column letter and row number is used for the address. |
| Workbook | An excel document which contains three worksheets by default but can have more than three |
| Range | the limits of the values a function can take ( B2:B6 ) |
| Graph | represent by means of a graph |
| Table | a set of data arranged in rows and columns |
| Chart | a visual display of information |