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. |