MICROSOFT OFFICE

MICROSOFT OFFICE 

Microsoft Office is an office suite of desktop applications, servers and services for the Microsoft Windows and OS X operating systems.

It was first announced by Bill Gates of Microsoft on August 1, 1988 at COMDEX in Las Vegas.

MS office primarily includes Word, Excel, PowerPoint, Access and Outlook.

It also includes OneNote, Groove, InfoPath and Publisher.

MS WORD

Microsoft Word is a word processor developed by Microsoft.

It is used for creating, editing, formatting, storing, retrieving and printing of a text document.

Microsoft Word's native file formats are denoted either by a .doc or .docks file extension.

Header and Footer option is used to display information such as title and page number of the document.

The bar at the top of the window that bears the name of the window is known as Title Bar.

A screen element of MS Word that is usually located below the title bar that provides categorised option is called Menu Bar.

Auto Correct in word automatically corrects certain spelling, typing, and capitalisation or grammar errors.

Thesaurus is used for finding a synonym for a word in the document.

WordArt enables drawing text in a Microsoft Word document such as a title, watermark, or other text, with graphical effects such as skewing, shadowing, rotating, and stretching in a variety of shapes and colours and even including three-dimensional effects.

Word has extensive lists of bullets and numbering features used for tables, lists, pages, chapters, headers, footnotes, and tables of content.

MS EXCEL

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS.

It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

The intersection of a row and column is called a Cell.

The cell in which we are currently working is known as Active Cell.

Microsoft Excel's native file formats are denoted either by an .axles or .lax file extension.

A Worksheet is made of columns and rows, wherein columns run vertically and rows run horizontally.

Up to Excel 2003, the standard amount of columns has been 256 and 65,536 rows.

Excel 2007 onwards, the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations

The letter and number of the intersecting column and row is the Cell Address.

Short cut key to insert a new worksheet in MS-Excel is ALT + Shift + F1 + or F11.

Sheet tab is the tab at the bottom of the worksheet window that displays the name of the worksheet.

A Microsoft office document that contains one or more worksheets is known as a Workbook.

MICROSOFT POWERPOINT

Microsoft PowerPoint is a slide show presentation program developed by Microsoft.

PowerPoint presentations consist of a number of individual pages or "slides".

Microsoft PowerPoint's native file formats are denoted either by a .pot or .pot files extension.

PowerPoint provides three types of movements:

Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations.

Transitions, on the other hand, are movements between slides. These can be animated in a variety of ways.

Custom animation can be used to create small story boards by animating pictures to enter, exit or move.