Wednesday, November 12, 2008

lesson 3

1. Absolute reference:A cell reference in an Excel formula that dosen't change when you copy the formula to another cell range.

2. Arguments:Inputs such as numbers,text,cell references, or logical values that are used in Excel functions to perform calculations.

3. AutoFilter:An Excel feature that enables you to apply a fliter to a list in order to display a subset of data.

4. Discussion comments:Comments that are displayed with an Excel workbook stored on a discussion sever.

5. Discussion server:A computer that stores discussion comments.

6. Fill handle:In Excel, the small, clack aquare located in thelower-right corner of selected cell or range that you can use to copy a value or formula to adjecent cells.

7.Filter:In Excel, a feature that allows you to display a subset of in a list on a worksheet.

8. Formula Bar: The long white bar above the column headings in a Excel worksheet that you can use to enter or edit cell data.

9. Function:A perdefined formula in Excel that performs a specific, built in operation.

10.Relative reference:In Excel a cell reference ina formula that automatiocally adjust to the new location when you copy the formula to another cell or range.

11.Syntax:The structure for entering functions and commands, including spelling,punctuation, and acceptable keywords.

12.thread:

13Wizard:

No comments: