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 | sheet of paper that shows accounting or other data in rows and columns; a spreadsheet is also a computer application program that simulates a physical spreadsheet by capturing, displaying, and manipulating data arranged in rows and columns.
🗑
|
||||
| Workbook | A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.
🗑
|
||||
| Worksheet | The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.
🗑
|
||||
| Workbook window | A new page.
🗑
|
||||
| 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 name of the worksheet appears on its sheet tab at the bottom of the document window. To select one of the other two worksheets, simply click on the sheet tab of Sheet2 or Sheet3.
🗑
|
||||
| Active worksheet | The current worksheet you are working on.
🗑
|
||||
| Workspace | Space in which to work.
🗑
|
||||
| Columns | Columns are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets.
🗑
|
||||
| Rows | the boxes that are vertically and horizontally.
🗑
|
||||
| Headings | The title(s).
🗑
|
||||
| Cell reference | The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.
🗑
|
||||
| Name box | Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. To name a cell or range, type the name in the Name box and press ENTER. To move to and select a named cell, click its name in the Name box.
🗑
|
||||
| Formula Bar | A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.
🗑
|
||||
| Formula | Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. To name a cell or range, type the name in the Name box and press ENTER. To move to and select a named cell, click its name in the Name box.
🗑
|
||||
| Relative reference | In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. If you copy the formula, the reference automatically adjusts. A relative reference takes the form A1.
🗑
|
||||
| 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 | Inputting characters such as “letters, numbers, etc.”
🗑
|
||||
| Range | Two or more cells on a sheet. The cells in a range can be adjacent or non-adjacent.
🗑
|
||||
| Gridlines | Two or more cells on a sheet. The cells in a range can be adjacent or non-adjacent.
🗑
|
||||
| [[True/False]] ROW can be Vertical and Horizontal | True
🗑
|
||||
| [[True/False]] HEADINGS are the titles | True
🗑
|
||||
| [[True/False]] A WORKSHEET program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data. | False
🗑
|
||||
| [[True/False]] WORKBOOK window is a new page | True
🗑
|
||||
| [[True/False]] ROWS are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. | False
🗑
|
||||
| [[True/False]] HEADINGS are inputting characters such as “letters, numbers, etc.” | False
🗑
|
||||
| [[True/False]] The current worksheet you're working on is called a ACTIVE WORKSHEET | True
🗑
|
||||
| [[True/False]] A GRIDLINES is bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell. | False
🗑
|
||||
| [[True/False]] An ACTIVE CELL is two or more cells on a sheet. The cells in a range can be adjacent or non-adjacent. | False
🗑
|
||||
| [[True/False]] A Name box is where you put your name. | False
🗑
|
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:
Lanasablan
Popular Computers sets