click below
click below
Normal Size Small Size show me how
Excel
| Term | Definition |
|---|---|
| Spreadsheet | the entire Excel File that you created from Microsoft Excel. |
| Workbok | automatically shows in the workspace when you open Microsoft Excel XP. A workbook contains 3 worksheets. |
| Worksheet | A grid of cells consisting of 65,536 rows and 256 columns. Spreadsheet information—text, numbers, or mathematical formulas—is entered into different cells. |
| Workbook Window | a window between more than one workbooks. You can switch between workbooks in the middle of your work. |
| Cell | an intersection of a column and row. Each cell has a unique cell address. In the picture above, the cell address of the selected cell in B3. The heavy border around the selected cell is called the cell pointer. |
| Sheet Tab | Shows the name of different worksheets. It will show both the active worksheet and other minimized worksheets if there are any. |
| Active Worksheet | the worksheet that you are currently working on. The other minimized worksheets are inactive. |
| Workspace | A file or directory within storage area. |
| Columns | Each Excel spreadsheet contains 256 columns. Each column is named by a letter or combination of letters. Columns group cells vertically. |
| Rows | each spreadsheet contains 65,536 rows. Each row is named by a number. Rows group cells horizontally. |
| Headings | A section of the subject. A division of a topic. |
| Cell Reference | A string identifying a particular cell or group of cells. |
| Name Box | shows the address of the current selection or active cell. |
| Formula Bar | Displays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar. |
| Formula | an equation typed into the formula bar (or cell) that defines the value of the cell. |
| Relative Reference | when cells related to other cells such as in terms of formula. |
| Absolute Reference | when cells have an exact same constant in their formula with another cell. |
| Mixed Reference | an absolute column and relative row or absolute row and relative column. |
| Active Cell | the current cell(s) that you are working on. The other cells are inactive. |
| Enter Data | inputting the formula to define the value of a cell or cells |
| Range | the difference between the highest and the lowest of differences in a series of numbers. |
| Gridlines | Faint lines that appear around cells in Excel. They are used to distinguish cells on the worksheet. |
| A row groups cells vertically | False |
| Headings contain an equation typed into the formula bar to define the value of a cell | False |
| A workspace is a fire or directory within storage agrea | True |
| A Mixed Reference is when cells have both an absolute and relative reference to define its value | True |
| Gridlines are faint lines that appear around cells in Excel | True |
| Columns show the address of the current selection or active cell. | False |
| Formulas are equations typed into the formula bar to define the value of the cell | True |
| Cells are intersections of a column and row that gives it a unique "address" | True |
| Headings show the section of the subject or is a division of a topic | True |
| A workbook automatically shows in the workspace when you open Microsoft Excel. A workbook opens up with 3 worksheets. | True |