click below
click below
Normal Size Small Size show me how
Vocabs
| Definition | |
|---|---|
| 1. Spread Sheet: | A grid of rows and columns in which you enter text, numbers, and the results of calculations. |
| 2. Work sheet: | Sheets in an Excel workbook |
| 3. Work book: | A group of adjacent worksheets. |
| 4. Work book window: | An Excel file that contains one or more worksheets. Each of the workbook worksheets are in separate tabs on the bottom of the Excel window. |
| 5. Cell: | The intersection of a column and row in a table or in a spreadsheet. |
| 6. Sheet tab: | The name of each worksheet at the bottom of the worksheet window. Three is the default number of worksheets and you can have as many as 255. |
| 7. Active worksheet: | The worksheet that is displayed in the work area. |
| 8. Workspace: | A file that memorizes the current layout of all open windows. |
| 9. Columns: | Appears vertically in the worksheet; identified by letters at the top of the worksheet window. |
| 10. Rows: | Appears horizontally in the worksheet; identified by numbers on the left side of the worksheet window. |
| 11. Headings: | Text that is printed at the top of each page. |
| 12. Cell reference: | A unique identifier for a cell, which is formed by combining the cell's column letter and row number. |
| 13. Name box: | The cell reference area located below the Ribbon, which displays the cell reference of the active cell. |
| 14. Formula bar: | The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value. |
| 15. Formula: | An equation that calculates a new value from values currently in a worksheet. |
| 16. Relative reference: | A cell reference that adjusts to its new location when copied or moved. |
| 17. Absolute reference: | A cell reference that doesn't change a copy when its moved. |
| 18. Mixed reference: | A cell reference that contains both relative and absolute references. |
| 19. Active cell: | The cell in the worksheet in which you can type data. |
| 20. Enter data: | When you enter text or numbers in Microsoft excel work sheets. |
| 21. Range: | A group of selected cells |
| 22. Gridlines: | Solid lines that mark off the rows and columns in a worksheet. |