Fundraiser

Tax on goods

Homesold.xls

Budget.xls

Saleconsolidation2

Saleconsolidation

Leasinginfo.xls

Qtr2Sales

SalesCharts

LoanComparsion

QtrSales

TenantsSpace

Formulas

Job opennings

Excel Lesson 3 terms

1. Absolute reference- A reference to a cell in another Excel worksheet within a workbook that includes the sheet name as part of the reference.
2. Arguments- Input such as numbers, text, cell reference,or logical values that are used in Excel functions to perform calculations.
3. AutoFilter- An Excel fearture 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 fearture 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 an 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 predenfined formula in Excel that performs a specific, builtin operation.
10. Relative reference-
11. Syntax- The structure for entering functions and commands, including spelling, punctuation, and acceptable keywords.
12. Thread- A set of discussion comments and reponses that are grouped and displayed in hierarchical order.
13. Wizard- An automated tool that helps you perfprm a task by presenting step-by-step contents 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. A cell contains information such as text, numbers, or grappics.

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

4. Find- A command that searches for specified text and/ or formatting in a document.

5. Formula-In Excel, a cell entry that performs calulations.

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 replaces it with new text and/ or formatting that you specify.

9. Row- In Excel, a horizontal line of cells identified by a row 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 page in an Excel workbook.