Unit 2, lesson 1 key terms

column index- The column number in the table array from which the matching value must be returned when using a LOOKUP function.



comment- Text in Visual Basic added to code that explains how the code works. It begins with an apostraphe.



conditional formatting- A format such as cell shading or font color, that Excel automatically applies to a cell or group of cells if a specified condition is true.



custom filter- A list taken from within a larger list where the only records shown are the rows that meet the criteria you specify for a column.



data list- A series of worksheet rows that contain related data. The first row of the list has labels for the columns.



document element- The top most element in an XML file; it is used to name the table when imported into an application.



end-tag- The tag that specifies the end of an elemint; it is case-sensitive. For example, is an end-tag for the Name field.



export- To use data in another program



extensible markup language- A format for delivering rich, structured data from an application in a standard, consistent way.



filter- A list taken from within a larger list where the only records shown are the rows thhat meet the ctiteria you choose from a stop-down list for a column.



HLOOKUP- A function that searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table.



import- To use data from another program.



interactive data- A HTML file that contains special components that allow browser users to interact with the workbook.



Lookup value- The balue to be found in the first molum nof the table array when using a LOOKUP function.



named range- A word or string of characters that represent a cell, tange of cells, formula, or constant value.



processing statement- A statement in XML format that provides additional application-specific information about the document; it begins and ends with a question mark.



start-tag- The tag that begins an XML statement;



static data- Sata appears as it would in Excel, including tabs that users can click to switch between worksheets; however, users cannot change or interact with the data in the browser.



table array- The table of information in which data is looked up when using a LOOKUP function.



VLOOKUP- A function that searches for a value in the left most column of a table.



World Wide Web Consortium- a consurtion of commercial and educational institutions that oversees research and promotes standards in all areas related to the world wide web.

My house

This is my batchelor pad. My house was too hard to try to make so I just put my batchelor pad for my house.

Lesson 5 Customizing Word

1. Macros- Very large in scale, or capability.

2. Menus- A list of available options, especialy as displayed on a screen.

3. Record Macro- A feature on the Tools menu that allows you to name and record a series of commands for a macro.

4. Toolbars- A row of icons on a computer screen that activate commands or functions when clicked.

5. Visual Basic Editor- A program within Word and Excel that allows you to edit or delete the commands in a macro.

WEEK #7 TERMS

Carry: To wear,hold, or have around one.
Calculate: To determine or ascertain by mathematical methods.
Choose: To prefer or decide.
Classify: to arrange or organize by classes, order according to class.
Collect: To gather together, assemble.
Communicate: To impart knowledge of, to make known.
Compare: To consider or describe as similar.
Connect: To establish communication between; put in communication.
Construct: To build or form by putting together parts; frame; devise.
Contrast: To exhibit unlikeness on comparison with something else; form a contrast.
Convert: To cause to adopt a different religion, political doctrine, opinion.

Reflection

Noun-The part of speach that is used to name a person,place,thing,quality, or action and can function as the subject or object of a verb, the object of a preposition,or an appositive.
Verb- The part of speach that expresses existance,action, or occurance in most languages.
prepositions- A word or phrase placed typically before a substantive and indicating that substantive to a verb.

Terms week#6

Act: To perform in or as if in a play; represent dramatically; act out a story.
Active: To make active; cause to function or act.
Add: To say or write further
Analyze: To examine carefully and in detail so as to identify causes; key factors; or possible results.
Answer: To speak or write in response;make answer; reply.
Approximate: To come near to; approach closely to
Ask: To make inquiry;inquire
Apply: To put in effect

Lesson 1&2 Vocab

Clip Art Gallery: A collection of clip art graphics available through the insert Cip Art task pane.

Drawing toolbar: A toolbar with buttons for inserting pictures and drawing many different types of objects.
Section breaks: A break in a document that you can format differently than previous and following sections.
Styles: Collections of rext and paragraph formatting commands that can be applied to text throughout a document.
Text box: A feature available on the Drawing toolbar that allows you to input text in a box anywhere in a Word Document, incuding over graphics.
Window/Orphancontrol: An orphan is the first line of a paragraph printed alone at the bottom of the page. A widow is the last line of a paragraph that is printed alone at the top of a new page.
Word Art: A feature available from the drawing tools that creates words with different shapes and colors.
Bookmark: A marked location in the text of a Word document that can be returned to quickly through the Bookmark dialoge box.
Cross-reference: An index entry that refers to another index entry.
Document map: A pane that can be displayed on the left side of the screen that lists and links to the headings in a document so that a reader can jump to different sections by clicking the links.
Endnote: A reference or citation at the end of a document.
Footnote: A reference or citation at the bottom of a page in a document
Index: A list of subjects, terms, names, titles, and other items and corrresponding page numbers at the end of a document.
Master Document: A document made up of subdocuments.
Outline Level: Aplace on the outline heirarchy shown in the Outline view.
Outline view: One of the display options available from the Biew menu that shows different levels of text in a dacument.
Subdocument: A patr of a set of documents that are linked to and make up a master document.
Table of contents: A list of the major headings and corresponding page numbers in a document displayed at the beginning.

Wonderful Me!

1. Name: Chaz Grumbles
2. I was born in Austin TX
3. I have lived in this town/city for 13 years
4. I have also lived in the following states and/or countries: Arizona for 3 years
5. I have 2 sisters and no brothers
6. I live with my parents
7. My favorite subject in school is history
8. I like to read books about fictional stories
9. My special interests, activities, hobbies are running and going to the gym
10. The one thing I enjoy doing more than anything els in the whole wide world is eating
11. If I were going to set one goal for myself this year, it would be to graduate
12. My most valuable material possession is my car
13. My most valuable non-material possession is my relationship with my family