click below
click below
Normal Size Small Size show me how
Excel - Lesson 1
| 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 by gridlines (light gray lines). Also called a spreadsheet |
| Cell | The intersections 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 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 letter and row number. Also known as the cell's address. |
| Scroll | A way to view locations on the worksheet without changing the active cell. |
| Sheet Tabs | Tabs that appear at the bottom of the workbook window, which display the name of each worksheet. |
| Tab Scrolling Buttons | Buttons that appear just to the left of the sheet tabs, which allow you to scroll 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 worksheets in a 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 a column label. |
| Formula | An instruction Excel uses to calculate a number. |
| Mathematical Operators | Symbols used in mathematical operations: + 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. |