Excel Vocab
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Spreadsheet | An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
🗑
|
||||
| Workbook | A single file containing several different types of related information as separate worksheets.
🗑
|
||||
| Worksheet | An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns.
🗑
|
||||
| Workbook Window | In most versions of Excel, Excel workbooks open to the first or most recently used spreadsheet tab. The tabs can be seen at the bottom left of the screen. Clicking on a tab selects a new spreadsheet within the workbook for viewing and editing.
🗑
|
||||
| Cell | In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a vertical column and a horizontal row.
🗑
|
||||
| Sheet Tab | A sheet, sheet tab, or worksheet tab is the current worksheet that is being displayed.
🗑
|
||||
| Active Worksheet | In a spreadsheet program such as Excel or Google Spreadsheets, the active sheet is the worksheet you are working on.
🗑
|
||||
| Workspace | A term used by software vendors for applications that allow users to exchange and organize files over the Internet.
🗑
|
||||
| Columns | Columns are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. Columns run vertically in a worksheet.
🗑
|
||||
| Rows | Rows run horizontally in an Excel worksheet. Each row is identified by a number in the row header.
🗑
|
||||
| Headings | The column header is the colored row of letters used to identify each column within the sheet, or workbook. The column header row is located above the row one.
🗑
|
||||
| Cell Reference | A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
🗑
|
||||
| Name Box | You define a name by using the: Name box on the formula bar this is best used for creating a workbook level name for a selected range. Create a name from selection you can conveniently create names from existing row and column labels.
🗑
|
||||
| Formula Bar | The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function, or data in a cell.
🗑
|
||||
| Formula | Formulas are self-defined instructions for performing calculations. In contrast, functions are pre-defined formulas that come with Excel. In either case, all formulas and functions are entered in a cell and must begin with an equal sign '='.
🗑
|
||||
| Relative Reference | By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2
🗑
|
||||
| Absolute Reference | Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.
🗑
|
||||
| Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row.
🗑
|
||||
| Active Cell | Alternatively referred to as a cell pointer or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet. It helps identify what cell is being working with and where data will be entered.
🗑
|
||||
| Enter Data | The process of entering data into a computerized database or spreadsheet. Data entry can be performed by an individual typing at a keyboard or by a machine entering data electronically.
🗑
|
||||
| Range | A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border.
🗑
|
||||
| Gridlines | Worksheet gridlines are the lightly-colored horizontal and vertical lines that appear around cells in a worksheet. These gridlines are used to define the boundaries of cells, columns, and rows in a worksheet.
🗑
|
||||
| True or False: Each rectangular box in a worksheet is referred to as a cell. | True
🗑
|
||||
| True or False: Gridlines are not used to define the boundaries of cells, columns, and rows in a worksheet. | False
🗑
|
||||
| True or False: You define a name by using the: Name box on the formula bar. | True
🗑
|
||||
| True or False: Data entry can be performed by an individual typing at a keyboard or by a machine entering data electronically. | True
🗑
|
||||
| True or False: Active Worksheet: Is the worksheet that you do not currently have selected. | False
🗑
|
||||
| True or False: A range is a group or block of cells in a worksheet that have been selected or highlighted. | True
🗑
|
||||
| True or False: When cells are selected they are surrounded by an outline or border. | True
🗑
|
||||
| True or False: An Excel worksheet is a single file containing several different types of related information as separate worksheets. | False
🗑
|
||||
| True or False: Rows run vertically in an Excel worksheet. | False
🗑
|
||||
| True or False: Workspace is a term used by software vendors for applications that allow users to exchange and organize files over the Internet. | True
🗑
|
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:
jpferrer670
Popular Computers sets