Vocabs
Help!
|
|
||||
|---|---|---|---|---|---|
| 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.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
erinxagulto
Popular English Verbs sets