Excel Terms
Help!
|
|
||||
|---|---|---|---|---|---|
| Spreadsheet | used for storing, organizing and manipulating data
🗑
|
||||
| Workbook | A spreadsheet program file that you create in Excel, contains worksheets of rows and columns in which you can enter and calculate data.
🗑
|
||||
| Worksheet | a single spreadsheet that contains cells organized by rows and columns
🗑
|
||||
| Workbook Window | a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.
🗑
|
||||
| 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 | appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its color
🗑
|
||||
| Active Worksheet | The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.
🗑
|
||||
| Workspace | space in which to work
🗑
|
||||
| Columns | labeled by letters
🗑
|
||||
| Rows | labeled by numbers
🗑
|
||||
| Headings | is the colored row of letters used to identify each column within the sheet, or workbook
🗑
|
||||
| Cell Reference | The set of coordinates that a cell occupies on a worksheet
🗑
|
||||
| Name Box | Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object.
🗑
|
||||
| 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.
🗑
|
||||
| Relative References | 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.
🗑
|
||||
| Absolute Reference | Identifies the location a cell or group of cells and are used in such things as formulas, functions, and charts, consists of the column letter and row number used in a regular cell reference but both letter and number are preceded by dollar signs.
🗑
|
||||
| Mixed Reference | a combination of relative and absolute cell references
🗑
|
||||
| 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 | process of entering data in a cell in a worksheet
🗑
|
||||
| True or False Columns are labeled by numbers | False
🗑
|
||||
| True or False A 'Mixed Reference' is a combination of relative and absolute cell references. | True
🗑
|
||||
| True or False A 'Spreadsheet' is used for storing, organizing and manipulating data. | True
🗑
|
||||
| True or False A 'Cell' is the set of coordinates that a cell occupies on a worksheet | False
🗑
|
||||
| True or False A 'Cell Reference' is the set of coordinates that a cell occupies on a worksheet. | True
🗑
|
||||
| True or False Rows are labeled by numbers | True
🗑
|
||||
| True or False An 'Active Worksheet' is the sheet that you're working on in a workbook. The name on the tab of the active sheet is bold. | True
🗑
|
||||
| True or False A 'Cell' is the colored row of letters used to identify each column within the sheet, or workbook | False
🗑
|
||||
| True or False A 'Heading' is the colored row of letters used to identify each column within the sheet, or workbook | True
🗑
|
||||
| True or False A 'Worksheet' is space in which to work | 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:
eunice_viray
Popular Computers sets