click below
click below
Normal Size Small Size show me how
Excellent Excel
Stuff
| Term | Definition |
|---|---|
| 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. |
| Workbook | a single file containing different types of information as separate worksheets |
| Worksheet | a data file created and used by a spreadsheet program, which takes the form of a matrix of cells when displayed |
| workbook | the window which displays which workbook you are currently working on |
| cell | a field in a spreadsheet in which you can input data that is usually text, a numeric value, or a formula. |
| sheet tab | the current worksheet being displayed |
| active worksheet | a single spreadsheet that contains cells organized by rows and columns. |
| workspace | group of workbooks |
| columns | cells that run vertically |
| rows | cells that run horizontally |
| headings | the colored row of letter or numbers that identify each column or row on the sheet. |
| cell reference | it refers to a cell or range of cells on a worksheet and can be used in a formula. |
| Name Box | the box left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
| Formula bar | a toolbar at the top of the Microsoft excel spreadsheet window that you can use to eo enter or copy an existing formula in to cells or charts. |
| formula | self-defined instructions for performing calculations |
| relative reference | a cell in a spreadsheet that is a location based cell reference |
| absolute reference | a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. |
| mixed reference | it is either an absolute and relative row or absolute row and relative column |
| active cell | a cell in spreadsheet that is currently selected |
| enter data | ways to put information and save them on excel |
| Range | the term used for the cells selected. |
| gridlines | lines that define the boundaries of cells, columns, and rows in a worksheet |
| T or F:you can print more than one sheet on a single page | True |
| T or F:You can change the data in your chart after creating it | True |
| T or F:You have to manually do your own calculations | False |
| T or F:You have to manually type down formulas | False |
| T or F:You cannot create borders on your data | False |