Recruitment Topper

Latest Govt. Jobs, Bank Jobs, Exam Results, Walkin for Freshers

You are here: Home / Study Material / Computer Awareness Study Material – Microsoft Office

Computer Awareness Study Material – Microsoft Office

by Leave a Comment

Computer Awareness Study Material – Microsoft Office

Computer Awareness Study MaterialBanking AwarenessMarketing Aptitude

Microsoft Office was developed by Microsoft Inc in 1988. It is a collection of softwares, based on specific purpose and mainly used in office work. You can start any software of MS-Office by using the Start button.

There are five packages of MS-Office

  1. MS-Word (Word Processing Software)
  2. MS-Excel (Tabular Data Formatting Software)
  3. MS-PowerPoint (Presentation Software)
  4. MS-Access (Database Management Software)
  5. MS-Outlook (E-mail Client)

Microsoft Word
MS-Word is a Word processing application which is one of the most important and widely used applications found on computer. Word processing software is mainly used to the creation of text based documents. It provides tools for composing, editing, formatting and printing of documents smaller than 45 Kb. The document can be a poster, report, letter, brochure, Web page, newsletter, etc. e.g. Wordstar, Easy Word, Notepad for Windows.

Start MS-Word
There are two methods of starting MS-Word which are as follows

  • Click on Start button and type run on text box than click on Run after that Run dialog box will be appear on screen. Now type winword on text box and press Enter.
  • Click Start button —> All Programs —> Microsoft Office —>Microsoft Office Word 2007.

It opens MS-Word with a blank document. By default, the name of the blank document is Documentl. docx, where .docx is the extension of a MS-Word file.

Components of Microsoft Word
The components of MS-Word are as follows

  1. Title Bar It shows the name of the application and name of the file. It consists of three buttons, i.e.
    1. Minimize (reduces the window but Word still active)
    2. Restore (brings Word window to the maximum original size)
    3. Close (brings us out of Word)
  2. Standard Tool Bar It displays the symbol for the common operation like Open, Print, Save, etc.
  3. Ribbon It is a set of tools and commands across the top of the screen. It consists of a panel of commands which are organised into a set of tabs.
  4. Tab On the ribbon, it contains the buttons needed to edit characters, text and layout.
    1. Home tab consists of Clipboard (Cut, Copy, Paste), Font (Size, Color, Bold, Italic/Underline), Paragraph (Bullets/ Numbering, Indent), Styles, Editing (Find and Replace).
    2. Insert tab consists of Pages (Cover Page, Blank Page, Page Break), Illustrations (Picture, ClipArt, Shapes, SmartArt, Chart), Links (Hyperlink), Header & Footer, Text (TextBox, Date & Time, Object).
    3. Page Layout tab consists of Themes, Page Setup, Page Background, Paragraph.
    4. Review tab consists of Spelling & Grammar, Thesaurus, Translate, Compare and Protect Document.
    5. View tab consists of Print Layout, Full Screen Reading, Macros, Split, etc.

    computer-awareness-study-material-microsoft-office-1

  5. Ruler It appears on the top of the document window. It allows to format the horizontal or vertical alignment of text in a document.
    There are two types of rulers

    1. Horizontal ruler indicates the width of the document and is used to set left and right margins.
    2. Vertical ruler indicates the height of the document and is used to set top and bottom margins.
  6. Status Bar It displays the information such as page number, current page, current template, column number and line number, etc.
  7. Work Area It is the rectangular area of the document window, you use to type the text. It is also called as Workplace.
  8. Cursor It is also called insertion pointer. It denotes the place where text, graphics or any other item would be placed when you type, overwrite or insert them.

Features of Microsoft Word
MS-Word is the most popular Word processing application due to its user-friendly features as described below

  1. Text Editing It provides tremendous flexibility in terms of editing, adding and deleting text, modification of text content, cut, copy and paste. When, we cut any text in our document, it will save in hard drive temporarily, till we paste it on any other place.
  2. Format Text It offers to modify the text in any of the available hundreds of text designs, format text in various styles such as bold, italic, underline,
  3. Indentation It denotes the distance text boundaries and page margins. It offers three types of indentation- positive, hanging and negative.
  4. Page Orientation It facilitates selection of typed text printed or visible in horizontal view or vertical view on a specified size of the page. Word offers Portrait- vertically oriented and Landscape- horizontally oriented.
  5. Find and Replace This feature allows flexibility and comfort to the user to replace a text with a substituted text at all places.
  6. Spell Check This facilitates automatic and manual checking of spelling mistakes and also suggests a few possible alternate options for incorrect spelt words.
  7. Thesaurus It contains a comprehensive dictionary and thesaurus feature offers synonym options for a word.
  8. Bullets and Numbering A list of bullets and numbering features used for tables, lists, pages and tables of content. Bullets are arranged in unordered lists and numbering are arranged in ordered lists.
  9. Mail-Merge Word provides a mail-merge of addresses of a large number of recipients with a common text document.
  10. Graphics It provides the facility of incorporating drawings in the documents which enhances their usefulness.
  11. Object Linking and Embedding (OLE) It is a program integration technology that is used to share information between programs through objects. Objects save entities like charts, equations, video clips, audio clips, pictures, etc.
  12. Horizontal and Vertical Scroll Bars They enable one to move up and down or left and right across the window. The horizontal scroll bar is located above the status bar to back and forth the document. The vertical scroll-bar is located along the right side of the screen to move up and down the document.

Shortcut Keys of MS-Word and their Descriptions Standard Toolbar

Formatting Toolbar
Microsoft Excel
An electronic spreadsheet is used for analysing, sharing and managing information for accounting purpose performing mathematical calculations, budgeting, billing, etc. A spreadsheet is a matrix of rows and columns similar to an accounting ledger. The spreadsheet program also provides tools for creating graphs, inserting pictures and chart, analysing the data, etc. Microsoft Excel (MS-Excel), Corel Quattro Pro, Snowball, Lotus-1-2-3, Apple Numbers are some of the spreadsheet software.

Start MS-Excel
To start MS-Excel software, we can follow any one method out of them

  • Click on Start button and type run on text box than click on Run after that Run dialog box will be appear on screen. Now type winword on text box and press Enter.
  • Click Start button —> All Programs —> Microsoft Office —> Microsoft Office Excel 2007

computer-awareness-study-material-microsoft-office-2
Components of Microsoft Excel
The components of MS-Excel are as follows

  1. Title Bar It shows the name of the application and name of the file. It consists of three buttons, i.e. minimize, maximize and close.
  2. Ribbon It consists of a panel of commands which are organised into a set of tabs.
  3. Tabs It contains the command such as Home, Insert, Page Layout, Formulas, Data, Review, View, etc as well as any additional command that you may need.Some commands are as follows
    1. Clipboard A clipboard group contains the Cut, Copy and paste
    2. Alignment It is used to change alignment of the text in the cells-vertical alignment, horizontal alignment, indentation, wrap the text, shrink it to fit within the cell and merge multiple cells.
    3. Table It is used to define a range of cell as a table for easy filtering and sorting and create a pivote table or chart to arrange and summarise the data.
    4. Function Library It contains a library of functions (e.g. mathematical, logical, trigonometric, etc), such as AND, IF, LOOKUP, AVG, DATE, etc.
    5. Macros It is used to define a sequence of actions to perform on a document or multiple documents that can be executed again and again.
  4. Status Bar It displays information about the currently active worksheet. It includes page number, view shortcuts, zoom slider, etc.
  5. Formula Bar It is located beneath the Ribbon. It is used to enter and edit worksheet data.
    It includes

    1. Name box displays the all reference or column and row location of the active cell.
    2. Functions are predefined formulas that perform calculations by using specific values, called arguments.

Predefined formulas in MS-Excel are called functions
There are different types of functions

Function Description Example
SUM It is used to add all the  values provided as argument = SUM (A1 : A5)
AVERAGE This function calculates the average of all the values provided as argument = AVERAGE (A1: A5)
COUNT This function counts the number of cells that contain number =COUNT (A1 : A5)
MAX This function is used to return maximum value from a list of arguments =MAX (A1 : A5)
MIN This function is used to return minimum value from a list of arguments = MIN (A1: A5)

Where A1 : A5 is a range between the cells of A1 and A5.

Basics of Spreadsheet
MS-Excel allows creation of spreadsheets.
The basic terms of spreadsheet are

  1. A spreadsheet is a software tool that lets one enter, calculate, manipulate and analyse set of numbers.
  2. The intersection of each row and column is called A cell is an individual container for data.
    It may hold

    1. Numbers (Constants)
    2. Formulas (Mathematical equations)
    3. Text (Labels)
  3. An array of cells is called a sheet or A worksheet holds information presented in tabular format with text that labels the data.
  4. A workbook is a document that contains one or more worksheet.
  5. A row is given a number that identifies it, starts from 1, 2, 3, 4, 5, … so on.
  6. A column is given a letter that identifies it, starts from A… Z, AA… AZ,,BA, BB … BZ so on.
  7. A cell pointer is a cell-boundary that specifies which cell is active at that moment.
  8. A formula is an equation that calculates the value to be displayed. A formula must begin with equal to (=) sign.
  9. A cell address is used to specified the intersecting of row and column of the letter and number on worksheet.

Charts
These are the graphical and pictorial representation of worksheet data. A chart consists of following components

  • X-Axis is a horizontal axis known as category axis.
  • Y-Axis is a vertical axis known as values axis.
  • Data series is the set of values that you want to plot in the chart.

Types of Charts
There are various types of charts

  • Area Chart It emphasises the magnitude of change over time.
  • Column Chart It shows data changes over a period of time or illustrates comparisons among items.
  • Bar Chart It illustrates comparisons among individual items. Categories are organised vertically and values horizontally.
  • Line Chart It shows trends in data at equal intervals. It is useful for depicting the change in a value over period of time.
  • Pie Chart It shows the proportional size of items that make up only one data series to the sum of the items.
  • XY (Scatter) Chart It shows the relationships among the numeric values in several data series or plots two groups of numbers as series of XY coordinates.

Components of a Chart

  • Chart Area This is the total region surrounding the chart.
  • Plot Area The area where data is plotted. The plot area is bounded by axes in a 2D-Chart where as in 3D-Chart it is bounded by walls and floor.
  • Chart Title The descriptive text aimed at helping user identify the chart.Axis Title These are the titles given to three axis, i.e. X, Y, Z.
  • Data Series A row or column of numbers that are plotted in a chart is called a data series.
  • Gridlines These are horizontal and vertical lines which inserted in the chart to enhance its readability.
  • Legends It helps to identify various plotted data series.
  • Data Label It provides additional information about a data marker.
  • Data Table It is defined as a range of cells that are used for testing and analysing outcomes on a large scale.

Shortcut Keys of MS-Excel and their Descriptions

Shortcut Keys Description
F2 Edit the selected cell.
F5 Go to a specific cell. e.g. C6
F7 Spell check selected text and/or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + FI Insert new worksheet.
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 +1 Italic highlighted selection.
Shortcut Keys Description
Ctrl + K Insert link.
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/ windows.
Ctrl + Page up Move between Excel worksheets 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 + Shift+! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

Microsoft PowerPoint
The application software that can create professional looking visual aids is called presentation graphics software. The presentation software is used for creation of the slides and to display the information in the form of presentation of slides. A presentation software provides tools like editor that allows insertion and formatting of text and methods for inserting and manipulating graphics images along with sound and visuals effect.

Start MS-PowerPoint
To start the MS-PowerPoint software, we need to Click Start button —> All Programs —> Microsoft Office —>Microsoft Office PowerPoint 2007.
computer-awareness-study-material-microsoft-office-3

Components of PowerPoint
Various components of MS-PowerPoint 2007 window are described below

  • Title Bar It contains the name of currently opened file followed by software name.
  • Ribbon It is same as Word and Excel, just few tabs are different like Animations, Slide Show, etc.
  • Slide It appears in the centre of the window. You can create your presentation by adding content to the slides.
  • Slide Pane This area of PowerPoint window displays all the slides that are added in the presentation.
  • Slides View Tab This tab displays a thumbnail view of all the slides.
  • Outline View Tab This tab displays the text contained in the presentation in an outline format.
  • Notes Section This can be used for creating notes.
  • Status Bar It displays the number of the slide that is currently being displayed.

PowerPoint Views
Different types of views available in PowerPoint 2007 are explained below

  • Normal View This is the main editing view, where you write and design your presentations, i.e. actual screen which is displayed.
  • Slide Sorter View It provides a view of slides in thumbnail form. This view makes it easy to sort and organise the sequence of the slides at the time of creating presentation and also, at the time of preparing presentation for printing.
  • Notes Page View In the Notes Page view, the notes pane is located just below the slide pane. Here, notes that apply to the current slide can be typed. Later, these notes can be printed and referred while giving actual presentation.
    Notes can also be printed to handout to the audience or included in a presentation that is delivered to the audience or posted on a Web page. When it is required to view and work with notes in full page format, on the view tab in the Presentation views group, click notes pay.
  • Slide Show View This is used to deliver a presentation to the audience. Slide Show view takes up the full computer screen, like an actual presentation. In this view, you can see your presentation, the way audience wants. This view enables you to see how graphics, timings, movies, animated effects and transition effects will look during the actual presentation. To exit Slide Show view, press Esc key from the keyboard.
  • Master View The Master views include Slide view, Handout view and Notes view. They are the main slides that store information about the presentation, including background color, fonts effects, placeholder sizes and positions.

Shortcut Keys of Microsoft PowerPoint and their Descriptions

Shortcut Keys Description
F5 View the Slide Show.
Shift + Ctrl + Home Selects all text from the cursor to the start of the active text box.
Shift + Ctrl + End Selects all text from the cursor to the end of the active text box.
Spacebar or Click the mouse Move to next slide or next animation.
S Stop the show press S again to restart the show.
Esc End the slide show.
Shortcut Keys Description
Ctrl + A Select all items on the page or the active text box.
Ctrl + B Applies bold to the selected text.
Ctrl + D Duplicates the selected object.
Ctrl + F Opens the Find dialog box.
Ctrl + G Opens the Grids and Guides dialog box.
Ctrl + H Opens the Replace dialog box.
Ctrl +1 Applies Italics to the selected text.
Ctrl + M Inserts a new slide.
Ctrl + N Opens a new blank presentations.
Ctrl + O Opens the open dialog box.
Ctrl + T Opens the Font dialog box.
Ctrl + U Applies underlining to the selected text.
Ctrl + V Paste
Ctrl + W Closes the presentation.
Ctrl + Y Repeats the last command entered.
Home Move cursor to beginning of current line of text.
End Moves cursor to end of current line of text.
Ctrl + Home Moves cursor in beginning of presentations.
Ctrl + End Moves cursor to end of presentation.
Shift + Click Select more than one slide-in a
each side presentation.
Shift + F1 Help

Microsoft Access
A database is a collection of logically related and similar data. Database stores similar kind of data for a specific purpose that is organised in such a manner that any information can be derived from it, when needed. Microsoft Access is an application which allows the creating of databases. Microsoft Access is a Relational Database Management System (RDBMS). Access is a tool for managing the database. It allows you to design and create complete databases with quick and easy data entry, maintain them and search for information.

Start MS-Access
To start the MS-Access software, we need to Click Start button —> All Programs —> Microsoft Office —> Microsoft Office Access 2007.

Components of MS-Access
Within MS-Access there are four components

  1. Table It stores the data in your database.
  2. Queries get information from the data stored in the tables.
    There are five types of queries

    Query Type Description
    Select query Retrieves data from one or more tables and displays the recordset in a datasheet. This is the most common type of query.
    Parameter

    query

    		 Prompts the user to enter values that define the query, such as a specified region for sales results or a specified price range for houses.
    Cross-tab

    query

    		 Arranges a recordset to make it more easily visible, using both row headings and column headings.
    Action query Creates a new table or changes an existing table.
    SQL query An advanced query that is created by using an SQL statement.
  3. Reports allow printing of data, based on queries or tables created by the user.
  4. Forms make it easy to enter data in the tables. A form is an interface for adding and editing data.

MS-Access Templates
It is a complete tracking application with predefined tables, forms, reports, queries, macros and relationships. MS-Access includes a collection of database templates, which are described as

  1. Assets It is used to create an assets database to keep track of assets, including assets details and owners.
  2. Contacts It is used to create a contact database to manage information about people.
  3. Events It is used to create an events database for tracking upcoming meeting, dealings, etc.
  4. Faculty It is used to create a faculty database to keep track of information about contacts and education history.
  5. Marketing Projects It is used to create a marketing projects database to track time- sensitive deliverable and venlor status for project.
  6. Students It is used to create students database to keep information about your students including contacts, about their guardians.

Elements of MS-Access
In MS-Access, database holds five major elements for every database operation

  1. Field Name It is a label provided for a field that specifies the type of information contained in a particular field.
  2. Field Type/Data Type It specifies the type of data stored in the field such as textual data and numerical data or combination of both. The default size of data type is 50 in MS-Access.
    There are various data types as

    1. computer-awareness-study-material-microsoft-office-5
  3. Field Length Field refers length or width to the maximum number of characters that a field can contain.
  4. Primary Key A field which is used to uniquely identify the records in a table. The primary key cannot contain null value.
  5. Validation Rule It is a condition that must be met before data is accepted into database.
  6. MS-Access View You can create a table by two most popular ways
    1. Datasheet View It shows the data in the database and also allows you to enter and edit the data but not allow to change the database.
    2. Design View It allows you to create or change the table and also set the keys.
  7. Filtering Data It enables to display only those records in a table that meet a specified filter criterion.
  8. Relationship It is an association between access tables or queries that use related fields. It is a link between tables and enables us to accessed data from both tables simultaneously.
    Relationship can be divided in three catogories as One-to-One, One-to-Many and Many-to-Many
  9. Attributes These can be defined as the characteristics of an entity to identify it uniquely. Such as student’s attributes are his Roll-No, Section, Name, etc.

Shortcut Keys of MS-Access and Their Descriptions
Working with Database Object

Shortcut Keys Description
Ctrl + N Create a new database.
Ctrl + O Open an existing database.
Alt + N Create a new database object.
Alt + O Open database object.
Ctrl + S Save a database object.
Ctrl + P Print the current or selected object
Ctrl + C Copy the selected object.
Ctrl + X Cut the selected object.
Ctrl + V Paste object.
Delete Delete an object.

Working with Tables

Shortcut Keys Description
Ctrl + Plus sign (+) Add a new record.
Ctrl + semicolon(;) Insert the current date.
Ctrl + Shift+Colon(:) Insert the current time.
Ctrl + Alt + Spacebar Insert the default value for a field.
Ctrl + Apostrophe(‘) Insert the value from the same field in the previous record.
Ctrl + A Select all records.
Ctrl + Minus sign (-) Delete the current record.
Esc Undo changes made to the current field.
Esc Undo changes made to the current record.

Navigation in a Table

Shortcut Keys Description
Tab Next field
Shift + tab Previous field
Page down Next screen
Page up Previous screen
Ctrl + T First record
Ctrl +1 Last record
i Next record
T Previous record

Design View

Shortcut Keys Description
Alt + D Open a database object in design view.
Alt + Enter Display a property sheet in design view
Alt + V + P Open property sheet for the selected object in design view.

Common Task

Shortcut Keys Description
Ctrl + B Bold letters
Ctrl +1 Italicise letters
Ctrl + U Underline letters
Ctrl + F Find text
Ctrl + H Replace text
F5 Refresh
F2 Rename
Ctrl + A Select All
Ctrl + Y Redo Last Action
Ctrl + Z Undo Last Action
Ctrl + W Close the active window
FI Open Microsoft Access help
Ctrl + Shift + A Sort selected data in ascending order
Ctrl + Shift + Z Sort selected data in descending order
F7 Check spelling

Microsoft Outlook
It is an E-mail client and personal information manager that is available as a part of Microsoft Office suite. Windows mobile devices are the version of MS-Outlook, enables users to synch­ronise their E-mails data to their smartphones. MS-Outlook It can work with Microsoft exchange server and microsoft sharepoint server for multiple users in an organisation such as shared mailboxes, calendars, exchange public folders, sharepoint lists and meeting schedules.

QUESTION BANK

1. Microsoft Office was developed by ………… in …………..

  1. Microsoft Inc, 1970s
  2. Microsoft Inc, 1980s
  3. Sun Microsoft, 1980s
  4. Sun Microsoft Inc, 1970s
  5. None of the above

2. Which of the following is a basic software of MS-Office?

  1. MS-Word
  2. MS-Excel
  3. MS-PowerPoint
  4. MS-Access
  5. All of the above

3. MS-Word is an

  1. tabular data formatting software
  2. Word processing software
  3. presentation software
  4. E-mail client
  5. database management system

4. The first bar of MS-Word is

  1. menu bar
  2. status bar
  3. title bar
  4. formatting toolbar
  5. standard toolbar

5. Shortcut for displaying the full page as they are printed.

  1. Ctrl + F1
  2. Ctrl + F2
  3. Shift + F1
  4. Shift + F2
  5. Alt + F2

6. Which bar is usually located below title bar that provides categorised options?

  1. Menu bar
  2. Status bar
  3. Tool bar
  4. Scroll bar
  5. None of these

7. Which is the shortcut key to display Open dialog box?

  1. F12
  2. Shift + F12
  3. Alt + F12
  4. Ctrl + F12
  5. None of these

8. Where you can find the horizontal split bar on MS-Word screen?

  1. On the left of horizontal scroll bar
  2. On the right of horizontal scroll bar
  3. On the top of vertical scroll bar
  4. On the bottom of vertical scroll bar
  5. None of the above

9. To open a new file in MS-Word, the shortcut key is

  1. Ctrl + X
  2. Ctrl + N
  3. Ctrl + Y
  4. Ctrl + V
  5. None of the above

10. Which extension is given to Word document by default?

  1. .exe
  2. .com
  3. .doc
  4. All of these
  5. None of these

11. You can start Microsoft Word by using which button?                                             ‘

  1. New
  2. Start
  3. Program
  4. All of these
  5. None of these

12. Which of the following is not an option of Edit menu?

  1. Cut
  2. Copy
  3. Paste
  4. Page Setup
  5. None of these

13. When you start MS-Word, the opening document has the name as

  1. DOC 1
  2. Document 1
  3. Document
  4. Workbook
  5. Taskbook

14. After selecting the ‘Replace’ option from the Edit menu, the following dialog box will be appears.

  1. Replace
  2. Find
  3. Find and replace
  4. Edit
  5. None of these

15. Blinking point which shows your position in the text is called?

  1. cursor
  2. blinker
  3. position
  4. states
  5. place

16. Microsoft Office Word is a(n)

  1. area in the computer’s main memory in which Microsoft Office text files are stored temporarily
  2. program included with Windows 2000 that can be used only to create or edit text files, smaller than 64k, that do not require formatting
  3. classified password that prevents unauthorised users from accessing a protected Microsoft Office item or document
  4. full featured Word processing program that can be used to create and revise professional looking documents easily
  5. None of the above

17. In MS-Word, the default alignment for paragraph is

  1. left aligned
  2. centered
  3. right aligned
  4. justified
  5. None of these

18. Which of the following is not available on the ruler of MS-Word screen?

  1. Left indent
  2. Right indent
  3. Centre indent
  4. All of these
  5. None of these

19. To save an existing document with a different file name, click

  1. save button on the standard toolbar
  2. save on the file menu
  3. save as button on the standard toolbar
  4. Save As on the file menu
  5. None of the above

20. To increase the line spacing, use the shortcut keys.

  1. Ctrl + L
  2. Ctrl + E
  3. Ctrl + I
  4. Ctrl + M
  5. Ctrl + S

21. Word has a list of predefined typing, spelling, capitalisation and grammar errors that  can defect and correct.

  1. autoentry
  2. autocorrect
  3. autoadd
  4. autospell
  5. autoword

22. Which of the following is not a font style?

  1. Bold
  2. Italic
  3. Regular
  4. Super script
  5. Bold-Italic

23. Portrait and landscape are

  1. page orientation
  2. paper size
  3. page layout
  4. page margin
  5. page gap

24. Which of the following should be used to move a paragraph from one place to another in a Word document?

  1. Copy and paste
  2. Cut and paste
  3. Delete and retype
  4. Find and replace
  5. None of these

25. To move the text from its original position to another position without deleting it is called

  1. scrolling
  2. searching
  3. moving
  4. copying
  5. halting

26. Which of the following displays the buttons for changing text style, alignment and size?

  1. Standard toolbar
  2. Status bar
  3. Drawing toolbar
  4. Formatting toolbar
  5. None of these

27. Where header appears?

  1. Top
  2. Bottom
  3. Centre
  4. All of these
  5. None of these

28. Most of the editing tools are available under which menu?

  1. File
  2. Format
  3. Edit
  4. All of these
  5. None of these

29. For printing a document you have to put on

  1. Printer
  2. Monitor
  3. Scanner
  4. All of these
  5. None of these

30. To move to the beginning of a line of text, press the ………. key.

  1. Page up
  2. a
  3. Home
  4. Enter
  5. None of these

31. A program which helps to create written documents and lets you go back and make corrections as necessary.

  1. Spreadsheet
  2. Personal writer
  3. Word printer
  4. Word processor
  5. None of these

32. When computer users ………. a document, they change its appearance.

  1. Edit
  2. Create
  3. Save
  4. Format
  5. None of these

33. Shortcut to create new directory, is

  1. Ctrl + F
  2. Ctrl + W
  3. Ctrl + Shift + F
  4. Ctrl + Shift + H
  5. Ctrl + Shift + N

34. In Word, the Replace option is available on

  1. File menu
  2. Edit menu
  3. Insert menu
  4. View menu
  5. Format menu

35. When working in the page break preview, you can

  1. View exactly where each page break occurs
  2. Add or remove page breaks
  3. Change the print area
  4. All of the above
  5. None of the above

36. Cut operation can also be accomplished by using the shortcut key

  1. Ctrl + X
  2. Ctrl + Y
  3. Ctrl + V
  4. Ctrl + A
  5. None of these

37. Ctrl, Shift and Alt are called ……….. keys.

  1. Modifier
  2. Function
  3. Alphanumeric
  4. Adjustment
  5. None of these

38. A …………. is an additional set of commands that the computer displays after you make a selection from main menu. [SBI Clerk 2009]

  1. dialog box
  2. sub menu
  3. menu selection
  4. All of these
  5. None of these

39. Which of the following is not a term pertaining to Word? [IBPS Clerk 2011]

  1. Delete
  2. Edit
  3. Copy
  4. Slide show
  5. None of these

40. What is the shortcut key for centering the text selected by the user in Word? [IBPS Clerk 2011]

  1. Ctrl + A
  2. Ctrl + B
  3. Ctrl + C
  4. Ctrl + D
  5. Ctrl + E

41. A Word processor would be used best to [IBPS Clerk 2011]

  1. paint a picture
  2. draw a diagram
  3. type a story
  4. work out income and expenses
  5. None of the above

42. In order to choose the font for a sentence in a Word document [IBPS Clerk 2011]

  1. select Font in the Format menu
  2. select Font in the Edit menu
  3. select Font in the Tools menu
  4. select Font in the View menu
  5. None of the above

43. In Word, you can force a page break  [IBPS PO 2011]

  1. by positioning your cursor at the appropriate place and pressing the F1 key
  2. by positioning your cursor at the appropriate place and pressing the Ctrl+Enter
  3. by using the insert/section break
  4. by changing the font size of your document
  5. None of the above

44. Which of the following can be used to select entire document? [IBPS PO 2011]

  1. Ctrl + A
  2. Alt + F5
  3. Shift + A
  4. Ctrl + K
  5. Ctrl + H

45. How many ways you can save a document?             [SBI PO 2012]

  1. 3
  2. 4
  3. 5
  4. 6
  5. 8

46. Which of the following justification align the text on both the sides left and right of margin?       [IBPS Clerk 2012]

  1. Right
  2. Justify
  3. Both sides
  4. Balanced
  5. None of the above

47. The shortcut key to print documents is [IBPS PO 2012]

  1. Ctrl + D
  2. Ctrl + A
  3. Ctrl + B
  4. Ctrl + C
  5. Ctrl + P

48. You specify the save details of your file in the                    [RBI Grade B 2013]

  1. “Save as a file” dialog box
  2. “Save the file as” dialog
  3. “File save” dialog box
  4. Any of ‘1’ and ‘2’
  5. None of the above

49. Which of the following can be used to select the entire document? [IBPS Clerk 2013]

  1. Ctrl + A
  2. Alt + F5
  3. Shift + A
  4. Ctrl + K
  5. Ctrl + H

50. This program is made by Microsoft and embedded with Windows and used to view Web document.           [RBI Grade B 2013]

  1. Netscape
  2. Outlook Express
  3. Internet Explorer
  4. MS-Word
  5. None of these

51. When entering text within a document, the Enter key is normally pressed at the end of every [IBPS PO 2011, IBPS Clerk 2013]

  1. line
  2. sentence
  3. paragraph
  4. word
  5. file

52. In which menu we will find the command document?            [RBI Grade B 2013]

  1. File
  2. Insert
  3. Tools
  4. Data
  5. None of these

53. Which is the shortcut key to reach View menu?                        [RBI Grade B 2013]

  1. Ctrl + V
  2. Alt + W
  3. F4
  4. Alt + V
  5. None of these

54. Soft page breaks [RBI Grade B 2013]

  1. Are induced by the user
  2. Are inserted by Word automatically at the end of the page
  3. Can be deleted
  4. Are the one to show end of paragraph
  5. None of the above

55. The process of making changes to an existing document is referred to as …….. it.  [SBI Clerk 2014]

  1. Editing
  2. Changing
  3. Modifying
  4. Creating
  5. Adjusting

56. To move to the bottom of a document while working on MS-Word, which command is used?      [IBPS Clerk 14]

  1. Home key
  2. End key
  3. Ctrl + Page Down
  4. Insert key
  5. Ctrl key + End key

57. To undo the last work, we have to use which of the following Windows shortcut key?    [SBI PO 2014]

  1. Ctrl + P
  2. Ctrl + U
  3. Ctrl + A
  4. Ctrl + Z
  5. Ctrl + W

58. Shortcut key to go to last line in the document             [SBI PO 2014]

  1. Ctrl + Last
  2. Ctrl + L
  3. Ctrl + End
  4. Alt + End
  5. Alt + L

59. About margins [RBI Grade B 2014]

  1. all sections in a document need to have same margin
  2. different section can have different margins
  3. Word have predefined margins settings for all documents
  4. can’t say, depend on the version of Word
  5. None of the above

60. What is the default file extension for all Word documents? [RBI Grade B 2012, IBPS Clerk 2014]

  1. WRD
  2. TXT
  3. DOC
  4. FIL
  5. WD

61. Auto-text can be used to insert ……… in document.              [RBI Grade B 2014]

  1. Test
  2. Graphics
  3. Any of the two
  4. Both ‘1’and‘2’
  5. None of these

62. Editing a document that has been created means                   [IBPS Clerk 2015]

  1. saving it
  2. printing it
  3. scanning it
  4. correcting it
  5. None of these

63. In order to delete a sentence from a document you would use  [IBPS Clerk 2015]

  1. Highlight and copy
  2. Cut and paste
  3. Copy and paste
  4. Highlight and delete
  5. Select and paste

64. Keyboard shortcut for CUT command is  [SBI Clerk 2015]

  1. Ctrl + W
  2. Ctrl + Y
  3. Ctrl + Z
  4. Ctrl + X
  5. Ctrl + V

65. What is MS-Word? [SBI Clerk 2015]

  • It is a calculating tool
  • It is a planning tool
  • It is a chart
  • It is a networking tool
  • It is a document typing tool

66. Microsoft World is a word processor developed by Microsoft. In MS-Word Spelling Check is a feature available in which tab?               [IBPS PO 2016]

  1. File
  2. Home
  3. Insert
  4. Review
  5. References

67. MS-Word is a text or document editing application program that comes in the package of MS-Office Suite. Which among the given options is not related with MS-Word?              [IBPS PO 2016]

  1. Page Layout
  2. Antivirus
  3. Maillings
  4. Format Painter
  5. SmartArt

ANSWERS

computer-awareness-study-material-microsoft-office-6

Leave a Reply

Your email address will not be published. Required fields are marked *

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp