click below
click below
Normal Size Small Size show me how
Excel Vocab
Excel Vocabulary and True or False
| Term | Definition |
|---|---|
| Spread Sheet | computer program that stores, analyzes, and organizes, date in tabular form |
| Workbook | another word for excel file |
| Worksheet | collection of cells that keeps and manipulates the data |
| cell | the point where vertical columns and horizontal rows intersect |
| sheet tab | the current worksheet that is being displayed |
| active worksheet | worksheet that is currently being worked on |
| workspace | a group of workbooks |
| columns | vertical series of cells in a chart |
| rows | horizontal series of cells in a chart |
| headings | rows that contains letters that shows the locations of the cells |
| cell reference | the location-based cell in a spreadsheet that consists of a column letter and the row that intersects at the cell's location |
| name box | box located left of the formula bar that shows the cell that is currently selected in the spreadsheet |
| formula bar | bar that displays the contents of the current cell and creates/views formulas |
| formula | expression that ells the computer which mathematical operation should be performed upon a specific value |
| relative reference | cell reference that reflects the function's new location |
| absolute reference | cell reference that does not change when a formula or function is copied to other cells |
| mixed reference | cell reference that is a combination of relative and absolute reference |
| active cell | rectangular box that highlights the cell |
| enter data | click on cell and enter data |
| range | group of cells in a row or a column |
| gridlines | light gray lines that divide cells, rows, and columns |
| Numbers are used as column headings. | False |
| An equal sign is needed to begin a formula. | True |
| Microsoft Excel provides a spelling checker. | True |
| Absolute cell references are indicated with a # sign. | False |
| Once a chart is made, it cannot be edited. | False |
| The name of the worksheet can be renamed. | True |
| An extra column/row cannot be added or removed. | False |
| You are able to change the data after you form a chart. | True |
| Excel automatically calculates the data. | True |
| Texts cannot be added in a chart. | False |