Microsoft Office MCQ Part-VI
91. To edit in an embedded excel worksheet object in a word document
a. Use the excel menu bar and toolbars inside the word application
b. Edit the hyperlink
c. Edit the data in a excel source application
d. Use the word menu bar and toolbars
Correct Answer: A
92. To create a formula, you can use:
a. Values but not cell references
b. Cell references but not values
c. Values or cell references although not both at the same time
d. Value and cell references
Correct Answer: D
93. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Standard toolbar
Correct Answer: C
94. An excel workbook is a collection of
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and charts
Correct Answer: D
95. Excel files have a default extension of
a. Xls
b. Xlw
c. Wk1
d. 123
Correct Answer: A
96. Except for the …… function, a formula with a logical function shows the word
“TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
Correct Answer: A
97. Macros are “run” or executed from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data
Correct Answer: C
98. You can open the consolidate dialog box by choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data
Correct Answer: D
99. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
Correct Answer: C
100. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c
Correct Answer: D
101. A function inside another function is called a ….. function.
a. Nested
b. Round
c. Sum
d. Text
Correct Answer: A
102. Which function calculates your monthly mortget payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. All of above
Correct Answer: A
103. 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
Correct Answer: B
104. 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
Correct Answer: D
105. Which file format can be added to a PowerPoint show?
a. .jpg
b. .giv
c. .wav
d. All of the above
Correct Answer: D
106. Material consisting of text and numbers is best presented as
a. A table slide
b. A bullet slide
c. A title slide
d. All of the above
Correct Answer: A
107. In order to edit a chart, you can
a. Triple click the chart object
b. Click and drag the chart object
c. Double click the chart object
d. Click the chart object
Correct Answer: C
108. To exit the PowerPoint
a. click the application minimize button
b. click the document close button
c. double click the applications control menu icon
d. double click the document control menu icon
Correct Answer: C
109. To select one hyperlink after another during a slide presentation, what do you press?
a. Tab
b. Ctrl + K
c. Ctrl + h
d. All of above
Correct Answer: A
110. Special effects used to introduce slides in a presentation are called
a. effects
b. custom animations
c. transitions
d. present animations
Correct Answer: C
111. What is the term used when you press and hold the left mouse key and more the mouse around the slide?
a. Highlighting
b. Dragging
c. Selecting
d. Moving
Correct Answer: B
112. To give a PowerPoint presentation to a large audience, you:
a. Set up your computer in a large auditorium, and click large, auditorium, OK
b. Click the slide you wish the audience to see in normal view, then click the next
slide, and so on.
c. Choose either view, slide show or slide show, view show
d. Slick slide show, OK
Correct Answer: C
113. Which of the following can you use to add times to the slides in a presentation
a. Slice Show menu
b. Rehearse timing button
c. Slide transition button
d. All of the above
Correct Answer: B
114. Which of the following is not one of PowerPoint’s views?
a. Slide show view
b. Slide view
c. Presentation view
d. Outline view
Correct Answer: C
115. Which PowerPoint view works best for adding slide transitions?
a. Slide show view
b. Slide sorter view
c. Slide view
d. Notes view
Correct Answer: B
116. Which of the following views is the best view to use when setting transition effects for all slides in a presentation.
a. Slide sorter view
b. Notes page view
c. Slide view
d. Outline view
Correct Answer: A
117. Which option can be used to set custom timings for slides in a presentation?
a. Slider Timings
b. Slider Timer
c. Rehearsal
d. Slide Show Setup
Correct Answer: C
118. Which of the following will not advance the slides in a slide show view?
a. The esc key
b. The space bar
c. The enter key
d. The mouse button
Correct Answer: A
119. The quickest way to create a PowerPoint presentation is to use the
a. Word for windows templates
b. Auto creation wizard
c. Auto content wizard
d. Presentation wizard
Correct Answer: C
120. Which of the following can you format using buttons on the formatting toolbar?
a. Your hard drive
b. Format painting
c. Font color
d. Underlining
Correct Answer: D