Elance Microsoft Office Skill Test Questions
Question: 01
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.
Question: 02
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
Question: 03
You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Front of Text
d. In Line with Text
Question: 04
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.
Question: 05
Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
a. An offline cube file stores data in the form of an OLAP cube.
b. The file format for an offline cube file is .ocf.
c. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
Question: 06
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
Question: 07
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
Question: 08
Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
a. Report Filter
b. Row Labels
c. Values
Question: 09
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
a. References” > “Style”.
b. References” >”Insert Citation” >”Add New Source.
c. References” >”Insert Citation” >”Add New Placeholder.
d. None of the above
Question: 10
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
Question: 11
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.
Question: 12
The default chart colors are determined by what?
a. Slide Design Effects
b. Slide Background Graphics
c. Slide Fill Shading
d. Slide Color Scheme
Question: 13
Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?
a. Excel displays data corresponding to the pivot report value on the same sheet.
b. Excel creates a new sheet with data corresponding to the pivot report value.
c. Excel creates a new workbook with data corresponding to the pivot report value.
Question: 14
Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?
a. In the Insert tab
b. In the Design tab
c. In the View tab
d. In the Review tab
Question: 15
If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?
a. Even Page
b. Odd Page
c. Continuous
Question: 16
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
Question: 17
Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?
a. One by one
b. As one object
c. Dim after animation
d. By 1st Level Paragraphs
Question: 18
In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in Microsoft Excel 2010?
a. lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.
b. The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.
c. If the array used by the LOOKUP function in Microsoft Excel 2010 contains more columns than rows, then LOOKUP searches for the value of lookup_value in the first column.
d. If the array used by the LOOKUP function in Microsoft Excel 2010 contains more rows than columns, then LOOKUP searches for the value of lookup_value in the first column.
Question: 19
Which of the following methods will you use to insert a hyperlink in a message in Microsoft Outlook 2010, if the format of the mail is set to Rich Text?
a. Type the hyperlink in the body of the message.
b. Drag a hyperlink into the body of the message.
c. Click on the Insert tab-> Go to the Links group-> Add Hyperlink.
d. Any of the above methods can be used.
Question: 20
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
Question: 21
Which of the following delegate permission levels allows you to change and delete the items that the manager created?
a. Author
b. Editor
c. Reviewer
Question: 22
Which of the following defines the correct purpose of using a poster frame image?
a. To add still image introduction to the video
b. To add visual effect to the narration
c. To insert a picture on any part of the screen
d. To create or edit a presentation based on a set of pictures
Question: 23
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
Question: 24
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
Question: 25
What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
a. It helps you mitigate integrity threats.
b. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
c. It enables you to specify cryptographic settings for encrypting documents.
d. It is a security tool that enables users to designate safe documents.
Question: 26
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
Question: 27
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.
Question: 28
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
Question: 29
Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?
a. /noextensions
b. /nocustomize
c. /nopreview
d. /profiles
Question: 30
Which of the following is not a category of transition?
a. Subtle
b. Exciting
c. Dynamic Content
d. Emphasis
Question: 31
What is one way to ensure that the sound icon doesn’t show in the presentation?
a. By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon
b. By applying a transparent picture fill effect to the sound icon on the slide
c. By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show
d. All of the above
Question: 32
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
Question: 33
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.
Question: 34
Which of the following is NOT an option when inserting a Cross-reference?
a. Numbered item
b. SmartArt
c. Heading
d. Equation
e. Table
Question: 35
Which of the following is true regarding Microsoft Excel 2010 Web App?
a. It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.
b. It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.
c. Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.
d. A shared workbook can be loaded in the browser.
Question: 36
Which of the following tag is not available in Microsoft Outlook 2010?
a. Unread/read
b. Follow Up
c. Categorize
d. Show in Favorites
Question: 37
If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cell?
a. True
b. False
Question: 38
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
Question: 39
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
Question: 40
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.
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.
Question: 02
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
Question: 03
You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Front of Text
d. In Line with Text
Question: 04
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.
Question: 05
Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
a. An offline cube file stores data in the form of an OLAP cube.
b. The file format for an offline cube file is .ocf.
c. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
Question: 06
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
Question: 07
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
Question: 08
Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
a. Report Filter
b. Row Labels
c. Values
Question: 09
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
a. References” > “Style”.
b. References” >”Insert Citation” >”Add New Source.
c. References” >”Insert Citation” >”Add New Placeholder.
d. None of the above
Question: 10
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
Question: 11
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.
Question: 12
The default chart colors are determined by what?
a. Slide Design Effects
b. Slide Background Graphics
c. Slide Fill Shading
d. Slide Color Scheme
Question: 13
Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?
a. Excel displays data corresponding to the pivot report value on the same sheet.
b. Excel creates a new sheet with data corresponding to the pivot report value.
c. Excel creates a new workbook with data corresponding to the pivot report value.
Question: 14
Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?
a. In the Insert tab
b. In the Design tab
c. In the View tab
d. In the Review tab
Question: 15
If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?
a. Even Page
b. Odd Page
c. Continuous
Question: 16
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
Question: 17
Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?
a. One by one
b. As one object
c. Dim after animation
d. By 1st Level Paragraphs
Question: 18
In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in Microsoft Excel 2010?
a. lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.
b. The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.
c. If the array used by the LOOKUP function in Microsoft Excel 2010 contains more columns than rows, then LOOKUP searches for the value of lookup_value in the first column.
d. If the array used by the LOOKUP function in Microsoft Excel 2010 contains more rows than columns, then LOOKUP searches for the value of lookup_value in the first column.
Question: 19
Which of the following methods will you use to insert a hyperlink in a message in Microsoft Outlook 2010, if the format of the mail is set to Rich Text?
a. Type the hyperlink in the body of the message.
b. Drag a hyperlink into the body of the message.
c. Click on the Insert tab-> Go to the Links group-> Add Hyperlink.
d. Any of the above methods can be used.
Question: 20
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
Question: 21
Which of the following delegate permission levels allows you to change and delete the items that the manager created?
a. Author
b. Editor
c. Reviewer
Question: 22
Which of the following defines the correct purpose of using a poster frame image?
a. To add still image introduction to the video
b. To add visual effect to the narration
c. To insert a picture on any part of the screen
d. To create or edit a presentation based on a set of pictures
Question: 23
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
Question: 24
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
Question: 25
What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
a. It helps you mitigate integrity threats.
b. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
c. It enables you to specify cryptographic settings for encrypting documents.
d. It is a security tool that enables users to designate safe documents.
Question: 26
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
Question: 27
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.
Question: 28
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
Question: 29
Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?
a. /noextensions
b. /nocustomize
c. /nopreview
d. /profiles
Question: 30
Which of the following is not a category of transition?
a. Subtle
b. Exciting
c. Dynamic Content
d. Emphasis
Question: 31
What is one way to ensure that the sound icon doesn’t show in the presentation?
a. By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon
b. By applying a transparent picture fill effect to the sound icon on the slide
c. By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show
d. All of the above
Question: 32
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
Question: 33
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.
Question: 34
Which of the following is NOT an option when inserting a Cross-reference?
a. Numbered item
b. SmartArt
c. Heading
d. Equation
e. Table
Question: 35
Which of the following is true regarding Microsoft Excel 2010 Web App?
a. It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.
b. It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.
c. Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.
d. A shared workbook can be loaded in the browser.
Question: 36
Which of the following tag is not available in Microsoft Outlook 2010?
a. Unread/read
b. Follow Up
c. Categorize
d. Show in Favorites
Question: 37
If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cell?
a. True
b. False
Question: 38
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
Question: 39
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
Question: 40
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.
Don't Miss A Single Updates
✓Remember to check your email account to confirm your subscription.
