click below
click below
Normal Size Small Size show me how
Excel
Vocab
| Term | Definition |
|---|---|
| Spreadsheet | also called a workbook |
| Workbook | made up of three worksheets |
| Worksheet | a grid of cells consisting of 65,536 rows by 256 columns |
| Workbook Window | a single spreadsheet that contains cells organized by rows and columns |
| Cell | is an intersection of a column and row |
| Sheet Tab | the current worksheet that is being displayed |
| Active Worksheet | the sheet that you are working on in a workbook |
| Workspace | a file that saves display information about open workbooks. So that you can later resume work with the same window sizes, print areas, screen magnification, and display settings |
| Columns | each excel spreadsheet contains 256 columns. Each column is name by a letter or a combination of letters |
| Rows | Each spreadsheet contains 65,536 rows. Each row is named by a number. are referenced by numbers that appear on the left and then run down the Excel screen |
| Headings | the title at the head of the page |
| Cell Reference | the set of coordinates that a cell occupies on a worksheet |
| Name Box | the formula bar that is used for creating a workbook name |
| Formula Bar | A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts |
| Formula | used to perform calculations on values entered and stored in the program |
| Relative Reference | changes in position of rows and columns |
| Absolute Reference | rows and columns stay the same |
| Mixed Reference | it is either an absolute column and relative row or absolute row and relative column |
| Active Cell | the cell that receives the data or commands you to give it |
| Enter Data | information that is stored in any spreadsheet program such as Excel and Google worksheets |
| Range | a group of selected cells |
| Gridlines | Faint lines that divide cells |