click below
click below
Normal Size Small Size show me how
Lesson 1
Excel
| Term | Definition |
|---|---|
| Workbook | An Excel file with one or more worksheet. |
| Worksheet | The work area for entering and calculating data made up of columns and rows separated by grid lines (light gray lines). also called a spread-sheet |
| cell | The intersection of a column and a row on a worksheet. you enter data into cells to create a worksheet. |
| active cell | the active cell contains the cell pointer.there is a dark outline around the active the active cell |
| formula bar | as you enter data into a cell it simultaneously appears in the formula bar, which is located above the worksheet |
| cell reference | the location of a cell in a worksheet as identified by its column |
| scroll | A way to view location on the worksheet with-out changing the active cell |
| sheet tabs | tabs that appear at the bottom of the workbook window, which displays the name of each worksheet. |
| tab scrolling buttons | buttons that appear just to the left of the sheet tabs, which allow you to scrool hidden tabs into view |
| label | text in the first row or column of a worksheet that identifies the type of data contained there |
| defaults | the standard settings Excel uses in its software, such as column width or number of work-sheets in workbook |
| AutoComplete | a feature used to complete an entry based on previous entries made in the column containing the active cell |
| autocorrect | a feature used to automate the correction of common typing errors |
| value | a number entered in the worksheet |
| series | A list of sequential numbers, dates,times, or text. |
| label prefix | An apostrophe (') used to indicate that a number is a label and not a value. |
| numeric label | A number entered in the worksheet as a label, not as a value such as the year 2005 used as column |
| formula | An instruction Excel uses to calculate a number |
| mathematical operators | symbols used in mathematical operation: + for addition - for subtraction, * for multiplication,/for division, and ^ for exponentiation |
| order of mathematical operations | the order in which excel performs the calculations specified in a formula |