MS Office MCQs 170+ MCQs
- From which menu you can insert Header and Footer?
- Insert Menu
- View Menu
- Format menu
- Tools Menu
- To get to the ‘Symbol’ dialog box, click on the menu and choose ‘Symbol’.
- Insert
- Format
- Tools
- Table
- option from clipboard is used to move data from one place to another in a
- Copy & Paste
- Cut & Paste
- Bold
- Justify
- is an option in Font Group.
- Strikethrough
- Fin
- Replace
- Change Styles
- Name the button in the picture?
- Font Color
- Fill Color
- Page Color
- Highlighter tool
- Shortcut for document views toolbar is situated in
- Task bar
- Status bar
- Tool bar
- Title bar
- Bullets and Numbering is in
- Home tab
- Insert tab
- Pagelayout tab
- View tab
- To open a existing document, click on the and then select Open.
- MS Office button
- Quick Access Toolbar
- Document Views
- Ribbon
- Cut, Copy and Paste is in Group in the Home tab.
- Font
- Page Setup
- Clipboard
- Editing
- is used to covert from upper case to lower case and vice versa.
- Toggle case
- Sentence case
- Lower case
- Upper case
- Pressing F8 key for three times selects
- A word
- A sentence
- A paragraph
- Entire document
- What is the shortcut key you can press to create a copyright symbol?
- Alt+Ctrl+C
- Alt + C
- Ctrl + C
- Ctrl + Shift + C
- What is the smallest and largest font size available in Font Size tool on formatting toolbar?
- 8 and 72
- 8 and 64
- 12 and 72
- None of above
- Which of the following is graphics solution for Word Processors?
- Clipart
- WordArt
- Drop Cap
- All of above
- A The keystrokes Ctrl + I is used to
- Increase font size
- Inserts a line break
- Indicate the text should be bold
- Applies italic format to selected text
- A character that is raised and smaller above the baseline is known as
- Outlined
- Raised
- Superscript
- Subscript
- Thesaurus tool in MS Word is used for
- Spelling suggestions
- Grammar options
- Synonyms and Antonyms words
- All of above
- Why Drop Caps are used in document?
- To drop all the capital letters
- To automatically begin each paragraph with capital letter
- To begin a paragraph with a large dropped initial capital letter
- None of above
- A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?
- To add anchors in web page
- To mark the ending of a paragraph of document
- To quickly jump to specific location in document
- To add hyperlinks in webpage
- Which of the following is not valid version of MS Office?
- Office XP
- Office Vista
- Office 2007
- None of above
- You cannot close MS Word application by
- Choosing File menu then Exit submenu
- Press Alt+F4
- Click X button on title bar
- From File menu choose Close submenu
- The key F12 opens a
- Save As dialog box
- Open dialog box
- Save dialog box
- Close dialog box
- What is the short cut key to open the Open dialog box?
- F12
- Shift F12
- Alt + F12
- Ctrl + F12
- A feature of MS Word that saves the document automatically after certain interval is available on
- Save tab on Options dialog box
- Save As dialog box
- Both of above
- None of above
- Which of the following is not available on the Ruler of MS Word screen?
- Tab stop box
- Left Indent
- Right Indent
- Center Indent
- Which file starts MS Word?
- exe
- exe
- exe
- exe
- If you want to keep track of different editions of a document which features will you use?
- Editions
- Versions
- Track Change
- All of above
- Background color or effects applied on a document is not visible in
- Web layout view
- Print Layout view
- Reading View
- Print Preview
- What is a portion of a document in which you set certain page formatting options?
- Page
- Document
- Section
- Page Setup
- Borders can be applied to
- Cells
- Paragraph
- Text
- All of above
- Which of the following is not a type of page margin?
- Left
- Right
- Center
- Top
- What is the default left margin in Word 2003 document?
- 1″
- 25″
- 5″
- 2″
- Portrait and Landscape are
- Page Orientation
- Paper Size
- Page Layout
- All of above
- If you need to change the typeface of a document, which menu will you choose?
- Edit
- View
- Format
- Tools
- Which of the following is not a font style?
- Bold
- Italics
- Regular
- Superscript
- What happens when you click on Insert >> Picture >> Clip Art
- It inserts a clipart picture into document
- It lets you choose clipart to insert into document
- It opens Clip Art taskbar
- None of above
- Which option is not available in Insert Table Autofit behavior?
- Fixed Column Width
- AutoFit to Contents
- Autofit to Window
- Autofit to Column
- To autofit the width of column
- Double click the right border of column
- Double click the left border of column
- Double click the column header
- All of above
- Which of the following statement is false?
- You can set different header footer for even and odd pages
- You can set different page number formats for different sections
- You can set different header footer for first page of a section
- You can set different header and footer for last page of a section
- Where can you change the vertical alignment?
- Formatting toolbar
- Paragraph dialog box
- Page Setup dialog box
- Standard toolbar
- AutoCorrect was originally designed to replace words as you type.
- Short, repetitive
- Grammatically incorrect
- Misspelled
- None of the above
- Which of the following is the second step in creating a macro?
- Start recording
- Using your mouse or keyboard, perform the task you want to automate
- Assign a keyboard shortcut to the macro
- Give the macro a name
- In Word, the mailing list is known as the .
- Data sheet
- Source
- Data source
- Sheet
- Which of the following is not one of the three ‘Mail Merge Helper’ steps?
- Merge the two files
- Create the main document
- Set the mailing list parameters
- Create the data source
- Which of the following button will allow you to add, delete, or change records in your Data Source?
- ‘Data Source’ button
- ‘Edit’ button
- ‘Edit Data Source’ button
- ‘Data editing’ button
- It is possible to a data source before performing a merge.
- Create
- Modify
- Sort
- all of the above
- Comments can be added to cells using …..
- Edit -> Comments
- Insert -> Comment
- File -> Comments
- View –> Comments
- Which of the following is not a valid Zoom percentage in Excel?
- 10
- 100
- 300
- 500
- The spelling tool is placed on toolbar
- Standard
- Formatting
- Drawing
- Reviewing
- Which of the following is not a valid data type in Excel?
- Number
- Character
- Label
- Date/Time
- Comments put in cells are called …..
- Smart Tip
- Cell Tip
- Web Tip
- Soft Tip
- Which menu option can be used to split windows into two?
- Format -> Window
- View -> Window-> Split
- Window -> Split
- View –> Split
- You can activate a cell by
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- All of above
- When you use the fill effects in the format data series dialog box, you can not
- rotate text on the chart
- select a fore ground color
- select a pattern
- select a background color
- To insert three columns between columns D and E you would
- Select column D
- Select column E
- Select columns E, F and G
- Select columns D, E, and
- Hyperlinks cannot be
- Special shapes like stars and banners
- Drawing objects like rectangles ovals
- Pictures
- All can be hyperlinks
- You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
- Standard
- Formatting
- Drawing
- Picture
- To drag a selected range of data to another worksheet in the same workbook, use the
- Tab key
- Alt key
- Shift key
- Ctrl key
- When you print preview a worksheet
- the entire worksheet is displayed
- the selected range is displayed
- the active portion of the worksheet is displayed
- a, b and c
- You can open the Sort dialog box by choosing Sort from the ….. menu
- View
- Format
- Tools
- Data
- When working in the page break preview, you can
- view exactly where each page break occurs
- add or remove page breaks
- change the print area
- all of above
- Which of the following is not a valid Zoom percentage in Excel?
- 10
- 100
- 300
- 500
- The spelling tool is placed on toolbar
- Standard
- Formatting
- Drawing
- Reviewing
- Formatting a cell in Currency, you can specify
- Decimal Places
- Currency Symbol
- Both of above
- None of above
- Formatting a cell in Number format you can’t set
- Decimal Places
- Use 1000 separator
- Negative numbers
- Currency Symbol
- What is entered by the function =today()
- The date value for the day according to system clock
- The time value according to system clock
- Today’s date as Text format
- All of above
- Which function will you use to enter current time in a woksheet cell?
- =today()
- =now()
- =time()
- =currentTime()
- Merge cells option can be applied from
- Format Cells dialog box Alignment Tab
- Formatting toolbar
- Both of above
- None of above
- Which of the following format you can decide to apply or not in AutoFormat dialog box?
- Number format
- Border format
- Font format
- All of above
- How can you remove borders applied in cells?
- Choose None on Border tab of Format cells
- Open the list on Border tool in Formatting toolbar then choose first tool (no border)
- Both of above
- None of above
- You can set Page Border in Excel from
- From Border tab in Format Cells dialog box
- From Border tool in Formatting toolbar
- From Line Style tool in Drawing toolbar
- You can not set page border in Excel
- You can check the conditions against when applying conditional formatting
- Cell value
- Formula
- Both of above
- None of above
- When a range is selected, how can you activate the previous cell?
- Press the Alt key
- Press Tab
- Press Enter
- None of above
- Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
- work sheet
- chart sheet
- module sheet
- data sheet
- Which of the following Excel screen components can NOT be turned on or off?
- Formula Bar
- Status Bar
- Tool Bar
- None of above
- Which of the following option is not available in Paste Special dialog box?
- Add
- Subtract
- Divide
- SQRT
- Which of the cell pointer indicates that you can fill series?
- Doctor’s symbol (Big Plus)
- small thin plus icon
- Mouse Pointer with anchor at the tip
- None of above
- Which of the following is an absolute cell reference?
- !A!1
- $A$1
- #a#1
- A1
- Which symbol must all formula begin with?
- =
- +
- (
- @
- Which of the following formulas is not entered correctly?
- =10+50
- =B7*B1
- =B7+14
- 10+50
- Which of the following formulas will Excel Not be able to calculate?
- =SUM(Sales)-A3
- =SUM(A1:A5)*.5
- =SUM(A1:A5)/(10-10)
- =SUM(A1:A5)-10
- A worksheet range is a
- A command used for data modeling
- A range of values such as from 23 to 234
- A group of cells
- A group of worksheets
- The auto calculate feature
- Can only add values in a range of cells
- Provides a quick way to view the result of an arithmetic operation on a range of cells
- Automatically creates formulas and adds them to a worksheet
- A and c
- Excel uniquely identifies cells within a worksheet with a cell name
- Cell names
- Column numbers and row letters
- Column letters and row numbers
- Cell locator coordinates
- To drag a selected range of data to another worksheet in the same workbook, use the
- Tab key
- Alt key
- Shift key
- Ctrl key
- Hyperlinks can be
- Text
- Drawing objects
- Pictures
- All of above
- To activate the previous cell in a pre-selected range, press
- The Alt key
- The Tab key
- The Enter key
- None of the above
- Which button do yu click to add up a series of numbers?
- The autosum button
- The Formula button
- The quicktotal button
- The total button
- When the formula bar is active, you can see
- The edit formula button
- The cancel button
- The enter button
- All of the above
- In a worksheet you can select
- The entire worksheet
- Rows
- Columns
- All of the above
- Which area in an excel window allows entering values and formulas
- Title bar
- Menu bar
- Formula bar
- Standard toolbar
- To edit in an embedded excel worksheet object in a word document
- Use the excel menu bar and toolbars inside the word application
- Edit the hyperlink
- Edit the data in a excel source application
- Use the word menu bar and toolbars
- To create a formula, you can use:
- Values but not cell references
- C ell references but not values
- Values or cell references although not both at the same time
- Value and cell references
- Status indicators are located on the
- Vertical scroll bar
- Horizontal scroll bar
- Formula bar
- Standard toolbar
- An excel workbook is a collection of
- Workbooks
- Worksheets
- Charts
- Worksheets and charts
- Excel files have a default extension of
- Xls
- Xlw
- Wk1
- 123
- Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
- IF
- AND
- OR
- NOT
- Macros are “run” or executed from the ….. menu.
- Insert
- Frmat
- Tools
- Data
- You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
- Insert
- Format
- Tools
- Data
- How are data organized in a spreadsheet?
- Lines and spaces
- Layers and planes
- Rows and columns
- Height and width
- Gridlines
- May be turned off for display but turned on for printing
- May be turned on or off for printing
- The be turned off for display and printing
- a, b and c
- A function inside another function is called a ….. function.
- Nested
- Round
- Sum
- Text
- Which function calculates your monthly mortage payment?
- PMT (payments)
- NPER (number of periods)
- PV (present value)
- All of above
- To drag a selected range of data to another worksheet in the same workbook, use the
- Tab key
- Alt key
- Shift key
- Ctrl key
- When the formula bar is activated, you can see
- The Edit Formula button
- The Cancel button
- The Enter button
- All of above
- Which file format can be added to a PowerPoint show?
- .jpg
- .giv
- .wav
- All of the above
- Material consisting of text and numbers is best presented as
- A table slide
- A bullet slide
- A title slide
- All of the above
- In order to edit a chart, you can
- Triple click the chart object
- Click and drag the chart object
- Double click the chart object
- Click the chart object
- to exit the PowerPoint
- click the application minimize button
- click the document close button
- double click the applications control menu icon
- double click the document control menu icon
- To select one hyperlink after another during a slide presentation, what do you press?
- Tab
- Ctrl + K
- Ctrl + h
- All of above
- special effects used to introduce slides in a presentation are called
- effects
- custom animations
- transitions
- present animations
- What is the term used when you press and hold the left mouse key and more the mouse around the slide?
- Highlighting
- Dragging
- Selecting
- Moving
- To give a PowerPoint presentation to a large audience, you:
- Set up your computer in a large auditorium, and click large, auditorium, OK
- Click the slide you wish the audience to see in normal view, then click the next slide, and so
- Choose either view, slide show or slide show, view show
- Slick slide show, OK
- Which of the following can you use to add times to the slides in a presentation?
- Slice Show menu
- Rehearse timing button
- Slide transition button
- All of the above
- Which of the following is not one of PowerPoint’s views?
- Slide show view
- Slide view
- Presentation view
- Outline view
- Which PowerPoint view works best for adding slide transitions?
- Slide show view
- Slide sorter view
- Slide view
- Notes view
- Which of the following views is the best view to use when setting transition effects for all slides in a presentation
- Slide sorter view
- Notes page view
- Slide view
- Outline view
- Which option can be used to set custom timings for slides in a presentation?
- Slider Timings
- Slider Timer
- Rehearsal
- Slide Show Setup
- Which of the following will not advance the slides in a slide show view?
- The esc key
- The space bar
- The enter key
- The mouse button
- The quickest way to create a PowerPoint presentation is to use the
- Word for windows templates
- Auto creation wizard
- Auto content wizard
- Presentation wizard
- Which opf the following can you format using buttons on the formatting toolbar?
- Your hard drive
- Format painting
- Font color
- Underlining
- To start Microsoft PowerPoint application
- Click on Start >> Programs >> All Programs >> Microsoft PowerPoint
- Hit Ctrl + R then type ppoint.exe and Enter
- Click Start >> Run then type PowerPoint then press Enter
- All of above
- Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
- Insert Menu
- Format Menu
- Tools Menu
- Slide Show Menu
- In which menu can you find features like Slide Design, Slide Layout etc.?
- Insert Menu
- Format Menu
- Tools Menu
- Slide Show Menu
- The selected design template can be applied
- To current slide only
- To all the slides
- To all the new presentation you create
- All of above
- What feature will you use to apply motion effects in between a slide exits and another enters?
- Slide Transition
- Slide Design
- Animation Objects
- Animation Scheme
- What PowerPoint feature will you use to apply motion effects to different objects of a slide?
- Slide Transition
- Slide Design
- Animation Objects
- Animation Scheme
- Which command will you use in PowerPoint if you need to change the color of different objects without changing content?
- Design Template
- Color Scheme
- Font Color
- Object Color
- Which short cut key inserts a new slide in current presentation?
- Ctrl+N
- Ctrl+M
- Ctrl+S
- All of above
- To start slide show of a presentation
- Hit F5 key
- From Slide Show menu choose View Show option
- From Slide Show menu choose Rehearse timing
- Both a & b
- If you select Insert >> Picture >> From File
- You can insert pictures and clipArts
- You can insert clipArts only
- You can insert pictures only
- None of above
- Which of the following font effect is not available in PowerPoint Font dialog box?
- Underline
- Shadow
- Emboss
- Strikethrough
- To insert a hyperlink in a slide
- Choose Insert >> Hyperlink
- Press Ctrl + K
- Hyperlinks can’t be inserted in slides
- Both a & b
- In a PowerPoint presentation
- Sound clips can be inserted but not movie clips
- Movie clips can be inserted but not sound clips
- Both cannot be inserted
- Both can be inserted
- To insert slide numbers
- Insert a text box and select Insert >> Page Number
- Insert a textbox and select Insert >> Number >> PageNumber
- Choose Insert >> Slide Number
- Insert a new text box and select Insert >> slide Number
- What are the three options available in Insert >> Picture menu?
- Clipart, Pictures, Shapes
- Clipart, From File, Shapes
- Clipart, From Files, AutoShapes
- Clipart, Pictures, AutoShapes
- From which menu you can access Picture, Test Box, Chart etc?
- File
- Edit
- Insert
- View
- Which of the following is not a part of Slide Design?
- Design Template
- Color Scheme
- Animation Scheme
- Slide Layout
- What is the term used when a clip art image changes the direction of faces?
- Group
- Flip
- Rotate
- All of the above
- The slide that is used to introduce a topic and set the tone for the presentation is called the
- table slide
- graph slide
- bullet slide
- title slide
- Which of the following features should you use when typing in the notes text box?
- Slide show
- Insert
- Slide maser
- Zoom
- Which command brings you to the first slide in your presentation?
- Next slide button
- Page up
- Ctrl + Home
- Ctrl + End
- You can show the shortcut menu during the slide show by
- Clicking the shortcut button on the formatting toolbar
- Right clicking the current slide
- Clicking an icon on the current slide
- a and b
- Auto clipart is a feature that
- Automatically places clipart in your presentation
- Scans your presentation for incorrect spelling in your words on each slide
- Scans your presentation for incorrect spelling in Word Arts objects
- All of above
- The view that displays the slides on a presentation as miniature representations of the slides is called
- slide show
- slide sorter view
- notes page view
- outline view
- Which of the following provides a printed copy of your presentation?
- Outline
- Speaker notes
- Audience handouts
- All of the above
- When using PowerPoint, to play a PowerPoint show for previewing the show, select
- View, slide sorter
- View, slide
- View, slide show
- View outline
- To select all the boxes of an organization chart
- Click edit, select all
- Right click the chart background click select all
- Press and hold the shift key and click each box
- All of the above
- Which of the following should e used when you want to add a slide to an existing presentation?
- File, add a new slide
- Insert, new slide
- File, open
- File, new
- Which key deletes text before, or the left of, the insertion point?
- Backspace
- Page up
- Delete
- Page down
- Microsoft PowerPoint is a
- Database program
- Spreadsheet program
- Presentation program
- Word processing program
- Which of the following programs is not a popular desktop publishing program?
- Adobe PageMaker
- Microsoft Publisher
- Lotus AmiPro
- QuarkXPress
- Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
- Insert Menu
- Format Menu
- Tools Menu
- Slide Show Menu
- In which menu can you find features like Slide Design, Slide Layout etc.?
- Insert Menu
- Format Menu
- Tools Menu
- Slide Show Menu
- Which of the following is not a font style?
- Bold
- Italics
- Regular
- Superscript
- Which of the following is not a type of page margin?
- Left
- Right
- Center
- Top
- What is a portion of a document in which you set certain page formatting options?
- Page
- Document
- Section
- Page Setup
- Background color or effects applied on a document is not visible in
- Web layout view
- Print Layout view
- Reading View
- Print Preview
- Which of the following is not true about Find and Replace in Excel
- You can search for bold and replace with italics
- You can decide whether to look for the whole word or not
- You can search in formula too
- You can search by rows or columns or sheets
- The best way to insert a new slide in a presentation is to use the
- Normal view
- Special view
- Slide show view
- Slide sorter view
- What is the maximum number of lines you can set for a drop cap?
- 3
- 10
- 15
- 20
- Which of the following line spacing is invalid?
- Single
- Double
- Triple
- Multiple
- Which of the following are word processing software?
- WordPerfect
- Easy Word
- MS Word
- All of above
- Which of the following is not of the merge process?
- Sort the data source records
- Format a main document
- Edit a data source
- Merge the two files to print or create a new document
- Which of the following is the latest version of MS Word?
- Word 2000
- Word 2007
- Word 2010
- Word 2011
- In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are
- .wav files and .mid files
- .wav files and .gif files
- .wav files and .jpg files
- .jpg files and .gif files
- special effects used to introduce slides in a presentation are called
- effects
- custom animations
- transitions
- present animations
- In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)
- animation
- slide transition
- custom animation
- preset animation
- To add a header or footer to your handout, you can use
- The title master
- The slide master
- The handout master
- All of above
- In Microsoft PowerPoint in order to see all the slides on one screen use
- view, slide sorter
- view, slide
- view, master
- view, slide show
- Which of the following is the default page setup orientation for slides in PowerPoint?
- Vertical
- Landscape
- Portrait
- None of above
- Pagemaker is a __________software.
- Desktop Publishing
- Word Processor
- Spredsheet
- Presentation
- ____________ is at the top of the window and it display the name of the application.
- Menu bar
- Title bar
- Tool bar
- Tool box