Notes of MS office

MS - Window 

• MS-Windows is a GUI based operating system. In Windows Operating system multiple applications can be simultaneously run in different windows.
• In MS-Windows, the screen upon which icons, windows, too are displayed is known as desktop.
• An icon is a graphic symbol that represents a window element like, file, folder, or shortcut.
• Loading up of operating system files into the computer’s memory in called booting up.
• The taskbar is a bar, which is usually located at the bottom of the screen.
• My computer is helpful for viewing the contents of a single folder or drive.
• Windows Explorer is another way of seeing what is on your computer. Windows Explorer shows the computer’s contents as a hierarchy.
• File: A program or document stored on a disk.
• Toolbar: A set of button you click to perform common tasks.
• A folder is a location in which you can store files and other folders.
• To create a new folder, File—New—Folder commands are clicked in My Computer windows.
• To find files or folders, Start---Find---Files or Folder commands are clicked.
• To create a shortcut to a file, firstly select the file or folder, whose shortcut is to be created. Then drag the file icon through right mouse button to desired location where shortcut to be placed, and then select create shortcut(s).
• To shut down the computer, Start—Shut Down commands are clicked. 

MS-Word

• A word processor is a package that processes textual matter and creates organized and flawless documents.
• The world processor offers very useful features like speed, powerful editing and formatting features, permanent storage, Graphics, object linking and embedding, spell check and mail merge etc.
• The word processor automatically fits the typed text within the specified left and right margins. This feature is called word wrapping.
• Margins can be four type viz. left, right, top and bottom.
• The distance between text boundaries and page margins is called indent. The indent can be positive, negative or hanging indent.
• The text layout In Word, paragraphs can be formatted through Paragraph option of Format menu and the borders can be applied through Borders and shading option of Format menu.
• The page formatting in Word can be controlled through Page Setup … option of File menu. The header and footer can be created and formatted using Header and Footer option of the view menu.
• In word, the document can either be printed through print button of standard toolbar or through the Print option of File menu. The help is available in Word through the Help menu.
• In word, spelling and grammar can be checked either through the spelling and Grammar option of tool menu
• The Autocorrect feature of Word converts shorthand into longer strings. You can create your own Autocorrect entries by clicking to Autocorrect command to Tools menu.
• Tables can be inserted in a Word document through Table button of Standard toolbar and can be manipulated through the table drop menu.
• In MS-Word, the mail merge involves two files – Main document and data source file to produce the merged document. The main document and data source can handled through Mail Merge option of Tools menu. 

MS-EXCEL

• A spreadsheet is a software tool that lets one enter, calculate, manipulate and analyze set of numbers.
• A Worksheet is a grid of cells made up of horizontal rows and vertical columns.
• A workbook is a group of worksheets.
• Three types of data can be entered in a worksheet (i) number (ii) Text (iii) Formulas.
• Cell can be referenced in three ways (i) relative (ii) absolute (iii) mixed
• A cell can be edited either by overwriting or by partially modifying the cell contents.
• A range can selected using mouse or keyboard.
• A range can be either through copy and paste operations or by dragging the fill handle.
• A range can be moved either through cut and paste operations or by dragging the range border.
• A range can be cleared through Edit--Clear command.
• To erase everything from a worksheet ,select all the cells in the worksheet and then use Edit—Clear—All.
• To save a workbook use File- Save command.
• To open a workbook use File—Open command.
• To insert cells, rows or columns in worksheet, use Insert---Cells----, Insert-----Rows or Insert-----Column command respectively.
• General arrangement of data is known as formatting.
• Formatting does not affect the actual cell value only the appearance change.
• Formatting is performed in MS-Excel through options available in Format menu.
• Charts are the pictorial representation of worksheet data.
• Various chart types in MS- Excel are area chart, column chart, bar chart, line chart, pie chart, XY(Scatter) chart.
• Chart in MS-Excel saved in two ways : (i) embedded chart (ii) chart sheet
• Embedded chart is a chart object that is placed on a worksheet and saved with that work sheet.
• Chart sheet is a sheet in workbook that contains only a chart.
• Charts are created using chart wizard. 

Powerpoint

• The application software that can create professional looking visual aids is called Presentation Graphics Software.
• MS-PowerPoint can be started by clicking at Start—Program---Microsoft PowerPoint.
• A slide can contain one or more of these components: Titles, Graphs, Drawing objects, ClipArt and Pictures.
• The slide components that are used for reference are: Handouts, Notes ,Outlines.
• A new presentation can be created through one of these methods:(i) Auto content Wizard (ii) Design Templates (iii) Sample Presentation and (iv) Blank Presentation
• A new side can be added by either clicking at Common Tasks options of Formatting toolbar and then selecting New Slide option, by clicking at Insert menu’s New Slide option.
• A presentation in PowerPoint can viewed in any of these views: Normal, Outline, Slide, Slide Sorter, Slide Show and Notes Page View.
• To apply new design to slides, click either at Apply Design Template option of Common Tasks options of Formatting toolbar, or at Format
• menu’s Apply Design Template option or ever from the shortcut menu.
• A color scheme is a combination of various colors used for text and other presentation elements.
• A color scheme can be changed by clicking at Slide Color Scheme option of Format menu.
• Background color can be changed by clicking at Format----Background command or even through slide’s shortcut menu.
• You can change text font and style by using Format---Font command.
• Header and Footer information can be viewed and changed by clicking at View---Header and Footer option.
• The slide ---shorter view in useful for viewing the slides in miniature forms and for rearranging them.
• Movies (Vedio) & Sound can be inserted by using Insert—Movies & Sounds command.
• While creating slide shows you can add transitions to slides by using Slide Show --- Slide Transition command.
• To add animation, you can use Slide Show-----Custom Animation commands.