Jt- Tax on Goods

Jt- College Budget

If my budget was short, I could cut back on a few expenses or find more income sources so that I would have more money.

All the files on 3/2/09

Jt- Sales Charts | Jt- Qtr2 Sales | Jt- Loan Comparison2 | Jt- Web Page

Jt- Tenant Space | Jt- Qtr1 Sales | Jt- Loan Comparison

Jt- Formulas | Jt- Job Openings

Excel Lesson 3 Terms

1. Absolute reference - 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 apply a filter to a list in order 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 to copy a value or formula to adjacent cells.
7. Filter - In Excel, a feature that allows you to display a subset of data 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. The formula Bar 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 discussion comments and responses that are grouped and displayed in hierarchical order.
13. Wizard - An automated tool that helps you perform a task by presenting step-by-step content and organization choices.

Excel Vocab

1. Active Cell-In Excel, the cell that is currently selected.
2. Cell-A cell is the intersection of a row and a column in a table or worksheet. It contains information such as text, numbers, or graphics.
3. Column-A vertical line of cells identified by an alphabetic label at the top of the column.
4. Find-The Find command allows you to search for specified text and/or formatting in a document.
5. Formula-In Excel, a cell entry that performs a calculations..
6. Label-A text entry in an Excel worksheet.
7. Range-A cell or group of cells that can be selected in an Excel worksheet.
8. Replace-A command that searches for specified text and/or formatting in a document and replace it with new text and/or formatting that you specify.
9. Row-In Excel, a horizontal line of cells identified by a number at the left end of the row.
10. Value-A numeric entry in Excel.
11. Workbook-An Excel file that can contain up to 256 worksheets.
12. Worksheet-A worksheet is a page in an Excel workbook
13. Freeze Panes-An Excel feature that enables you to freeze rows and columns that are above and to the left of the selected cell so that they remain fixed while scrolling the worksheet.
14. Print Titles-Repeated row or Column that appear on each page of a printed Excel worksheet.