Wednesday, May 26, 2010

Clip Organizer


The Clip Organizer is a tool useful in Microsoft PowerPoint, when users want to insert preset media into their Slide Presentation. Data is categorized into audio, pictures, or videos, and makes it easier for users to find these files, instead of having to perform long searches for them on a computer.

Exit Effect


The Exit Effect is a custom effect that users can apply to a PowerPoint Presentation, for the closure of their presentation. This effect is added on the last slide, and can involve audio such as clapping, the screen fading, or etc.

Placeholders


Placeholders are small boxes found in the slides of the presentation program Microsoft PowerPoint. The purpose of the Placeholders is so that text and titles can remain in place, and in a certain spot of the slide layout.

Presentations


In Microsoft PowerPoint, a presentation is a display of data and text in the form of a slide show. Each slide has its own unique background, color, data, font, graphics, and effects such as a transition. Once a group of slides have been created and edited to match a corresponding topic, a Presentation has been created and is ready for display.

Slide Design


The Slide Design is the default slide used for a PowerPoint presentation after a master slide has been placed. The Master slide includes the graphics, background, and fonts that will be used, and this slide design can be repeated with all other slides that follow the Master Slide.

Slide Finder

There are many circumstances in which a PowerPoint user is found in a situation where they need to reuse a specific slide. Thanks to the PowerPoint finder tool in Microsoft PowerPoint, users can save a copy of their desired slide, and the Finder will locate it, allowing that slide to be reused over and over.

Slide Layout


In a PowerPoint presentation, users can have a background for their Slide text, they can have it in a specific arrangement, with a text size or font, and graphics. This is known as the slide Layout.

Slide Master


The Slide Master is the process which creates slides and layouts by arranging and creating the fonts, colors, and graphics. The Slide Master can be accessed in any case that the users would like to make changes to the layout for all slides, or just an independent slide.

Slide Show View


Once you have completed a PowerPoint presentation, or you just want a preview of a current slide, you can access the Slide Show Viewer. The Slide Show Viewer is a feature that allows you to view the effects such as sound effects, animations, transitions, and any other customization that you have made for your presentation.

Slide Sorter View


In Microsoft PowerPoint the Slide Sorter View is a feature in which miniature versions of all PowerPoint slides are presented side by side. You can click on any of these slides so that you can see it in normal view, or you can change the arrangement and order of your slides.

Transitions


Microsoft PowerPoint has a presentation feature known as a transition. A transition is a visual movement used to switch from one slide to another.

Tuesday, May 25, 2010

Gantt Charts

A Gantt Chart is just one in many charts that computer users can create using the program Microsoft Excel. This chart comes in very useful when users want to present an arrangement of data such as the performance of several tasks over time. Gantt Charts can be created once users have data that includes a Start Date, numerical data for Completion, and numerical data that is Remaining. Then, by using the chart wizard, you have to create a stacked bar chart, format the axis, and when formatting the x axis, you have to right click on the axis, format the series and click on the option that says Values in Reverse Order. Users can remove fill and border color, display axis labels at their own custom angles, and then edit the legend if you want it to appear on a specific side of the chart.

Monday, May 17, 2010

Absolute Cell Reference

An Absolute Reference, is a cell Reference that no matter where you move, what you copy, paste, or delete, the reference made will always be to the same particular cell.

Argument


Arguments are very important in Microsoft Excel, especially when using functions. Arguments is the name given to the data inside the parenthesis. This data is later evaluated and solved by a Function Formula.

Charts


Charts are not only found in the math class, but also in Microsoft Excel. They allow users to create and publish spreadsheet and worksheet presentations, with better visuals, also useful for those that do not understand how data is arranged in Microsoft Excel. The available charts in Excel include Pie Charts, Line Graphs, Bar Charts, and Column Charts. All these charts can also be referred to as graphs.

Sunday, May 16, 2010

Embedded Chart

An Embedded Chart in Microsoft Word is made when you create a chart, on data already in a worksheet. You enter the data, and then you can chose whatever format you want for the chart that it well be embedded in, hence the name "an Embedded Chart".

Function Formula


A Function Formula, is a preset formula for Microsoft Excel used for problem solving. Function Formulas begin with the equal sign (=), and are then followed by the numbers used. Functions then tell excel what method to use to solve.

Saturday, May 15, 2010

Mathematical Functions

Mathematical Functions are used in Microsoft Excel to perform different mathematical functions such as finding the absolute value of a number (ABS), to multiply (PRODUCT) and to do much more. The complete set of Mathematical Functions include:
FunctionDescription
ABSReturns the absolute value of a number.
ACOSReturns the arccosine of a number
ACOSHReturns the inverse hyperbolic cosine of a number
ASINReturns the arcsine of a number
ASINHReturns the inverse hyperbolic sine of a number
ATANReturns the arctangent of a number
ATAN2Returns the arctangent from x- and y-coordinates
ATANHReturns the inverse hyperbolic tangent of a number
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
COMBINReturns the number of combinations for a given number of objects
COSReturns the cosine of a number
COSHReturns the hyperbolic cosine of a number
DEGREESConverts radians to degrees
EVENRounds a number up to the nearest even integer
EXPReturns e raised to the power of a given number
FACTReturns the factorial of a number
FACTDOUBLEReturns the double factorial of a number
FLOORRounds a number down, toward zero
GCDReturns the greatest common divisor
INTRounds a number down to the nearest integer
LCMReturns the least common multiple
LNReturns the natural logarithm of a number
LOGReturns the logarithm of a number to a specified base
LOG10Returns the base-10 logarithm of a number
MDETERMReturns the matrix determinant of an array
MINVERSEReturns the matrix inverse of an array
MMULTReturns the matrix product of two arrays
MODReturns the remainder from division
MROUNDReturns a number rounded to the desired multiple
LinkMULTINOMIALReturns the multinomial of a set of numbers
ODDRounds a number up to the nearest odd integer
PIReturns the value of pi
POWERReturns the result of a number raised to a power
PRODUCTMultiplies its arguments
QUOTIENTReturns the integer portion of a division
RADIANSConverts degrees to radians
RANDReturns a random number between 0 and 1
RANDBETWEENReturns a random number between the numbers you specify
ROMANConverts an arabic numeral to roman, as text
ROUNDRounds a number to a specified number of digits
ROUNDDOWNRounds a number down, toward zero
ROUNDUPRounds a number up, away from zero
SERIESSUMReturns the sum of a power series based on the formula
SIGNReturns the sign of a number
SINReturns the sine of the given angle
SINHReturns the hyperbolic sine of a number
SQRTReturns a positive square root
SQRTPIReturns the square root of (number * pi)
SUBTOTALReturns a subtotal in a list or database
SUMAdds its arguments
SUMIFAdds the cells specified by a given criteria
SUMPRODUCTReturns the sum of the products of corresponding array components
SUMSQReturns the sum of the squares of the arguments
SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Returns the sum of squares of differences of corresponding values in two arrays
TANReturns the tangent of a number
TANHReturns the hyperbolic tangent of a number
TRUNCTruncates a number to an integer

Mixed Cell Reference


A Mixed Cell Reference is a combination of either an Absolute Row and Relative Column, or an Absolute Column and Relative Row. In order to create an Absolute Row or an Absolute Column, you need to add $ before the column letter or row letter that you want to use.

Operand


When users want to solve a formula, equation, etc., in Microsoft Excel, they must first enter the values and data that they want to use. This data is identified as the Operands, and is important because the Operators in Excel need this data to proceed with a solving process.

Operator

Microsoft Excel is a program that will work out formulas and solutions by using Operators. These "Operators" are the decision makers of the solving process, because they decide what type of operation will be used to proceed and solve a process. The four main types of operators include Arithmetic, Comparison, Text, and Reference.

Order of Evaluation


When making evaluations, Microsoft Excel enters a process known as the Order of Evaluation. The Order of Evaluation is a multi-step process that includes Exponentiation, Multiplication and Division, and Addition and Subtraction depending on what it is that Excel will be evaluating. For example, when formulas both contain Multiplication and Addition, the operation will be performed from left to right.

Relative Cell References


Relative Cell References is a feature in Microsoft Excel in which reference is made to either a cell or group of cells, by how far away it is from another cell. When you are making a reference from a Cell like C2, which is three columns and two rows down from A1, the cell reference made by the program is 2 columns right, and 1 row down.

Thursday, May 13, 2010

Statistical Functions



Microsoft Excel is preset with Functions such as Math Functions, Text Functions, Financial Functions, and etc. One of these functions is a Statistical Function. Statistical Functions are used to analyze data in a spreadsheet by telling you the numerical average of data, or the quantity of data in the spreadsheet.

Wednesday, May 12, 2010

How to do a Mail Merge


Do you get bored and aggravated spending endless hours writing, or typing the same letter on a computer, but and then having to edit the names? Microsoft Office Word makes this all easier with it's Start Mail Merge Function that is located in the Mailings Menu. This function only requires 8 easy steps which are very simple to follow. The 1st step is to make sure that you have a Word Document Open and and Excel Document or any other type of document which will be providing the data to be used in the letter. Once you have done so, you can proceed to open the Mailings Tab/Menu in Microsoft Word, and select the Start Mail Merge Option which will present you with more options for your desired mailing type. The 2nd step takes place once you have selected your desired option and requires you to once again go to the Start Mail Merge option, but instead, you have to click on the Step by Step Mail Merge Wizard Option. This will then open a wizard at the right side of the document window, which will guide you through the Mail Merging process, providing you with 6 new steps. The 1st step is to Select Your Document Type which can be either Letters, Email Messages, Envelopes, Labels, and Directory. Once you have selected the document type, you can proceed to the 2nd step. The 2nd step asks you how you would like to proceed with your letters, as in keeping the current document or applying a template and then you have to select one to go on to the third step. The 3rd step ask you to select recipients, and that is where your data documents/Excel document comes in handy so that you can select your recipients from there. Once you have selected your recipients you can proceed to the 4th step, which is writing your letter. At the 4th step, you must select the 4th option which is More Items, and that will once again display your data from the data/Excel document. You insert the data in your desired location of the document, and then new text will be added to the document. For example, if you want to enter names next to dear, something like "Dear Names", will appear and if you want to enter an action, something like "Thank you for Actions" will appear. Once you are finished with this, you can proceed to the 5th step, and that step is Preview Your Letters, and this steps shows you have your letters will look when finalize and lets you make last minute adjustments such as excluding an action or recipient. You can go on to the 6th and final step, which is Complete Merging, and then close the wizard and print out or mail your letters. In any case that you would like to preview your letters again, you can go back to the Mailings Menu, and a new option will be available, and it says Preview Results, and you can once again see all your letters, with their corresponding recipients.

Monday, May 10, 2010

Active Cell


When you are entering textual data in a cell or format a cell, a black border appears as the cell. The purpose of this cell being shaded is because it is the cell that is currently in use, which is known as the active cell.

Ascending Order


In Microsoft Excel, an Ascending Order is an arrangement of data, specifically numerical values. This numerical data is arranged in an increasing order, where the smallest value of data is entered, and begins to increase. It can also be in alphabetical value, where data begins from the letter a, and advances to z or the desired end letter.

Cell Reference


In Microsoft Excel, a Cell Reference is when one cell in particular is taken, and date applied to any other cells relate/refer to that one particular cell. In other words, Cell Reference is when one cell is used as the foundation or base for the data in a spreadsheet/worksheet/workbook.

Descending Order


In Microsoft Excel, Data can be arranged and rearranged in a Descending Order. Unlike the Ascending order, in a Descending Order, data is arranged from the largest value such as a numerical value, to the smallest value.

Fill Handle


Once a cell is selected and serves as the Active Cell, a small square appears at the bottom of the shaded area. This is known as the fill Handle. Fill Handles can be used to adjust cell properties, add data, and expand cell sizes. Once certain data is placed in a cell, Fill Handles can automatically place similar data in the following cells.

Filling Gridlines

In Microsoft Excel, Gridlines are lines that define the sides of cells, columns, and rows. Depending on the size and quantity of text and data, Gridlines automatically adjust themselves, and users are allowed to customize Gridlines with filling effects such as the shade or background color.

Header Row


Just like in Microsoft Word, The Header Row is an option accessible by users, and when created, it is always found at the top of Microsoft. The Header Row serves a purpose for being the title of different data organized in different cells and columns.

Sunday, May 9, 2010

Merge Range


In Microsoft Excel, users have the ability to merge/combine multiple cells together, in either rows or columns. The Merge Range is the limit of how many cells can be merged, and in Excel, users can merge a whole page of cells together if they want to just display one certain type of data.

Workbook

A Workbook in Excel is a set of worksheet pages created in Microsoft Excel. Workbooks in Microsoft Excel Worksheets can contain separate data or the same data, and are saved in an "xls" or xlsx" file format.

Thursday, May 6, 2010

Worksheet

In Microsoft Excel, a Worksheet is a single page. Unlike Microsoft Word where you scroll down to access another page, to switch pages in Excel, you go towards the bottom of the window and click on a Worksheet Tab, such as Worksheet 1, Worksheet 2, and Worksheet 3.

Wednesday, April 28, 2010

Banner


In Microsoft Word, users can generate banners. Banners are advertisements that can be found at the top of a page and appear in the form of a rectangle. In text publishing, banners can be used for decoration.

Tuesday, April 27, 2010

Clip Art


Clip Art is preset graphics available for use in Microsoft word. It can be inserted into a document and modified, to give documents more color and can be found in specific categories or fields. New Clip Art images can be downloaded to add to the Clip Art file folder.

Crop



In word processing programs, Cropping is a function in which users are able to remove unwanted parts of graphics.

Desktop Publishing


Desktop Publishing is the function in which publication documents are created by users and their computers

Drawing Canvas


A Drawing Canvas is a feature provided by Microsoft Word that allows users to edit images and graphics in a new window with more tools and options for editing. Blur effects and more can be added to these images. This feature can be disabled or enabled.

Drawing Objects


Drawing Objects in Word Processing is basically adding a picture to a document, and customizing as though it is being drawn again. Unwanted portions of a graphic/object can be removed, brightness and transparency can be adjusted, sizes and rotations can be made, and objects can be overlapped.

Endnote


An Endnote is just like a footnote but instead it is an annotation placed at the end of documents. Endnotes also serve as conversions from footnotes, and a conversion from a footnote to an endnote can be established by using Microsoft Word. Endnotes are automatically remembered when text is either added or deleted.

Footer


Footers lines of text that appear at the bottom of text documents. Symbols can be used as footers to represent values such as page numbers.

Footnote



Footnotes are inserted at the bottom of word documents as references for the document. They can specify resources used in creating a document such as borrowed material or explanatory information about a text.

Graphics


Graphics are computer images that can be added to a word processors. They can be modified, resized, cropped, rotated, and Microsoft Word offers many tools and options for manipulating graphics.

Hard Column Break



A Hard Column Break is a big spacing in text documents, which divides text into two separate columns.

Header



In Word Processing, Headers are defined as either one or two lines of words that appear on top of a document. You can specify a header style, and the text that you want to be displayed in the header, and then it is automatically inserted by the processing program, in most cases, Microsoft Word.

Sizing Handles


Sizing handles are graphic indicators in graphic user interfaces that allow users to re size, and modify the size of a window. They are usually found at lower right corner of a window.

Monday, April 26, 2010

Style


Style is the term used for applied formatting for text in word processing programs such as Micorosoft Word. In Microsoft Word 2007, the style option can be applied by accessing the Style Menu in the program window, and applying many of the created style formats.

Saturday, April 24, 2010

Superscript


Superscript is a Word Processing feature in which text characters and symbols seem to appear slighlty above a line. And opposite of Superscript is Subscript in which characters appear slightly below a line.