click below
click below
Normal Size Small Size show me how
Excel Vocab
| Term | Definition |
|---|---|
| Spreadsheet | is an interactive computer application program for organization, analysis and storage of data in tabular form. |
| Workbook | is a file that contains one or more worksheets that you can use to organize various kinds of related information. |
| Worksheet | is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula. |
| Workbook window | Minimize/Maximize options appear immediately below these Excel window options, if the workbook window is maximized. |
| Cell | A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information. |
| Sheet tab | is a data file made up of rows and columns that are used to sort data and allow the user to manipulate and arrange data easily, commonly numerical data. Use the shortcut key Alt + Shift + F1 to insert a new sheet. |
| Active worksheet | is the worksheet that is currently open. |
| Workspace | If you open the same workbooks every day, save these workbooks as a workspace. If you open the workspace file, Excel opens all your workbooks and the layout of all windows. This can save time. |
| Columns | is a vertical series of cells in a chart, table, or spreadsheet. |
| Rows | is a series of data banks laid out in a horizontal fashion in a table or spreadsheet. |
| Headings | a title of the head of a page or a section of a book. |
| Cell reference | is a cell in a spreadsheet that is a location-based cell reference. |
| Name box | is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
| Formula bar | is a section in Microsoft Excel and other spreadsheets that shows the contents of the current cell and allows you to create and view formulas. |
| Formula | is an expression telling the computer what mathematical operation to perform upon a specific value. When referring to computer software, formulas are most often used in spreadsheet programs such as Microsoft Excel. |
| Relative reference | is a cell in a spreadsheet that is a location-based cell reference (including related links, information, and terms). |
| Absolute reference | is a spreadsheet cell that does not change regardless of its attributes. |
| Mixed reference | is either an absolute column and relative row or absolute row and relative column. |
| Active cell | is a rectangular box, highlighting the cell in a spreadsheet. It helps identify what cell is being working with and where data will be entered. |
| Enter data | into a computerized database or spreadsheet. Data entry can be performed by an individual typing at a keyboard or by a machine entering data electronically. |
| Range | is a group of cells within a row or column. |
| Gridlines | are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet. |