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.
Function Keys |
|
---|---|
F1 |
Get help or visit Microsoft office Online. |
F2 |
Move text or graphic. |
F4 |
Repeat the last action |
F5 |
Choose the Go to command (Home tab). |
F6 |
Go to the nest pane or frame. |
F7 |
Choose the spelling command (Review tab) |
F8 |
Extend a selection |
F9 |
Update the selected fields |
F10 |
Show key tips |
F11 |
Go to the nest field |
F12 |
Choose the Save As command (Microsoft Office Button). |
Basic Keys Common Tasks |
|
Ctrl + Shift + Spacebar |
Create a non breaking space |
Ctrl + B |
Make letters bold |
Ctrl + I |
Make letters italic |
Ctrl + U |
Make letters underline |
Ctrl + Shift+ < |
Decrease font size one value |
Ctrl + Shift + > |
Increase the font size one value |
Ctrl + [ |
Increase the font size by 1 point |
Ctrl + ] |
Decrease the font size by 1 point |
Ctrl + Spacebar |
Remove paragraph or character formatting. |
Ctrl + C |
Copy the selected text or object |
Ctrl + X |
Cut the selected text or object |
Ctrl + V |
Paste text or an object |
Ctrl + Alt + V |
Paste special |
Ctrl + Shift + V |
Paste formatting only |
Ctrl + Z |
Undo the last action |
Ctrl + Y |
Redo the last action |
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.
Shortcut Keys of MS-Excel |
|
---|---|
Key |
Description |
F2 |
Edit the selected cell |
F5 |
Go to a specific cell |
F7 |
Spell check selected text and/or document |
F11 |
Create chart |
Ctrl + Shift + ; |
Enter the current time |
Ctrl + ; |
Enter the current date |
Shift + F3 |
Open the Excel formula window |
Shift + F5 |
Bring up search box. |
Ctrl + A |
Select all contents of the worksheet |
Ctrl + B |
Bold highlighted selection |
Ctrl + I |
Italic highlighted selection |
Ctrl + U |
Underline highlighted selection |
Ctrl + P |
Bring up the print dialog box to begin printing |
Ctrl + Z |
Undo last action |
Ctrl + F9 |
Minimise current workbook |
Ctrl + F10 |
Maximise currently selected workbook |
Ctrl + F6 |
Switch between open workbooks/window |
Ctrl + page up |
Move between Excel worksheet in the same Excel document. |
Ctrl + Page Down |
Move between Excel worksheets in the same Excel document |
Ctrl + Tab |
Move between two or more open Excel files |
Alt + = |
Create a formula to sum all of the above cells |
Ctrl + ’ |
Insert the value of the above cell Into cell currently selected. |
Ctrl + Arrow key |
Move to next section to text |
Ctrl + Space |
Select entire column |
Shift + Space |
Select entire row |
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.