click below
click below
Normal Size Small Size show me how
Excel Vocabs
Term | Definition |
---|---|
1. 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. |
2. Workbook | a single spreadsheet that contains cells organized by rows and columns. |
3. Worksheet | a collection of cells where you keep and manipulate the data. |
4. Workbook window | minimize/maximize options appear immediately below these Excel Window options, if the workbook window is maximized. |
5. Cell | a box formed by the intersection of a row and column in a worksheet or table, in which you enter information. |
6. Sheet tab | the different worksheets in a workbook. |
7. Active worksheet | the sheet that you’re working on in a workbook. |
8. Workspace | a file that saves display information about open workbooks. |
9. Columns | labeled by letters; runs vertically. |
10. Rows | labeled by numbers; runs horizontally. |
11. Headings | the colored row of letters used to identify each column in the sheet or workbook. |
12. Cell reference | the set of coordinates that a cell occupies on a worksheet. |
13. Name box | box at the left end of the formula bar that identifies the selected cell, chart item, or drawing object. |
14. 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. |
15. Formula | a sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. |
16. 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. |
17. Absolute reference | remain constant, no matter where they are copied. |
18. Mixed reference | either an absolute column and relative row or absolute row and relative column. |
19. Active cell | the selected cell in which data is entered when you begin typing. |
20. Enter data | information that is stored in any spreadsheet program. |
21. Range | two or more cells on a sheet. |
22. Gridlines | lines you can add to a chart that makes it easier to view and evaluate data. |