MS Office MCQ Questions with Answers

Question. Which is the shortcut key to jump to the first slide of the presentation?
(a) Home
(b) Alt + Home
(c) Ctrl + Home
(d) Shift + Home
(e) Shift + 1

Answer : C

Question. The default header for a worksheet is _________.
(a) Your name
(b) The date and time
(c) None
(d) The sheet tab name
(e) 1, 2 and 4

Answer : C

Question. Which function will calculate the number of workdays between 6/9/2005 and 8/12/2005?
(a) Workday
(b) Date
(c) Network days
(d) All of the above
(e) None of these

Answer : D

Question. Worksheets in work book of Excel are selected by clicking the mouse and by pressing -
(a) Alt
(b) Enter
(c) Ctrl
(d) Shift
(e) None of these

Answer : C

Question. Which of the following appropriate the extension of word pad?
(a) .xls
(b) .doc
(c) .docx
(d) 2 & 3 both
(e) None of these

Answer : E

Question. Which key is used to indent a paragraph in MS Word -
(a) F1
(b) Shift
(c) Tab
(d) Alt
(e) None of these

Answer : C

Question. To start a slideshow in power point which key is used .
(a) F1
(b) F2
(c) F3
(d) F4
(e) F5

Answer : E

Question. You can add an image to a template by clicking the Insert Picture From File button on the _______toolbar.
(a) Illustration
(b) Charts
(c) Links
(d) Table
(e) Text

Answer : A

Question. Font dialog box is available in _______.
(a) Formatting bar
(b) Status bar
(c) Menu bar
(d) Title bar
(e) None of these

Answer : A

Question. In MS word, new paragraph is created by pressing.
(a) Alt
(b) Ctrl
(c) Shift
(d) Tab
(e) None of these

Answer : E

Question. Microsoft Word is an example of _________
(a) An operating system
(b) a processing device
(c) Application software
(d) an input device
(e) None of these

Answer : C

Question. In Normal view, this tab displays the content of each slide.
(a) Slides
(b) View
(c) Sort
(d) Outline
(e) Both 1 and 4

Answer : D

Question. You can use the format painter multiple times before you turn it off by _______.
(a) You can use the format painter button only one time when you click it
(b) Double clicking the format painter button
(c) Pressing the Ctrl key and clicking the format painter button
(d) Pressing Alt key and clicking the format painter button
(e) Both 2 and3

Answer : B

Question. A (n) _______ contain commands that can be selected ?
(a) Pointer
(b) menu
(c) icon
(d) button
(e) None of these

Answer : B

Question. Microsoft PowerPoint can insert objects from the following add-ins?
(a) Equation Editor
(b) Organization Chart
(c) Photo Album
(d) All of these
(e) None of these

Answer : D

Question. The document can be zoomed maximum up to –
(a) 100%
(b) 150%
(c) 200%
(d) 500%
(e) None of these

Answer : D

Question. Can edit an already inserted embedded organization chart object by _____.
(a) Double Click on the organization chart object.
(b) CTRL + Click on the organization chart object
(c) SHIFT + Click on the organization chart object
(d) Single Click on the organization chart object
(e) None of the above

Answer : A

Question. The software which contains rows and columns is called ______.
(a) Data base
(b) Drawing
(c) Spread sheet
(d) Word Processing
(e) None of these

Answer : C

Question. Shortcut key to insert worksheet in micrsoft excel
(a) Ctrl+W
(b) Ctrl+IW
(c) Alt+1W
(d) Ctrl+N
(e) Alt+NW

Answer : D

Question. Which type of file is created by word processing program?
(a) Data base file
(b) Storage file
(c) Word file
(d) Document file
(e) None of these

Answer : D

Question. Shortcut key to insert a hyperlink in a slide _____.
(a) Ctrl + H
(b) Ctrl + K
(c) Hyperlinks can’t be inserted in slides
(d) Alt + K
(e) None of the above

Answer : B

Question. To draw the Square box in the slide by selecting rectangle tool and _____.
(a) Holding CTRL & Draw
(b) Holding ALT & Draw
(c) Holding SHIFT & Draw
(d) All of the above
(e) None of these

Answer : C

Question. The default page size for word document is –
(a) letter
(b) legal
(c) A4
(d) All
(e) None of these

Answer : C

Question. You can not link Excel worksheet data to a Word document
(a) With the right drag method
(b) With a hyperlink
(c) With the copy and paste special commands
(d) With the copy and paste buttons on the standard toolbar
(e) None of these

Answer : D

Question. _____ type of software is similar to an accountant’s worksheet.
(a) Word processing
(b) Database
(c) Spreadsheets
(d) Graphics
(e) Presentation

Answer : C

Question. To select more than one slide in the presentation, ______.
(a) Just Click on slide
(b) Ctrl + Click on slide
(c) Alt + Click on slide
(d) Shift + Click on slide
(e) Alt + Shift + Click on slide

Answer : B

Question. Changing an existing document is called ____ the document.
(a) Editing
(b) Creating
(c) Modifying
(d) Adjusting
(e) None of these

Answer : A

Question. When creating a vertical page break _______.
(a) The active cell must be A1
(b) The active cell can be anywhere in the worksheet
(c) The active cell must be in row 1
(d) The active cell must be in column A
(e) None of these

Answer : C

Question. Replace command is available on -
(a) File menu
(b) View menu
(c) Edit menu
(d) Format menu
(e) None of these

Answer : C

Question. Text and graphics that have been cut or copied are stored in an area called the ______
(a) Pasteboard
(b) copy board
(c) clipboard
(d) cutting board
(e) None of these

Answer : C

Question. Weight refers to ________.
(a) The print density of characters
(b) The height of the printed character
(c) Upright or slanted shape
(d) The design and appearance of character
(e) None of these

Answer : A

Question. Which shortcut key is used to replace any text in MS word -
(a) Ctrl + F
(b) Ctrl + G
(c) Ctrl + H
(d) Ctrl + V
(e) None of these

Answer : C

Question. The Name box _______.
(a) Shows the location of the previously active cell
(b) Appears to the left of the formula bar
(c) Appears below the status bar
(d) Appears below the menu bar
(e) None of these

Answer : B

Question. Edit » Delete command ________.
(a) Deletes Formats of cell
(b) Deletes the content of a cell
(c) Deletes the comment of cell
(d) Deletes selected cells
(e) None of these

Answer : D

Question. To move the beginning of a line of text,press the ___ key.
(a) Home
(b) Enter
(c) Page up
(d) Alt
(e) None of these

Answer : A

Question. Which of the following is not a basic step in creating a worksheet?
(a) Save the workbook
(b) Modify the worksheet
(c) Enter text and data
(d) Copy the worksheet
(e) None of these

Answer : D

Question. To prepare a presentation /slide show which application is commonly used?
(a) Photoshop
(b) Powerpoint
(c) Outlook
(d) Internet explorer
(e) All of these

Answer : B

Question. You can activate a cell by ________.
(a) Pressing the Tab key
(b) Clicking the cell
(c) Pressing an arrow key
(d) All of above
(e) None of these

Answer : D

Question. When the formula bar is activated, you can see _________.
(a) The Edit Formula button
(b) The Cancel button
(c) The Enter button
(d) All of above
(e) None of these

Answer : D

Question. Which of the following option is used to paste the text.
(a)Shift+insert
(b) Ctrl + insert
(c) Shift + delete
(d) Ctrl + delete
(e) None of these

Answer : A

Question. To place something in the same position on every slide of presentation automatically, insert into ______.
(a) Slide master
(b) Notes master
(c) Handout master
(d) All
(e) None of the above

Answer : A

Question. Which one of the following is not an item of menu bar in Excel-
(a) Root
(b) Tool
(c) Data
(d) Window
(e) None of these

Answer : A

Question. What is the maximum zoom percentage in Microsoft PowerPoint?
(a) 100
(b) 200
(c) 300
(d) 400
(e) 500

Answer : D

Question. In a worksheet you can select _______.
(a) The entire worksheet
(b) Rows
(c) Columns
(d) Sheet Tab
(e) 1, 2, and 3

Answer : E

Question. When you print preview a worksheet?
(a) The entire worksheet is displayed
(b) The selected range is displayed
(c) The active portion of the worksheet is displayed
(d) 1, 2 and 3
(e) None of these

Answer : D

Question. Which type of template provides a design concept, fonts & color scheme for presentation?
(a) Format
(b) Design
(c) Content
(d) Normal
(e) Master

Answer : B

Question. Data marker on a chart are linked to data points in a worksheet, therefore,
(a) You can automatically apply formatting to a data series
(b) You can change the position of a data marker and automatically change the data point value in the worksheet
(c) You can change a data print value and automatically are draw the chart
(d) 1 and 2
(e) None of these

Answer : B

Question. ____ is a kind of software used to keep track of billing account.
(a) Word processing
(b) Spreadsheed
(c) Electronic publishing
(d) Web authority
(e) None of these

Answer : B

Question. When you group worksheets ________.
(a) You can enter variable data on multiple worksheets at one time
(b) You can print more than one worksheet at a time
(c) You can enter common data, formats, and formulas on multiple worksheets at one time
(d) 2, and 3
(e) None of these

Answer : D

Question. To drag a selected range of data to another worksheet in the same workbook, use the ______.
(a) Tab key
(b) Alt key
(c) Shift key
(d) Ctrl key
(e) Page up/down

Answer : D

Question. A letterhead should contain all of the following EXCEPT ____.
(a) Full street address
(b) Logo
(c) Complete legal name of the company, group, or individual
(d) All
(e) None of these

Answer : E

Question. PowerPoint design templates are stored in a file with this extension.
(a) .ptt
(b) .pot
(c) .ppt
(d) .dtp
(e) .ptp

Answer : C

Question. _____ is the menu command used to apply a design template in PowerPoint.
(a) Tools -> Slide Design
(b) Format -> Slide Design
(c) Design -> Slide Design
(d) Insert -> Slide Design
(e) Animation -> Slide Design

Answer : B

Question. ______ task pane shows the design that is currently being used in a presentation.
(a) Slide Show
(b) Slide Style
(c) Slide Design
(d) Slide Format
(e) Master Slide

Answer : C

Question. The key F12 opens a ________.
(a) Save As dialog box
(b) Open dialog box
(c) Save dialog box
(d) Close dialog box
(e) Print dialog box

Answer : A

Question. Where can you change the vertical alignment?
(a) Formatting toolbar
(b) Paragraph dialog box
(c) Page Setup dialog box
(d) Standard toolbar
(e) Header and Footer

Answer : C

Question. Headers and footers can include text and graphics, as well as the _____.
(a) Current date,
(b) Page number
(c) Current time.
(d) All of the above
(e) None of these

Answer : D

Question. Which tab in Font dialog box contains options to apply font effects?
(a) Font tab
(b) Character Spacing
(c) Text Effects
(d) Standard Toolbar
(e) Character Effects

Answer : A

Question. Ctrl + PageUp’ is used to ______.
(a) Moves the cursor one Page Up
(b) Moves the cursor one Paragraph Up
(c) Moves the cursor one Screen Up
(d) Moves the cursor one Line Up
(e) None of these

Answer : A

Question. Which key do you press to check spelling?
(a) F3
(b) F5
(c) F7
(d) F9
(e) F2

Answer : C

Question. Pressing the _____ key instructs Word to replace an AutoText entry name with the stored AutoText entry.
(a) F1
(b) F2
(c) F3
(d) F4
(e) F5

Answer : B

Question. What do you mean by vertical separation between columns?
(a) Orientation
(b) Gutter
(c) Margin
(d) Index
(e) Vertical

Answer : C

Question. Which feature is used for monitoring all document changes?
(a) Edit Document
(b) Monitor Change
(c) Track Change
(d) Track all
(e) Save

Answer : C

Question. In Power Point, ______ is a container for text or graphics.
(a)Slide master
(b) Table
(c) Placeholder
(d) Text box
(e) All

Answer : D

Question. To verify that the note text is positioned correctly on the page, switch to _____ view or display the document in print preview.
(a) Normal
(b) Print layout
(c) Page layout
(d) Page edit
(e) Paragraph

Answer : B

Question. The _____ is a short horizontal line indicating the conclusion of a document.
(a) Insertion point
(b) End mark
(c) Status indicator
(d) Scroll box
(e) None of these

Answer : B

Question. From the following alignment which can not be in the tabs stop position?
(a) Decimal Alignment
(b) Center Alignment
(c) Bar Alignment
(d) Justify Alignment
(e) None of these

Answer : D

Question. Which of the following commands you should always use before submitting a document to others?
(a) Find command
(b) Replace command
(c) Spelling and Grammar
(d) Thesaurus
(e) Page number

Answer : C

Question. In PowerPoint, when the mouse pointer appears as ___, it indicates that the Draw Table feature is on.
(a) Solid plus sign
(b) Solid arrow
(c) I-beam
(d) Pencil
(e) Timer shape

Answer : D

Question. In Word, the mailing list is known as the _________.
(a) Data sheet
(b) Source
(c) Data source
(d) Sheet
(e) Data mail

Answer : C

Question. The spelling dialog box can be involved by choosing spelling from ________ menu.
(a) Insert
(b) File
(c) Tools
(d) View
(e) Font

Answer : C

Question. If you need to change the typeface of a document, which menu will you choose?
(a) Edit
(b) View
(c) Insert
(d) Tools
(e) Format

Answer : E

Question. To cancel a job that is printing or one that is waiting to be printed _____.
(a) Click the Print button on the Standard toolbar
(b) Click the printer icon on the taskbar
(c) Double-click the Print button on the Standard toolbar
(d) Double-click the printer icon on the taskbar
(e) None of these

Answer : B

Question. Which is not one of the view options provided by Power Point to look at and modify presentation?
(a) Slide Show
(b) Format Slide
(c) Slide Sorter
(d) Normal
(e) None of these

Answer : B

Question. How can you insert a sound file in your word document?
(a) From insert -> sound menu option
(b) From insert -> file menu option
(c) From insert -> object menu option
(d) From insert -> Clip Art menu option
(e) None of These

Answer : C

Question. What happens when you click on Insert >> Picture >> Clip Art
(a) It inserts a clipart picture into document
(b) It lets you choose clipart to insert into document
(c) It opens Clip Art task pane
(d) Both 1 and 2
(e) None of above

Answer : C

Question. What is place to the left of horizontal scroll bar?
(a) Indicators
(b) View buttons
(c) Tab stop buttons
(d) Split buttons
(e) None of these

Answer : B

Question. Which is the menu command to recolor a picture on a slide?
(a) Insert -> Picture -> Recolor
(b) Tools -> Picture -> Recolor
(c) Format -> Picture -> Recolor
(d) Edit -> Picture -> Recolor
(e) Design->Picture->Recolor

Answer : C

Question. Macros are_______.
(a) Small programs created in MS-Word to automate repetitive tasks by using VBA
(b) Small add-on programs that are installed afterwards if you need them
(c) Programming language that you can use to customize MS-Word
(d) Large tools in Word such as mail merge
(e) None of these

Answer : A

Question. Which is the menu to create a text box on a slide?
(a) View -> Text Box
(b) Tools -> Text Box
(c) Insert -> Text Box
(d) Format -> Text Box
(e) Home-> Text Box

Answer : C

Question. Which enables us to send the same letter to different persons?
(a) macros
(b) template
(c) mail merge
(d) mail mix
(e) None of these

Answer : C

Question. Which of the following option appropriate for the extension of MS- Word files?
(a) .fil
(b) .dot
(c) .rtf
(d) .wrd
(e) None of these

Answer : E

Question. A bookmark is an item or location in document that you identify a name for future reference. Which of the following task is accomplished by using bookmarks?
(a) To add hyperlinks in a web page
(b) To quickly jump to a specific location in the document
(c) To mark the ending of a page of document
(d) To add address in a web page
(e) None of These

Answer : B

Question. What is the shortcut key to ‘Insert Hyperlink’ in a document? (a) Ctrl + H
(b) Ctrl + L
(c) Ctrl + K
(d) Alt+ K
(e) Alt + H

Answer : C

Question. What is the default number of lines to drop for drop cap?
(a) 2
(b) 5
(c) 10
(d) 15
(e) None of these

Answer : E

Question. What is the maximum number of lines you can set for a drop cap?
(a) 10
(b) 25
(c) 20
(d) 15
(e) Undefine

Answer : A

Question. Thesaurus tool in MS Word is used for _______.
(a) Spelling suggestions
(b) Grammar options
(c) Synonyms and Antonyms words
(d) Only for spelling and grammar
(e) All of above

Answer : B

Question. Why are headers and footers used in document?
(a) To mark large document more readable
(b) To mark the starting and ending of a page
(c) To enhance the overall appearance of the document
(d) To allow page headers and footers to appear on document when it is printed
(e) None of these

Answer : D

Question. Which of the following is not valid version of MS Office?
(a) Office 2003
(b) Office Vista
(c) Office 2007
(d) Office 2013
(e) Office XP

Answer : B

Question. What feature helps you to inserts the contents of the Clipboard as text without any formatting in MS Word?
(a)Paste Special
(b) Page setup
(c) Styles
(d) Format Painter
(e) None of these

Answer : A

Question. A template stores _______.
(a) Graphics, text, styles, macros
(b) Customized word command setting
(c) Auto text entries
(d) All of above
(e) None of these

Answer : D