click below
click below
Normal Size Small Size show me how
Excel Vocabulary
| Term | Definition |
|---|---|
| Spreadsheet | ~Document in which data is arranged in rows and columns of a grid. ~Can be manipulated and used in calculations. |
| Workbook | ~Workbook is the MS Excel file in which you enter and store related data. |
| Worksheet | ~Worksheet (also known as a spreadsheet) is a collection of cells on a single "sheet". ~where you actually keep and manipulate the data. |
| Workbook window | ~Window where it displays the spreadsheet/worksheet in a workbook |
| Cell | ~Individual cells are usually identified by a column letter and a row ~A spreadsheet cell is analogous to a field in database management systems. |
| Sheet tab | ~The sheet tabs at the bottom of the window show |
| Active Worksheet | ~An active worksheet is the worksheet that is currently open. |
| workspace | ~A workspace in Excel is a file that memorizes the current layout of all open windows and workbooks. |
| Columns | ~A column is a vertical series of cells in a chart, table, or spreadsheet. |
| Rows | ~A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. |
| Headings | ~In Excel and other spreadsheet applications, the column header is the colored row of letters used to identify each column within the sheet, or workbook. |
| Cell Reference | ~A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula ~Cell reference to refer to: Data from one cell on the worksheet. |
| Name Box | ~ 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 | ~A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. |
| Formula | ~Allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. |
| Relative Reference | Relative references change when a formula is copied to another cell |
| Absolute Reference | ~Absolute references, on the other hand, remain constant, no matter where they are copied. |
| Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column. |
| Active Cell | ~An active cell is the selected cell in which data is entered when you begin typing. It is the cell surrounded by a black border |
| Enetr Data | ~Data that is typed into a cell |
| Ranger | ~Place or arrange in a row or rows or in a specified order or manner. |
| Gridlines | ~Alternatively referred to as a column separator or row separator. ~Gridlines are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet. |