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 row on a work sheet. 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 bar, which is located above the worksheet. |
Cell refrences | the location of a cell in a worksheet as identified by its column letter and row number. Also know as the cells 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 used in its software, such as column width or number of worksheet in a workbook. |
AutoComplete | A feature used to complete an entry based on previous entries made in the column containig 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 work sheet 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. |