click below
click below
Normal Size Small Size show me how
Lesson 1
Excel
| Question | Answer |
|---|---|
| workbook | an excel file with one or more worksheet |
| worksheet | the work area for entering and calculating data made up of columns and row separated by grid lines. also called a spreadsheet |
| 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 cell |
| formula bar | as you enter data into a cell, it simultaneously appears in the formula |
| cell reference | the location |
| scroll | a way to view locations on the worksheet without changing the active cell |
| sheet tabs | tabs that appear at the bottom of the worksheet without changing the active cell |
| tab scrolling buttons | buttons that appears just to the left of the sheets 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 |
| Auto Complete, | a feature used to complete an entry based on previous entries entries made in the column containing the active cell |
| autocorrect | order of mathematical operations |
| series | a lists of sequential numbers, data, time,or text |
| label prefix | an apostrophe(') used to indicate that a numbers 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 use ad as a column |
| formula | an instruction excel uses to calculate a number. |
| mathematical operators | symbols used in mathematical operations. |
| order of mathematical operations | the order in which excel performs the calculations specified in a formula. |
| value | a number entered in the worksheet |