Term | Definition |
Spreadsheet | present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. |
Workbook | : A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data. |
Worksheet | The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook. |
Workbook window | a spreadsheet file. By default, each workbook in Excel contains 3 pages or worksheets. |
Sheet tab | appears at the bottom of the worksheet. It has the name of the worksheet on it. |
Active worksheet | The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold. |
Workspace | space in which to work. |
Columns | Go up and down the spreadsheet like columns in a building. These are labeled with letters. |
Rows | Go across the spreadsheet like rows in a theater. |
Headings | is the colored row of letters used to identify each column within the sheet, or workbook. The column header row is located above the row one. See also column. |
Cell reference | refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. |
Name Box | on the formula bar. this is best used for creating a workbook level name for a selected range. Create a name from selection. You can conveniently create names from existing row and column labels by using a selection of cells in the worksheet. |
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 | is any equation entered into a cell on a Microsoft Excel spreadsheet. |
Relative References | references are in the format A1 and if copied to a different cell the cell reference changes relative to the new location. For example, if the formula specifies A1 and is copied to a new location two rows down the new formula would specify A3. |
Absolute References | Absolute means that the reference in a formula will always look for the value in a specific cell, even if you copy the cell to a different location. The format for an absolute reference is $A$1 (referring to cell A1). |
Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row. |
Active cell | The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border |
Enter Data | Process data in a cell in a worksheet |
Range | 2 or more cells on a sheet. |
. Gridlines | : Lines you can add to a chart that make it easier to view and evaluate data. Grid lines extend from the tick marks on an axis across the plot area. |
True or False
Range has 1 cell on a spreadsheet | False |
True or False
Sheet tab appears at the top of the spreadsheet | False |
True or False
Formula is ANY equation entered into a cell in excel. | True |
True or False
An example of Absolute Reference is $B$4 | True |
True or False
A worksheet is the same as a speadsheet | True |
True or False
There can only be 2 or more active cells at a time | False |
True or False
A workbook file is found at the bottom of the spread sheet. | True |
True or False
The active worksheet is a worksheet that you're not working on currently. | False |
True or False
Relative Reference doesn't change as the cell changes | False |
True or False
An example of a mixed reference is A$4 | True |