MICROSOFT OFFICE

MS Office: Microsoft office or Microsoft office system is a collection of computer programs made by Microsoft. The programs are created for all users. There are different versions of the software for home users and for business users.

  • 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 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 docx file extension.

 

Some Important Tools in Microsoft Word

  • Header And Footer option is used to display information such as title and page number of the document.
  • Title Bar- A bar at the top of the window that bears the name of the window.
  • Menu Bar- A screen element of MS word that is usually located below the title bar that provides categorized option.
  • Thesaurus- It is used for finding a synonym for a word in the document.
  • Style- Changes the style of the selected text.
  • Font- Changes the font for the selected text.
  • Font Size- Changes the point size of the selected text. 
  • Bold- Makes the selected text bold.
  • Italic- Makes the selected text italic.
  • Underline- Underlines the selected text.
  • Align Left, Align Right, Center- aligns the selected text/paragraph.
  • Justify- Justifies the selected text/paragraph.
  • New- Creates a new, blank document.
  • Open- Displays the open dialogue box so that you can retrieve existing document.
  • Save, Print, Print Preview- Saves the active document to a specified location, prints active document and displays what the document will look like when you print it.
  • Cut, Copy, Paste- Cuts the selected text and places it on the clipboard then copies selected text and paste the contents of the clipboard to a new location.
  • Undo- Undoes the last document change.
  • Redo- Redoes the last action that was undone. 
  • Insert Hyperlink- Creates a hyperlink from the selected text.

 

SHORTCUT KEYS AND FUNCTION KEYS

Shortcut Keys → Functions

Ctrl + shift + Spacebar → creates a non-breaking space

Ctrl + B → makes letters bold

Ctrl + I → makes letters Italic

Ctrl + U → makes letters underline

Ctrl + shift + < : decreases the font size one value

Ctrl + shift + > : increases the font size one value

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

F1 → get help or visit Microsoft Office online

F4 → repeat the last action

F5 → choose the Go To command

F7 → choose the spelling command

F12 → choose the Save As command

 

 

 

MICROSOFT EXCEL

  • Microsoft Excel is software developed by Microsoft Corporation that allows user to organize, format and calculate data with formulas using a The exact number of rows and columns are 1,048,576 rows and 16,384 columns.
  • It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for applications.

 

Some Important Terms Used In Excel:

  • Cell- Parcel is the intersection of a row and A cell can contain a label, a numeric value or a formula.
  • Cell Address- The cell address is the location of a Cell on a worksheet and is defined by the column letter and the row number. 
  • Active Cell- The cell in which we are currently working.
  • Formula Bar- The formula bar is located under the toolbars at the top of the working It contains the edit line for working with formulas and provides information regarding cell addresses.
  • Functions- A function is a preset Functions consist of the function name and its arguments. The function name tells Excel what calculation you want it to perform.
  • Pivot Table Wizard- Pivot table Wizard is a series of dialogue boxes that guides you step by step through the process of creating a pivot table. 
  • Spreadsheet- Spreadsheet is the generic term for applications, such as Excel, that you can use to enter, analyze and calculate It performs mathematical calculations and projections based on data entered. Common spreadsheet uses include analysis, charting and budgeting.
  • Syntax- The syntax of the function refers to the order of the functions In some functions, the order of the arguments determines how Excel solves the function.
  • Worksheet- A worksheet is an electronic spreadsheet that lets you enter, analyze and calculate Within a workbook, worksheets can share information and calculations pertaining to several worksheets can be performed at one time. Default number of worksheets in a new workbook is three.


SHORTCUT KEYS OF MS EXCEL

Shortcut Keys → Functions

Ctrl + shift + ; → enter the current time

Ctrl + ; → enter the current date

Ctrl + space/shift + space bar → select the entire column/select the entire row

Alt + = → create a formula to sum all of the above cells

Ctrl + ’ → insert the value of the above cell into the cell currently selected

Ctrl + Arrow key → move to next section of text

F2 → edit the selected cell

F5 → go to a specific cell

Ctrl + F6 → switch between open workbooks/window

F7 → spell check selected text and/or document

F11 → create chart


MS 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 Picture.
  • The slide components that are used for reference are: Handouts, Notes, and Outlines.

 

A new presentation can be created through one of these methods:

  • Auto Content Wizard
  • Design Templates
  • Sample Presentation
  • Blank Presentation

 

Some Important Terms:

  • Animations- Animations are effects that allow you to reveal the points on a slide one by one. 
  • Auto ClipArt- Use the auto ClipArt command to begin a concept keyword search of your PowerPoint searches your slideshow for keywords that relate to the keywords associated with the clip art images from the clip gallery.
  • Background- the background dialogue box provides various options that let you change the background look of a single slide or every slide in the presentation.

 

Presentation- a presentation is a collection of slides, handouts, speaker’s notes and an outline, all combined into a file that can be printed onto transparencies or projected from a computer.

  • Slides- slides are the individual pages of your Slides can be designed with different titles, graphics, text and much more.
  • Slide Sorter Toolbar- the slide sorter toolbar is available only in slide sorter view and allows quick access to special PowerPoint effects such as transitions, builds, rehearse timing, and hide slides.
  • Slide Sorter View- slide sorter view displays a reduced image of all the slides in a grid-like This view makes it easier to rearrange the slides in a presentation and add transitions and special effects.
  • Slide View- slide view allows you to work on all slide at a While in slide view, you can add any element to a slide, including text, graphics, shapes and graphs.

 

Database Management System (DBMS) - Database management system is about managing and structuring the collections of data held on computers. A database consists of an organized Collection of data for one or more uses. Example- bibliography, document- text, statistical.