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.

Highlighting Is Helpful

An Adjective describes a noun, while an adverb describes the Adjective.

Formatting Fun

Noun- any member of a class of words that are formally distinguished in many languages, as in English, typically by the plural and possessive endings and that can function as the main or only elements of subjects or objects.

Verb- any member of a class of words that are formally distinguished in many languages, as in English by taking the past ending in -ed, that function as the main elements of predicates, that typically express action, state, or a relation between two things, and that (when inflected) may be inflected for tense, aspect, voice, mood, and to show agreement with their subject or object.

Prepostion- A word or phrase placed typically before a substantive and indicating the relation of that substantive to a verb, an adjective, or another substantive.

Lesson 3 Word Terms

1.Cell – The Intersection of a row and a column in a table or worksheet.

2.Character Effect – A special effect that can be applied to individual characters of text.

3.Chart – A type of graphic that visually presents numerical data.

4.Clip Art – An image that is ready to add to a document.

5.Datasheet – In Access, data displayed in a row-and-column format in a table, query, or form.

6.Diagram – A type of graphic that visually presents conceptual information rather then numerical data.

7.Highlight – A colored background applied to a selected text.

8.Landscape Orientation – a page orientation in which text is printed across the wider dimension of the page.

9.Margin – Blank space along the edge of a page where text is not printed.

10.Merge – In Excel, an action that combines selected cells into a single cell.

11.Organization Chart - A diagram that visually presents the structure of departments or personnel in an organization.

12.Portrait Orientation- A page orientation in which text is printed across the shorter dimension of the page.

13.Split - 1. In Word, an action that divides a single table cell into two or more smaller cells.
2. In Excel, an action that returns a merged cell back into individual cells.

14.Table - 1. In Word, a grid made up of horizontal rows and vertical columns that is used
to order certain types of information.
2. In Access, a collection of data with the same subject or topic.

15.Text Effect - A special effect that can be applied to one or more characters of text.