Excel Vocabulary
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Spreadsheet | a piece of paper or computer program used for accounting and recording data using rows and columns into which information can be entered.
🗑
|
||||
| Workbook | a file in which you enter and store related data.
🗑
|
||||
| Worksheet | a single spreadsheet that contains cells organized by rows and columns.
🗑
|
||||
| Workbook Window | the current workbook that is being displayed.
🗑
|
||||
| Cell | A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.
🗑
|
||||
| Sheet Tab | the current worksheet that is being displayed.
🗑
|
||||
| Active Worksheet | the worksheet you are currently working on.
🗑
|
||||
| Workspace | a file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings.
🗑
|
||||
| Columns | in a worksheet, the vertical spaces with headings A, B, C, and so on.
🗑
|
||||
| Rows | in a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
🗑
|
||||
| Headings | the identifying letters and numbers for columns and rows.
🗑
|
||||
| Cell Reference | a string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference.
🗑
|
||||
| Name Box | the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet.
🗑
|
||||
| Formula Bar | a command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
🗑
|
||||
| Formula | a combination of numbers and symbols used to express a calculation
🗑
|
||||
| Relative Reference | an address or pointer that changes when the target item is moved or the relationship to it has changed
🗑
|
||||
| Absolute Reference | an address or pointer that does not change
🗑
|
||||
| Mixed Reference | either an absolute column and relative row or absolute row and relative column.
🗑
|
||||
| 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 | entering numbers and dates in Microsoft Excel worksheets.
🗑
|
||||
| Range | a group or block of cells in a worksheet that have been selected or highlighted.
🗑
|
||||
| Gridlines | divide each of the cells, rows, and columns in a spreadsheet.
🗑
|
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:
fredrickdionisio
Popular Computers sets