hey guys, here is the solution to our 1st itc assignment. Well, it is all copied from different sites. But atleast you get the answers on one single page. And yeah, don’t simply write this WHOLE blog post! It’s freakin’ too much. 
Word Processing
Using a computer to create, edit, and print documents. Of all computer applications, word processing is the most common. To perform word processing, you need a computer, a special program called a word processor, and a printer. A word processor enables you to create a document, store it electronically on a disk, display it on a screen, modify it by entering commands and characters from the keyboard, and print it on a printer.
The great advantage of word processing over using a typewriter is that you can make changes without retyping the entire document. If you make a typing mistake, you simply back up the cursor and correct your mistake. If you want to delete a paragraph, you simply remove it, without leaving a trace. It is equally easy to insert a word, sentence, or paragraph in the middle of a document. Word processors also make it easy to move sections of text from one place to another within a document, or between documents. When you have made all the changes you want, you can send the file to a printer to get a hardcopy.
Word processors vary considerably, but all word processors support the following basic features:
# insert text: Allows you to insert text anywhere in the document.
# delete text: Allows you to erase characters, words, lines, or pages as easily as you can cross them out on paper.
# cut and paste : Allows you to remove (cut) a section of text from one place in a document and insert (paste) it somewhere else.
# copy : Allows you to duplicate a section of text.
# page size and margins : Allows you to define various page sizes and margins, and the word processor will automatically readjust the text so that it fits.
# search and replace : Allows you to direct the word processor to search for a particular word or phrase. You can also direct the word processor to replace one group of characters with another everywhere that the first group appears.
# word wrap : The word processor automatically moves to the next line when you have filled one line with text, and it will readjust text if you change the margins.
# print: Allows you to send a document to a printer to get hardcopy.
Word processors that support only these features (and maybe a few others) are called text editors. Most word processors, however, support additional features that enable you to manipulate and format documents in more sophisticated ways. These more advanced word processors are sometimes called full-featured word processors. Full-featured word processors usually support the following features:
# file management : Many word processors contain file management capabilities that allow you to create, delete, move, and search for files.
# font specifications: Allows you to change fonts within a document. For example, you can specify bold, italics, and underlining. Most word processors also let you change the font size and even the typeface.
# footnotes and cross-references: Automates the numbering and placement of footnotes and enables you to easily cross-reference other sections of the document.
# graphics graphics: Allows you to embed illustrations and graphs into a document. Some word processors let you create the illustrations within the word processor; others let you insert an illustration produced by a different program.
# headers , footers , and page numbering: Allows you to specify customized headers and footers that the word processor will put at the top and bottom of every page. The word processor automatically keeps track of page numbers so that the correct number appears on each page.
# layout : Allows you to specify different margins within a single document and to specify various methods for indenting paragraphs.
# macros : A macro is a character or word that represents a series of keystrokes. The keystrokes can represent text or commands. The ability to define macros allows you to save yourself a lot of time by replacing common combinations of keystrokes.
# merges: Allows you to merge text from one file into another file. This is particularly useful for generating many files that have the same format but different data. Generating mailing labels is the classic example of using merges.
# spell checker : A utility that allows you to check the spelling of words. It will highlight any words that it does not recognize.
# tables of contents and indexes: Allows you to automatically create a table of contents and index based on special codes that you insert in the document.
# thesaurus: A built-in thesaurus that allows you to search for synonyms without leaving the word processor.
# windows : Allows you to edit two or more documents at the same time. Each document appears in a separate window. This is particularly valuable when working on a large project that consists of several different files.
# WYSIWYG (what you see is what you get): With WYSIWYG, a document appears on the display screen exactly as it will look when printed.
__________________________________________________________________
Office automation
Office automation refers to the varied computer machinery and software used to digitally create, collect, store, manipulate, and relay office information needed for accomplishing basic tasks and goals. Raw data storage, electronic transfer, and the management of electronic business information comprise the basic activities of an office automation system. Office automation helps in optimizing or automating existing office procedures.
The backbone of office automation is a LAN, which allows users to transmit data, mail and even voice across the network. All office functions, including dictation, typing, filing, copying, fax, Telex, microfilm and records management, telephone and telephone switchboard operations, fall into this category. Office automation was a popular term in the 1970s and 1980s as the desktop computer exploded onto the scene.
__________________________________________________________________
Microsoft Word
Microsoft Word is Microsoft’s flagship word processing software. It was first released in 1983 under the name Multi-Tool Word for Xenix systems. Versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), SCO UNIX, OS/2 and Microsoft Windows (1989). It is a component of the Microsoft Office system; however, it is also sold as a standalone product and included in Microsoft Works Suite. Beginning with the 2003 version, the branding was revised to emphasize Word’s identity as a component within the Office suite; Microsoft began calling it Microsoft Office Word instead of merely Microsoft Word. The latest releases are Word 2007 for Windows and Word 2008 for Mac OS X.
__________________________________________________________________
Facilites
Word has a built-in spell checker, thesaurus, dictionary and Office Assistant.
Normal.dot
Normal.dot is the master template from which all Word documents are created. It is one of the most important files in Microsoft Word. It determines the margin defaults as well as the layout of the text and font defaults. Although normal.dot is already set with certain defaults, the user can change normal.dot to new defaults. This will change other documents that were created using the template and saved with the option to automatically update the formatting styles.
Macros
Like other Microsoft Office documents, Word files can include advanced macros and even embedded programs. The language was originally WordBasic, but changed to Visual Basic for Applications as of Word 97.
a macro is a series of commands that is recorded so it can be played back, or executed, later. There are a couple different ways to create Word macros: The first, and easiest way, is to use the macro recorder; the second way is to use VBA, or Visual Basic for Applications. Further, Word macros can be edited by using the VBE, or Visual Basic Editor.
Creating Tables
Users can also create tables in MS Word. Depending on the version, Word can perform simple calculations. Formulae are supported as well.
AutoSummarize
AutoSummarize highlights passages or phrases that it considers valuable. The amount of text to be retained can be specified by the user as a percentage of the current amount of text.
According to Ron Fein of the Word 97 team, Auto Summarize cuts wordy copy to the bone by counting words and ranking sentences. First, AutoSummarize identifies the most common words in the document (barring “a” and “the” and the like) and assigns a “score” to each word–the more frequently a word is used, the higher the score. Then, it “averages” each sentence by adding the scores of its words and dividing the sum by the number of words in the sentence–the higher the average, the higher the rank of the sentence. “It’s like the ratio of wheat to chaff,” explains Fein.
__________________________________________________________________
MS POWERPOINT
Microsoft PowerPoint is a proprietary presentation program developed by Microsoft. It is part of the Microsoft Office system, and runs on Microsoft Windows and the Mac OS computer operating systems. The Windows version can run in Linux operating system, under the Wine compatibility layer.
PowerPoint is widely used by business people, educators, students, and trainers and is among the most prevalent forms of persuasive technology. Beginning with Microsoft Office 2003, Microsoft revised the branding to emphasize PowerPoint’s place within the office suite, calling it Microsoft Office PowerPoint instead of just Microsoft PowerPoint. The current versions are Microsoft Office PowerPoint 2007 for Windows and 2008 for Mac.
PowerPoint animation is a form of animation which uses Microsoft PowerPoint and similar programs to create a game or movie. Using Custom Animation, drawing tools and slides within PowerPoint, the animator makes a game or movie.
Custom Animation is a set of effects which can be applied to objects in PowerPoint so that they will animate in the Slide Show. They can be added under the Custom Animation function (Slide Show | Custom Animation) or through the use of Visual Basic for Applications (VBA). PowerPoint 2000 and earlier versions introduced basic effects such as Appear, Dissolve, Fly In and so forth. In PowerPoint 2002/XP and later versions, the Custom Animation feature was improved, adding new animation effects grouped into four categories: Entrance, Emphasis, Exit and Motion Paths.
__________________________________________________________________
Microsoft Excel
Microsoft Excel (full name Microsoft Office Excel) is a proprietary spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for Excel 2008 for Mac OS X, a macro programming language called VBA (Visual Basic for Applications). It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993, and is bundled as part of Microsoft Office. Excel is one of the most popular microcomputer applications to date.
Math functions.
| Function | Description |
|---|---|
| ABS | Returns the absolute value of a number |
| ACOS | Returns the arccosine of a number |
| ACOSH | Returns the inverse hyperbolic cosine of a number |
| ASIN | Returns the arcsine of a number |
| ASINH | Returns the inverse hyperbolic sine of a number |
| ATAN | Returns the arctangent of a number |
| ATAN2 | Returns the arctangent from x- and y-coordinates |
| ATANH | Returns the inverse hyperbolic tangent of a number |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance |
| COMBIN | Returns the number of combinations for a given number of objects |
| COS | Returns the cosine of a number |
| COSH | Returns the hyperbolic cosine of a number |
| DEGREES | Converts radians to degrees |
| EVEN | Rounds a number up to the nearest even integer |
| EXP | Returns e raised to the power of a given number |
| FACT | Returns the factorial of a number |
| FACTDOUBLE | Returns the double factorial of a number |
| FLOOR | Rounds a number down, toward zero |
| GCD | Returns the greatest common divisor |
| INT | Rounds a number down to the nearest integer |
| LCM | Returns the least common multiple |
| LN | Returns the natural logarithm of a number |
| LOG | Returns the logarithm of a number to a specified base |
| LOG10 | Returns the base-10 logarithm of a number |
| MDETERM | Returns the matrix determinant of an array |
| MINVERSE | Returns the matrix inverse of an array |
| MMULT | Returns the matrix product of two arrays |
| MOD | Returns the remainder from division |
| MROUND | Returns a number rounded to the desired multiple |
| MULTINOMIAL | Returns the multinomial of a set of numbers |
| ODD | Rounds a number up to the nearest odd integer |
| PI | Returns the value of pi |
| POWER | Returns the result of a number raised to a power |
| PRODUCT | Multiplies its arguments |
| QUOTIENT | Returns the integer portion of a division |
| RADIANS | Converts degrees to radians |
| RAND | Returns a random number between 0 and 1 |
| RANDBETWEEN | Returns a random number between the numbers you specify |
| ROMAN | Converts an arabic numeral to roman, as text |
| ROUND | Rounds a number to a specified number of digits |
| ROUNDDOWN | Rounds a number down, toward zero |
| ROUNDUP | Rounds a number up, away from zero |
| SERIESSUM | Returns the sum of a power series based on the formula |
| SIGN | Returns the sign of a number |
| SIN | Returns the sine of the given angle |
| SINH | Returns the hyperbolic sine of a number |
| SQRT | Returns a positive square root |
| SQRTPI | Returns the square root of (number * pi) |
| SUBTOTAL | Returns a subtotal in a list or database |
| SUM | Adds its arguments |
| SUMIF | Adds the cells specified by a given criteria |
| SUMPRODUCT | Returns the sum of the products of corresponding array components |
| SUMSQ | Returns the sum of the squares of the arguments |
| SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays |
| SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays |
| SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays |
| TAN | Returns the tangent of a number |
| TANH | Returns the hyperbolic tangent of a number |
| TRUNC | Truncates a number to an integer |
Examples:
Factorial
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number.
Syntax
FACT(number)
Number is the nonnegative number you want the factorial of. If number is not an integer, it is truncated.
Returns the logarithm of a number to the base you specify.
Log
Syntax
LOG(number,base)
Number is the positive real number for which you want the logarithm.
Base is the base of the logarithm. If base is omitted, it is assumed to be 10.
GCD
Applies to: Microsoft Office Excel 2003
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.
ShowHow?
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
3. If necessary, follow the instructions in the setup program.
Syntax
GCD(number1,number2, …)
Number1, number2, … are 1 to 29 values. If any value is not an integer, it is truncated.
If there’s any correction, please lemme know.
Amen.
Stumble It!