Colege Buget3

Order of operations

Payroll 3

Qtr2 Sales

Sales Charts

Loan Comparison2

Loan Comparison

Tenant Space

Qtr1sales

Job openings

Excel Lesson 3 Terms

1. Absolute Refrence-A cell reference in an Excel formula that doesn't change when you copy the formula to another cell or 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 applya filter to a list in orded to display a subset of data.
4. Discussion comments-Comments that are displayed with an Excel workbook but stored on a discussion server.
5. Discussion Server-A computer that stores discussion comments.
6. Fill handle-In Excel, the small, black square located in the lower-right corner of a selected cell or range that you can use copy a value or formula to adjacent cells.
7. Filter-In Excel, a feature that allows you to display a sebset of data in a list on a worksheet.
8. Formula Bar-The long white bar above the column headings in an Excel worksheet that you can use to enter or edit cell data.The formula displays the contents of the active cell.
9. Function-A predefined formula in Excel that performs a specific, built in operation.
10. Relative reference-In Excel, a cell reference in a formula that automatically adjusts 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-A set of discussioms comments and responces that are grouped and displayed in hierarchical order.
13. Wizard-An automated tool that helps you perfomrm a task by presenting step-by-step content and organization choices.