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 |