Wednesday, May 26, 2010

Transitions


Transitions- Is an effect that is used to play from one slide to another when you are in slide show view over a period of time.

Slide Sorter View


Slide Sorter View- It displays all the slides in a thumbnail view so that you can see all of them easily and move around the slides.

Slide Show View


Slide Show View- It is used to present you slide show for an audience so everything is clear and can be shift from one to the next easily.

Slide Master


Slide Master- Is used to create templates of how you want it took look like. It controls most of the formatting and object placement in a presentation.

Slide Layout


Slide Layout- Are graphics to organize you slide show there is already nine built in layout but you can also create your own to have its own format.

Slide Finder


Slide Finder- It is used to quickly find a specific slide in a powerpoint presentation so that you can simply copy it again to the current slide to make it alot easier.

Slide Design


Slide Design- Are templates that powerpoint already has some of these templates are business template and etc... They are predesign templates you can use to format you slideshow.

Presentations




Presentations- It is a slide view with many slides in it with different information.

Placeholders


Placeholder- It organizes information in the presentation which allows you to format text, image, sounds, and other files to the presentation.

Normal View


Normal View- It is known as a slide view where the slide shown in the full window and it is the main working window in a presentation.

Exit Effect


Exit Effect- It is an animation that you insert into your powerpoint presentation so that when you go to the next slide or when you close the slide it will show an animation motion of an specific one that you choose.

Clip Organizer


Clip Organizer- To insert a movie clip into your powerpoint throught clip organizer from you computer.

Tuesday, May 25, 2010

Gantt Chart


Gantt Chart- It is a type of bar chart that shows information from the tables and is used to show the start date, end/finish date, and the remaining dates or just to show the completion of time your using overtime.

Wednesday, May 19, 2010

Statistical Function


Statistical Function- It is a function that can be entered that does a calculation on 1-2 variables or ranges of numeric values. It accepts range as arguments or a list of ranges is also accepted as an argument.

Relative Cell References


Relative Cell References- It is when a formula that is addressed to certain area that is based on the relative cell that contains the cell or the cell refers to and if you copy the formula the cell automatically adjust to it and shifts a bit.

Order Of Evaluation


Order Of Evaluation- An operator that chooses a specific type of calculation that you want it to perform on the elements of formula. Excel has 4 types of operators which is arithmetic, comparison, text and references.

Operator


Operator- the type of symbols or signs that gives the specific type of calculations for an expression.

Operand


Operand- Its an item on either side of an operator in Excel formula it can be values, cell reference, names, label, etc...

Mixed Cell Reference


Mixed Cell Reference- Cell reference has column letters row numbers that intersect on the cells location in the spreadsheet.

Mathematical Functions


Mathematical Functions- Are functions in Excel used to calculate math equations or formulas only in order to find the value.

Function Formula


Function Formula- Function is a preset formula it also begins with a (=) sign and following behind it is the functions name and a argument. The functions name is used so it can tell excel what type of calculation we are doing.

Formulas


Formulas- Are entered in spreadsheet so that you can enter a mathemetical question to use so that you can find the value. In Excel formulas it must begin with a (=) sign in order for it to count it as a formula and so that it can calculate the value.

Embedded Chart


Embedded Chart- it is a chart that is drawn on the same worksheet as where you data is entered.

Chart


Chart- Are the visual representation of worksheet data and it makes it so that it is easier to understand the datas in the worksheet.

Argument


Argument- Are the cell references usually or the range in which is closed in parenthesis following the functions name. Arguments are often used in functions.

Absolute Cell Reference


Absolute Cell Reference- Is a formula used in a spreadsheet and doesn't change when the formula is being copied or moved.

Wednesday, May 12, 2010

Steps For Mail Merge

1. Click on Mailing on the ribbon.
2. Click start Mail Merge.
3. Select Normal Word Document.
4. Do steps 1-2 and this time select Step By Step Mail Merge Wizard.
5. It would then appear a Mail Merge task pane on your right you then select the document type in this case we select Letters.
6. Click Next.
7. Select Starting Document in our case we select the first one which is Use The Current Document.
8. Click Next.
9. Select Recipient, in our case we select Use An Existing List.
10. Click Browse.
11. You go and find the Excel page with the Names and Action in our case or which ever document you want to use.
12. Make sure to select sheet 1.
13. Make sure that at the bottom of this window on the left corner that the little box is check.
14. Click OK.
15. Select the entire Names and Actions on this sheet.
16. Click OK.
17. Click Next.
18. Select the area where your going to change the recipient in our case we select whatever is after Dear.
19. Once you select it click on More Items.
20. Then replace it with Names.
21. Then you go to the next line and whatever you put for the actions you select it.
22. Click on More Items once again.
23. Then replace it with Actions.
24. Click Next.
25. Preview your Letter to test it out with all the different recipients that you inserted.
26. Click Next.
26. You can now Print or Edit Indiviual Letters.
We can use this in many other ways one way is so that in the future if your company were to write a letter to many people but then you don't want to change the name for every letter this way it would save time. So you can change all the names with the Mail Merge and you can print very easily from the pages that you want to another.

Monday, May 10, 2010

Worksheet


Worksheet- Is a spreadsheet where you have many cells and you can keep and change the data where you work with the worksheet.

Workbook


Workbook- Is where you enter and stored related data. Many worksheets makes up a workbook.

Range


Range- A data entry that have a group of value from minimum to maximum. A group of cells that are worked as a group, it can be a row or column or the rectangular block defined on one corner and the opposite side of the corner.

Merge


Merge- When you have 2 or more cells in Excel you combine them so that it can merge together into one.

Thursday, May 6, 2010

Header Row


Header Row- It is to show us and to identify the rows of each column and is used to identify the columns name and reference.

Gridlines


Gridlines- Are the lines that divide each and everyone of the cells, rows and columns on the spreadsheet.

Filling


Filling- It is when you have anything in a cell and instead of writing it manually from cell to cell you can use auto fill by using the fill handle to drag from one area to another and the rest of the cells in between would be auto filled. Usually this only works with numbers in order like 1,2,3...

Wednesday, May 5, 2010

Fill Handle


Fill Handle- Is when you activate a cell or a selected number of cell on the bottom right corner that is the filled handle. You then drag the fill handle everything in that cell would be copied to the area that you drag the fill handle to.

Descending Order


Descending Order- Is when you have numbers from Largest to Smallest or sort from Z-A.

Cell Reference


Cell Reference- Are the content of the cell or value that is needed to solve problems/formula on the spreadsheet.

Ascending Order


Ascending Order- Ascending Order is when you have the smallest number to the largest or from A-Z.

Active Cell


Active Cell- The cell on the spreadsheet in Excel that shows which cell you are currently on or is currently activated. It is highlighted by the cell pointer when it is modified.

Monday, April 26, 2010

Thumbnails


Thumbnails is a small image of the picture to see what it is and how it looks like before you decide wether if you want it or not.

Thesaurus


Thesaurus is when you have a word that has the synonyms and antonyms of that word in the text or in a word in general.

Template


Template is a charcterized document type that is created by word. Templates has information about paragraph style etc...

Superscript


Superscript is a number or a simple that is raised to the top right side of the text or word usually smaller then the normal text size.

Graphics


Graphics is a visual presentation that is in word or a photograph.

Footnotes


Footnotes is a short explaination in a citation that has the source of information.

Footer


Footer is the area at the bottom of the document that will have a text that is going to appear on every page usually this area is used for page numbering.

Endnotes


Endnotes is like a list of citations where it is used to explain a chapter or is at the end of a document.

Drawing Objects


Drawing Objects is when an object that can be edit or is created in word.

Style


Style is when you characterize in word a selected paragraph or a selected text ot character and you style it.

Sizing Handles


Sizing Handle is when you resize the window or when you have images in word or text you can resize the object to bigger or smaller by using the sizing handle.

Header


Header is the area on top of the document that will have text that will appear on the document page usually the headers are used for page number, document title and authors name etc...