Knowledge of Microsoft Office Skills Test
Josh
is to create a technical write-up comprising short paragraphs with double line
spacing. Each paragraph is to be separated from the other by a single line
space. He writes a paragraph, selects the text, points to Line Spacing on the
paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The
moment he clicks enter to start a new paragraph, it automatically gets double
spaced. How can Josh achieve paragraphs separated by single line spaces from
each other within the document?
a. He
sets the Line Spacing on the formatting toolbar to 1.0.
b. He
selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents
and Spacing, he sets the Spacing "Before" and "After"
options to zero.
c. He
uses the Shift and Enter keys at the same time to create a new paragraph.
d. He
selects the double-spaced paragraphs and clicks on Paragraph. Then under
Indents and Spacing, he sets the Spacing "Before" and
"After" options to Auto.
By
default, when you paste a chart from Excel into PowerPoint 2007, is it linked
or embedded?
a. It
is linked
b. It
is embedded
This
question is based upon the figure shown below
Which
of the following tools is used to format Excel worksheet data, as shown in the
figure above?
a. Slicer
b. SmartArt
c. WordArt
d. Macros
Which
of the following record types of Business Contact Manager for Microsoft Outlook
2010 allows you to plan and track communication activities to accomplish a
business result, such as increasing market share, introducing a new product, or
retaining customers?
a. Opportunity
b. Marketing
Activity
c. Business
Project
d. Business
Contact
With
which chart type(s) is the "Depth Gridlines" option available?
a. Bubble
chart
b. Line
chart
c. True
3D chart
d. All
of the above
The
default chart colors are determined by what?
a. Slide
Design Effects
b. Slide
Background Graphics
c. Slide
Fill Shading
d. Slide
Color Scheme
Which
of the following is not a category of transition?
a. Subtle
b. Exciting
c. Dynamic
Content
d. Emphasis
Suppose
there are some files in a folder named 'demo', which were archived to a file
named demo.pst. Now you want to restore this archive to a folder named 'demo1'.
Which option in the File tab will you use for this purpose, in Microsoft
Outlook 2010?
a. Info
b. Open
c. Options
d. None
of these
You
are editing a shape using the Drawing Tools. Which among the following Shape
Fill options in the Shape Styles group gives you control over the transparency
for a shape?
a. Fill
color, More Fill Colors
b. Background
Color
c. Texture
d. Pattern
In
Microsoft Word 2010, "Keep lines together" paragraph formatting:
a. works
well for paragraphs within a table if "Allow row to break across
pages" is also selected.
b. automatically
enables the text rows to break across pages.
c. does
not work for paragraphs within a table if "Allow row to break across
pages" is also selected.
d. always
works for paragraphs within a table.
Slicers
are filtering components which are used to filter the data in a PivotTable
report or CUBE functions. Which of the following data sources is/are supported
by Slicers in Microsoft Excel 2010?
a. Office
Database connections
b. Online
Analytical Processing (OLAP) Queries
c. Online
Analytical Processing (OLAP) Cube Files
What
will happen if the Junk E-mail filter of Microsoft Outlook 2010 does NOT
consider a message to be spam but considers it to be phishing?
a. It
will shift the message to the Spam folder.
b. It
will disable all the links in the e-mail.
c. It
will disable the Reply and Reply All commands.
d. It
will delete the e-mail.
How
would you write on the slides during a slide show?
a. In
the Slide Sorter view, right-click on the slide that you want to write on,
point to Pen Options, and then click on a pen. Drag it to write.
b. On
the Slide Show tab, in the Set Up group, select a pen and then drag it to
write.
c. In
the Slide Show view, right-click on the slide that you want to write on, point
to Pointer Options, and then click on a pen or a highlighter option. Hold down
the left mouse button and drag to write.
d. All
of the above
Which
picture format maintains transparency in MS 2010 Powerpoint?
a. .png
b. .gif
c. .jpg
d. .wmf
Which
of the following actions CANNOT be performed by the user on the Business Contact
Manager database?
a. Update
records
b. Create
new records
c. Delete
records permanently
d. Move
records to the Deleted Items folder
Dave
receives a file named Theme1.thmx from his boss. Opening the file opens a blank
PowerPoint document. On clarifying from his boss, he learns that the .thmx file
contains a particular theme which needs to be applied to the annual report on
which Dave is working. How can Dave achieve this?
a. By
pasting all the text of the report in thePowerPoint file which opens on double
clicking the .thmx file and then saving it as a Word document.
b. By
opening the .thmx file with Microsoft Word 2010 and pasting the complete report
text into it.
c. Dave's Boss is wrong. No such arrangement
is possible in Microsoft Word 2010.
d. By
opening the Word file containing the report, and importing the theme from the
.thmx file by using the "Browse for themes" option on the Page Layout
tab.
Which
of the following types of worksheets will not load in Microsoft Excel Services?
a. Worksheets
with ActiveX controls
b. Worksheets
with tables
c. Worksheets
with hyperlinks
d. Worksheets
with Organization Charts and Diagrams
e. All
of the above
What
are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
a. Digital
signatures help authenticate the source of the messages.
b. Both
the sender and the receiver of a message can verify that the message has not
been altered during transmission, if the message is digitally signed.
c. Digitally
signed e-mails meet legal requirements for admissibility and authenticity.
d. All
of the above.
If I
do not want the contents of one of my fields to automatically update, I would
have to do which of the following?
a. Lock
the field.
b. Protect
the field.
c. Make
the field hidden.
d. Turn
field shading off.
When
using the booklet-printing feature, the term "gutter" refers to the
space between page content and the fold in the middle of the paper where you
would normally bind pages together.
a. True
b. False
You
have just created a new document based on the normal template and have created
a custom style. You now want to make that custom style easily available in all
future documents. In order to do this, you need to select:
a. "Add
to Quick Style List" in the Styles pane.
b. "New
documents based on this template" under modify style option.
c. Copy
the style to each document manually each time you want to use it.
In
MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?
a. Under
Picture Tools, on the Format tab, in the Size group, click Dialog Box Launcher,
then Crop. Enter the size numbers in the Width, Height, Left and Top boxes.
b. Select
the picture and right click on it. Select Size and Position from the list and
then enter the size numbers in the Width, Height, Left and Top boxes.
c. Both
a and b
d. None
of the above
How
will you read comments that reviewers have added to your presentation?
a. On
the View tab, in the Show/Hide group, click on Show Comments.
b. On
the Review tab, in the Comments group, click on Show Markup.
c. Both
a and b
d. None
of the above
Which
standard form is used to record actions which relate to specific contacts and
put the action in a Timeline view?
a. Post
b. Journal
Entry
c. Appointment
d. Task
Request
How
many items can be maintained on the clipboard at one time?
a. One
b. Up
to 24
c. Unlimited
d. Up
to 100
Which
of the following is INCORRECT regarding setting of passwords in Microsoft
Outlook 2010?
a. There
is no logon password for the Outlook program itself. The password you set protects
only your Outlook data file (.pst) that is used in Outlook.
b. If
you are running Outlook with a Microsoft Exchange account, your data for that
account, including password access, is automatically managed by Microsoft
Exchange.
c. You
can set a password for individual folders within the .pst.
d. None
of the above
What
does the Compare tool do?
a. Compares
changes in two presentations
b. Compares
one image to another to indicate differences
c. Compares
file size
d. Compares
presentations for backward compatibility
What
is one thing the Compress Pictures feature does?
a. Changes
all pictures from color to black and white
b. Decreases
the contrast of all pictures in the presentation
c. Permanently
deletes cropped areas of pictures
d. Condenses
the pictures to one area of the slide
How
would you assign a macro to a graphic?
a. On
the Developer tab, in the Code group, click on Macros.
b. On
the View tab, click on Macros and then click on Assign Macro on the shortcut
menu. In the Macro name box, click on the macro that you want to assign.
c. On a
worksheet, right-click on the graphic, then click on Assign Macro on the
shortcut menu. In the Macro name box, click on the macro that you want to
assign.
d. You
can use any of the above three techniques.
e. You
cannot assign a macro to a graphic.
How
would you add a logo to all the slides in a presentation?
a. In
the Normal editing View, paste the logo onto every slide in the presentation.
b. In
the Slide Master View, add the logo to the slide master and the title slide
layout.
c. In
the Slide Master View, add the logo to the blank slide layout.
d. None
of the above
Which
among the following settings is the default macro security setting?
a. Disable
all macros without notification.
b. Disable
all macros except digitally signed macros.
c. Disable
all macros with notification.
d. Enable
all macros.
Which
of the following tag is not available in Microsoft Outlook 2010?
a. Unread/read
b. Follow
Up
c. Categorize
d. Show
in Favorites
How
do you insert a new slide master into a presentation?
a. In
Master View, click the Insert Layout button
b. In
Master View, click the Insert Slide Master button
c. In
Slide Sorter View, click the Insert Slide Design button
d. In
Normal editing View, click the Insert Slide Design button
This
question is based upon the figure shown below
In
the given screenshot, there are red triangles in the upper-right corner of each
cell under the column titled 'Registrations'. What do these signify?
a. The
red triangles represent the comment associated.
b. The
red triangles signify an associated data validation control.
c. The
red triangles represent the tracking of the cell.
d. The
red triangles signify that the cell is a hidden cell.
Which
of the following statements regarding images in Microsoft Excel 2010 are true?
a. Microsoft
Excel 2010 validates images which are in the form of external and active
content.
b. Microsoft
Excel 2010 provides for changing the sharpness and contrast of images but not
changing their transparency.
c. Microsoft
Excel 2010 supports 3D rotation of images.
How
do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?
a. By
using the last backup .pst file.
b. By
scanning the .pst file with scanpst
c. By
re-logging into the mail account.
d. The
file cannot be repaired.
Format
Painter will not normally work with pictures in which the text wrapping is set
to:
a. Square
b. Behind
Text
c. In
Front of Text
d. In
Line with Text
This
question is based upon the figure shown below
In
the given screenshot, the letter X is pointing to an area between the first Row
header, and the first Column header. What will happen when this particular area
is selected?
a. It
will select the whole sheet, having the same effect as that of Ctrl+A.
b. It
will close and save this particular worksheet of the workbook.
c. Nothing
will happen.
d. It
will hide this particular worksheet.
Which
of the following actions from the Delete group not only moves all the existing
messages but also the future messages in the selected Conversations to the
Deleted Items folder?
a. Ignore
b. Clean
Up
c. Delete
How
can you remove duplicate emails present in a particular folder?
a. By
using the Clean Up Folder option.
b. By
repeatedly using the Send/Receive mails option.
c. By
applying filtration of the email according to groups, in a particular folder.
d. By
sorting the emails received in a particular folder.