UniversityMCQS

Education, Tools and Services

HOME TUTORIALS/COURSES {Q&A} PPSC MCQ’S E-BOOKS GCUF PAST PAPERS BLOG OUR SERVICES    

MS Office MCQs
MS Office MCQs 170+ MCQs

1. From which menu you can insert Header and Footer?

Insert Menu
View Menu
Format menu
Tools Menu

2. To get to the ‘Symbol’ dialog box, click on the menu and choose ‘Symbol’.

Insert
Format
Tools
Table
3. option from clipboard is used to move data from one place to another in a

Copy & Paste

Cut & Paste
Bold
Justify

4. is an option in Font Group.

Strikethrough
Fin
Replace
Change Styles

5. Name the button in the picture?

Font Color
Fill Color
Page Color
Highlighter tool

6. Shortcut for document views toolbar is situated in

Task bar
Status bar
Tool bar
Title bar
 7. Bullets and Numbering is in

Home tab
Insert tab
Pagelayout tab
View tab

8. To open a existing document, click on the and then select Open.

MS Office button
Quick Access Toolbar
Document Views
Ribbon

9. Cut, Copy and Paste is in Group in the Home tab.

Font
Page Setup
Clipboard
Editing

10. is used to covert from upper case to lower case and vice versa.

Toggle case
Sentence case
Lower case
Upper case

11. Pressing F8 key for three times selects

 A word
A sentence
A paragraph
Entire document

12. What is the shortcut key you can press to create a copyright symbol?

Alt+Ctrl+C
Alt + C
Ctrl + C
Ctrl + Shift + C

13. 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

14. Which of the following is graphics solution for Word Processors?

Clipart
WordArt
Drop Cap
All of above

15. 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

16. A character that is raised and smaller above the baseline is known as

Outlined
 Raised
Superscript
Subscript

17. Thesaurus tool in MS Word is used for

Spelling suggestions
Grammar options
Synonyms and Antonyms words
All of above

18. 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

19. 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

20. Which of the following is not valid version of MS Office?

Office XP
Office Vista
Office 2007
None of above

21. 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
22. The key F12 opens a

Save As dialog box

Open dialog box
Save dialog box
Close dialog box

23. What is the short cut key to open the Open dialog box?

F12
Shift F12
Alt + F12
Ctrl + F12

24. 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

25. Which of the following is not available on the Ruler of MS Word screen?

Tab stop box

Left Indent
Right Indent
Center Indent

26. Which file starts MS Word?

exe
exe
exe
exe

27. If you want to keep track of different editions of a document which features will you use?

Editions
Versions
Track Change
 All of above

28. Background color or effects applied on a document is not visible in

Web layout view

Print Layout view
Reading View
Print Preview

29. What is a portion of a document in which you set certain page formatting options?

Page
Document
Section
Page Setup

30. Borders can be applied to

Cells
Paragraph
Text
All of above

31. Which of the following is not a type of page margin?

Left
Right
Center
Top

32. What is the default left margin in Word 2003 document?

1″
25″
5″
2″

33. Portrait and Landscape are

 Page Orientation
Paper Size
Page Layout
All of above

34. If you need to change the typeface of a document, which menu will you choose?

Edit
View
Format
Tools

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

Bold
Italics
Regular
Superscript

36. 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

37. Which option is not available in Insert Table Autofit behavior?

Fixed Column Width

AutoFit to Contents
Autofit to Window
Autofit to Column

38. 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

39. 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

40. Where can you change the vertical alignment?

Formatting toolbar
Paragraph dialog box
Page Setup dialog box
Standard toolbar

41. AutoCorrect was originally designed to replace words as you type.

Short, repetitive
Grammatically incorrect
Misspelled
None of the above

42. 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

43. In Word, the mailing list is known as the .

Data sheet
Source
Data source
Sheet

44. 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

45. 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

46. It is possible to a data source before performing a merge.

Create
Modify
Sort
all of the above

47. Comments can be added to cells using …..

Edit -> Comments

Insert -> Comment
File -> Comments
View –> Comments

48. Which of the following is not a valid Zoom percentage in Excel?

10
100
300
500

49. The spelling tool is placed on toolbar

Standard
Formatting
Drawing
Reviewing

50. Which of the following is not a valid data type in Excel?

Number
 Character
Label
Date/Time

51. Comments put in cells are called …..

Smart Tip
Cell Tip
Web Tip
Soft Tip

52. Which menu option can be used to split windows into two?

Format -> Window

View -> Window-> Split
Window -> Split
View –> Split

53. You can activate a cell by

Pressing the Tab key

Clicking the cell
Pressing an arrow key
All of above

54. 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

55. 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

56. Hyperlinks cannot be

 Special shapes like stars and banners
Drawing objects like rectangles ovals
Pictures
All can be hyperlinks

57. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

Standard
Formatting
Drawing
Picture

58. To drag a selected range of data to another worksheet in the same workbook, use the

Tab key
Alt key
Shift key
Ctrl key

59. 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

60. You can open the Sort dialog box by choosing Sort from the ….. menu

View
Format
Tools
Data

61. 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
62. Which of the following is not a valid Zoom percentage in Excel?

10
100
300
500

63. The spelling tool is placed on toolbar

Standard
Formatting
Drawing
Reviewing

64. Formatting a cell in Currency, you can specify

Decimal Places
Currency Symbol
Both of above
None of above

65. Formatting a cell in Number format you can’t set

Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol

66. 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
67. Which function will you use to enter current time in a woksheet cell?

=today()
=now()
=time()
=currentTime()

68. Merge cells option can be applied from

Format Cells dialog box Alignment Tab

Formatting toolbar
Both of above
None of above

69. 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

70. 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

71. 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

72. You can check the conditions against when applying conditional formatting

Cell value
Formula
Both of above
 None of above

73. When a range is selected, how can you activate the previous cell?

Press the Alt key

Press Tab
Press Enter
None of above

74. 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

75. Which of the following Excel screen components can NOT be turned on or off?

Formula Bar
Status Bar
Tool Bar
None of above

76. Which of the following option is not available in Paste Special dialog box?

Add
Subtract
Divide
SQRT

77. 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

78. Which of the following is an absolute cell reference?

!A!1
$A$1
 #a#1
A1

79. Which symbol must all formula begin with?

=
+
(
@

80. Which of the following formulas is not entered correctly?

=10+50
=B7*B1
=B7+14
10+50

81. 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

82. 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

83. 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

84. 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

85. To drag a selected range of data to another worksheet in the same workbook, use the

Tab key
Alt key
Shift key
Ctrl key

86. Hyperlinks can be

Text
Drawing objects
Pictures
All of above

87. To activate the previous cell in a pre-selected range, press

The Alt key

The Tab key
The Enter key
None of the above

88. Which button do yu click to add up a series of numbers?

 The autosum button
The Formula button
The quicktotal button
The total button

89. When the formula bar is active, you can see

The edit formula button

The cancel button
The enter button
All of the above

90. In a worksheet you can select

The entire worksheet

Rows
Columns
All of the above

91. Which area in an excel window allows entering values and formulas

Title bar
Menu bar
Formula bar
Standard toolbar

92. 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

93. 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

94. Status indicators are located on the

Vertical scroll bar

Horizontal scroll bar
Formula bar
Standard toolbar

95. An excel workbook is a collection of

Workbooks
Worksheets
Charts
Worksheets and charts

96. Excel files have a default extension of

Xls
Xlw
Wk1
123

97. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

IF
AND
OR
NOT

98. Macros are “run” or executed from the ….. menu.

 Insert
Frmat
Tools
Data

99. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

Insert
Format
Tools
Data

100. How are data organized in a spreadsheet?

Lines and spaces

Layers and planes
Rows and columns
Height and width

101. 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

102. A function inside another function is called a ….. function.

Nested
Round
Sum
Text
103. Which function calculates your monthly mortage payment?

PMT (payments)
NPER (number of periods)
PV (present value)
All of above

104. To drag a selected range of data to another worksheet in the same workbook, use the

Tab key
Alt key
Shift key
Ctrl key

105. When the formula bar is activated, you can see

The Edit Formula button

The Cancel button
The Enter button
All of above

106. Which file format can be added to a PowerPoint show?

.jpg
.giv
.wav
All of the above

107. Material consisting of text and numbers is best presented as

A table slide
A bullet slide
A title slide
 All of the above

108. 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

109. 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

110. To select one hyperlink after another during a slide presentation, what do you press?

Tab
Ctrl + K
Ctrl + h
All of above

111. special effects used to introduce slides in a presentation are called

effects
custom animations
transitions
present animations

112. 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

113. 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

114. 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

115. Which of the following is not one of PowerPoint’s views?

Slide show view

Slide view
Presentation view
Outline view

116. Which PowerPoint view works best for adding slide transitions?

Slide show view

Slide sorter view
Slide view
Notes view

117. 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

118. Which option can be used to set custom timings for slides in a presentation?

Slider Timings
Slider Timer
Rehearsal
Slide Show Setup

119. 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

120. The quickest way to create a PowerPoint presentation is to use the

Word for windows templates

Auto creation wizard
Auto content wizard
Presentation wizard

121. Which opf the following can you format using buttons on the formatting toolbar?

Your hard drive

Format painting
Font color
Underlining

122. 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

123. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

Insert Menu
Format Menu
Tools Menu
Slide Show Menu

124. In which menu can you find features like Slide Design, Slide Layout etc.?

Insert Menu
Format Menu
 Tools Menu
Slide Show Menu

125. 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

126. 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

127. What PowerPoint feature will you use to apply motion effects to different objects of a slide?

Slide Transition
Slide Design
Animation Objects
Animation Scheme

128. 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

129. Which short cut key inserts a new slide in current presentation?

Ctrl+N
Ctrl+M
Ctrl+S
All of above
130. 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

131. 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

132. Which of the following font effect is not available in PowerPoint Font dialog box?

Underline
Shadow
Emboss
Strikethrough

133. To insert a hyperlink in a slide

Choose Insert >> Hyperlink

Press Ctrl + K
Hyperlinks can’t be inserted in slides
Both a & b

134. 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

135. 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

136. What are the three options available in Insert >> Picture menu?

Clipart, Pictures, Shapes

Clipart, From File, Shapes
Clipart, From Files, AutoShapes
Clipart, Pictures, AutoShapes

137. From which menu you can access Picture, Test Box, Chart etc?

File
Edit
Insert
View

138. Which of the following is not a part of Slide Design?

Design Template
Color Scheme
Animation Scheme
Slide Layout

139. What is the term used when a clip art image changes the direction of faces?

Group
Flip
Rotate
All of the above
140. 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

141. Which of the following features should you use when typing in the notes text box?

Slide show
Insert
Slide maser
Zoom

142. Which command brings you to the first slide in your presentation?

Next slide button

Page up
Ctrl + Home
Ctrl + End

143. 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

144. 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

145. 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

146. Which of the following provides a printed copy of your presentation?

Outline
Speaker notes
Audience handouts
All of the above

147. When using PowerPoint, to play a PowerPoint show for previewing the show, select

View, slide sorter

View, slide
View, slide show
View outline

148. 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

149. 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

150. Which key deletes text before, or the left of, the insertion point?

Backspace
Page up
Delete
Page down

151. Microsoft PowerPoint is a

Database program
Spreadsheet program
Presentation program
Word processing program

152. Which of the following programs is not a popular desktop publishing program?

Adobe PageMaker
Microsoft Publisher
Lotus AmiPro
QuarkXPress

153. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

Insert Menu
Format Menu
Tools Menu
Slide Show Menu

154. In which menu can you find features like Slide Design, Slide Layout etc.?

Insert Menu
 Format Menu
Tools Menu
Slide Show Menu

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

Bold
Italics
Regular
Superscript

156. Which of the following is not a type of page margin?

Left
Right
Center
Top

157. What is a portion of a document in which you set certain page formatting options?

Page
Document
Section
Page Setup

158. Background color or effects applied on a document is not visible in

Web layout view

Print Layout view
Reading View
Print Preview

159. 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

160. 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

161. What is the maximum number of lines you can set for a drop cap?

3
10
15
20

162. Which of the following line spacing is invalid?

Single
Double
Triple
Multiple

163. Which of the following are word processing software?

WordPerfect
Easy Word
MS Word
All of above

164. 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

165. Which of the following is the latest version of MS Word?

 Word 2000
Word 2007
Word 2010
Word 2011

166. 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

167. special effects used to introduce slides in a presentation are called

effects
custom animations
transitions
present animations

168. 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

169. To add a header or footer to your handout, you can use

The title master

The slide master
The handout master
All of above

170. In Microsoft PowerPoint in order to see all the slides on one screen use

view, slide sorter

view, slide
view, master
view, slide show
171. Which of the following is the default page setup orientation for slides in PowerPoint?

Vertical
Landscape
Portrait
None of above

172. Pagemaker is a __________software.

Desktop Publishing
Word Processor
Spredsheet
Presentation

173. ____________ is at the top of the window and it display the name of the application.

Menu bar
Title bar
Tool bar
Tool box
 FOLLOW US
Our Services

About Us  

Privacy Policy

Terms & Conditions

Copyright © 2021 - - - - - - Designed By: Softnic WebSolutions