Wednesday, May 26, 2010

Slide Show view

The slide show view allows you to see your work on PowerPoint in big screen in a presentation.

Exit effect

An exit effect is the effect that would appear last when the slide show is all done.

Transitions

Transitions are the effects you may put on a slide show when you switch to a different slide.

Slide Sorter view

Slide sorter view shows thumnail versions of your slides in a horizontal row.

Slide Master

Slide master is part of the design template where it tells you the information on the template.

Slide layout

A slide layout allows you to choose which layout you would want to use to view the presentation.

Slide Finder

A slide finder is a way that allows you to find old slides and reuse them.

Slide design

The slide design are a way to make your presentation stand out more and bring more attraction, to not make it plain.

Presentations

Presentations are where you are able to present the PowerPoint into a sideshow for everyone else to see your finished work.

Placeholders

Placeholders are figures which are dotted bordered boxes which show up when a new slide is created.

Normal view

The normal view is the way you view the presentation in PowerPoint.

Clip Organizer

Clip Organizer allows you to arrange clip art and other media files in PowerPoint.

Tuesday, May 25, 2010

Gantt Chart

A Gantt chart is a diagram with bars that represent the start and the finish. This allows you to now what is needed to be done.

Monday, May 17, 2010

Statistical functions

Statistical functions find out the mean, median, mode, and range.

Relative cell

Relative cell reference is the default of the spreadsheet where the formula or function that is copied or pasted to other cells, the cell reference in the formula or function would change to be the same as the functions new location on the spreadsheet.

Order of evaluation


Order of evaluation checks the operation if it is correct or not.

Operator

An operator is the operation or function that is being used in the formula.

Operand

Operand is the number or cell reference in the formula.

Mixed cell reference


A mixed cell reference is both absolute and relative cell reference.

Mathematical functions

Mathematical functions are different variety of functions that allow you to do any mathematical formula.

Function formula

A function formula is where you apply a function into the formula that is being used.

Formulas


Formulas in Excel is a mathematical equation used to find the value of the numbers in your spreadsheet.

Embedded chart

Embedded chart is when the chart is placed on the worksheet.

Chart

A chart allows you to put your information from excel into a graphic format.

Argument


Argument are used in functions, they are put in a function between parentheses with the functions name in front.

Absolute cell reference

An absolute cell reference helps you find the location of a cell or a group cells, in a absolute cell reference you place a $ before each letter and number.

Wednesday, May 12, 2010

Mail Merge

To actually use the mail merge you would open the document with the letter written and go to Mailing tab. After clicking that click on start mail merge and select normal word document then selecting step by step mail merge wizard. Then a tab would appear and you first select on letter then next, select use current document then next and select on use existing list. Then you you would browse for the excel document who has the lest of people and the information for them. Select the first sheet #1 and make sure the check box is checked and then more items and select the name and action and then preview letter. Mail merge makes it easier for you when you want to write a letter to more then one person. Or if you were to send an invitation to someone with the same information all you would have to do is use the mail merge and it would for it for you.
Yes I would use the mail merge in the future for a thank you note or invitation telling multiple people the same thing. It is much quicker and easier to do and doesn't take much time to do so, it really isn't hard to do. Mail merge is helpful and you just have to have it organized and make it ready so you can just apply the mail merge to it. Mail merge in my opinion is very much helpful.

Sunday, May 9, 2010

Worksheet


A worksheet is made out of rows and columns which make up the cell; also allows you to enter text, numbers, and formulas into the cell.

Workbook


The workbook is contains one or more worksheets.

Range


The range is when you take the numbers in excel and use the formula to find out the range.

Merge


Merge is where you take the cells in the row and put it as one.

Header Row


Header row is for when you want to separate the rows in different sections and they have thier own name and witha header row the cells each get a filter.

Gridlines


Gridlines are the lines in the worsheet that shows the connection of the row and column.

Wednesday, May 5, 2010

Filling

Filling allows you to apply a color into the cell.

Fill handle


The fill handle lets you copy the data on other cells or to fill the cells next to the cell you are using.

Descending Order


Descending Order is where you sort the cells into largest to smallest.

Cell Reference


Cell reference would infrom you of where the cell or group of cells you are looking for is located.

Ascending order


Ascending order would sort the cells in your worksheet smallest to largest.

Active cell


An active cell would come up when the cell of Excel is clicked on and has a black border around it.