Tax On Goods

Grade Averages

Tax Information

Budget

Home Sold

Itinerary

Sales Consolidation2

Sales Conosidation

Leasing info

College Budget

College Budget 4

SalesData2

Payroll3

College_Budget3

Order_of_Operations

Payroll2

ExpenseSummary2

Expense Summary2

TenantSpace

Qtr2Sales

Qtr1Sale

Loan comparison1

Loan comparison2

Sales chart

Job Openings

Excel Lesson 3

1. Absolute Reference:A cell reference in an Excel formula that dosen't change when you copy the formula to another cell or range.
2. Arguments:Inputs such as numbers, text,cell reference, 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 sever.
5. Discussion Server:A computer that stores discussion comments.
6. Fill handle:In Excel, the small, black square lacated 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 future 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 heading in an Excel worksheet that you can use to enter or edit cell data.
9. Function:A predefined formula in Ecel that performs a specific, built in operation
10. Relative Reference:In Excel a cell reference in a formula that automatically adjusts to 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 acceptale keywords.
12. Thread:A set of discussion comments and responses that are grouped and displayed in hierarchical.
13. Wizard:Wn 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:The intersection of a row and a column in a table or worksheet.

3. Column:A vertical line of cells identified by an alphabetic lable at the top of the column.

4. Find:A command that searchs fro speciefd text and/or formatting in a document.

5. Formula:In , a cell entery that performs calculations.

6. Label:A text entery 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 tex and /or formatting in a document and repalce it with new text and/or formating that yo specify.

9. Row:In Excel a horizontal line of cells identified by a row nember at the left end of row.

10.Value:A numeric entery in Excel.

11. Workbook:An Excel file that can contain up to 256 workshets.

12. Worksheet :A page in an Excel workbook.


13. freeze panes :An Excel feature that enable you to freeze rows and columns that are above and to the left.

14. print titles :Repeated row or colunm lables that appear on each page of a printed Excel worksheet.