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.

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.

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.

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.

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.

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...

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.