formulas

open jobs

Excel lesson 3 terms

1. Absolute reference- A reference in an Excel formula that dosen't change when you copy the formula to another cell or range.


2. Arguments- Imputs such as numbers, text, cell references, or logical values that are used in Excel functions to perform calculations.


3. Auto filter- 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 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 adjasent 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 loong white bar above the colmn 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 predefined formula in Excel that performs a specific builtin 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.

lesson 2 pg12

Noun:Nouns are often thought of as referring to persons, places, things, states, or qualities.
Verb: tense, aspect, voice, mood, and to show agreement with their subject or object. (action).
preposition:express a spatial, temporal, or other relationship, as in, on, by, to, since.

Lesson 3 key terms

verb sentenses

List of words to lookup and type definitions in a new blog post:
act 1. anything done, being done, or to be done; deed; performance: a heroic act.
active 2. engaged in action; characterized by energetic work, participation, etc.; busy: an active life
add engaged in action; characterized by energetic work, participation, etc.; busy: an active life
analyze 3. To examine carfully and in detail so as to identify causes,key factors,possible results,etc.
answer 4. spoken or written reply or response to a question, request, letter, etc.: He sent an answer to my letter promptly.
approximate 5.nearaproaching a certain state, condition, goal, or standard.
ask 6. toput a question to; inquire of: I asked him but he didn't answer.
apply 7. to make use of as relevant, suitable, or pertinent: to apply a theory to a problem
1.Carry: to contain or be capable of containing; hold
2.Calculate:to make suitable or fit for a purpose
3.Choose: to select from a number of possibilities
4.Classify: to arrange or organize by classes; order according to class.
5.Collect:to gather together; assemble
6.Communicate: to impart knowledge of; make known
7.Compare: to examine (two or more objects, ideas, people, etc.) in order to note similarities and differences
8.Connect:to join, link, or fasten together; unite or bind
9.Construct: to build or form by putting together parts; frame; devise
10.Contrast: to compare in order to show unlikeness or differences; note the opposite natures, purposes, etc
11.Convert:to change (something) into a different form or properties; transmute; transform.