UpWork Test answers for Microsoft Office Skills Test

Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Answers:
• Automatic
• Cell midpoint
• Cell left

2. Which of the following is true regarding Microsoft Excel 2010 Web App?
Answers:
• It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.
• It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.
• Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.
• A shared workbook can be loaded in the browser.

3. Which of the following statements regarding images in Microsoft Excel 2010 are true?
Answers:
• Microsoft Excel 2010 validates images which are in the form of external and active content.
• Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.
• Microsoft Excel 2010 supports 3D rotation of images.

4. Which of the following types of worksheets will not load in Microsoft Excel Services?
Answers:
• Worksheets with ActiveX controls
• Worksheets with tables
• Worksheets with hyperlinks
• Worksheets with Organization Charts and Diagrams
• All of the above

5. By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?
Answers:
• It is linked
• It is embedded

6. Which of the following is not a category of transition?
Answers:
• Subtle
• Exciting
• Dynamic Content
• Emphasis

7. 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?
Answers:
• 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.
• By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.
• Dave’s Boss is wrong. No such arrangement is possible in Microsoft Word 2010.
• 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.

8. 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.
Answers:
• True
• False

9. Which of the following is NOT an option when inserting a Cross-reference?
Answers:
• Numbered item
• SmartArt
• Heading
• Equation
• Table

10. In MS Excel when your cursor is in the last cell of a table, what does Tab key do?
Answers:
• Adds a row at the bottom of the table
• Adds a row at the top of the table
• Adds a column to the right of the current cell
• Places your cursor on the next object on the slide

11. Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor on your Safe Recipients List?
Answers:
• No Automatic Filtering
• Low
• High
• Safe Lists Only

12. In the Customize Ribbon dialog, choosing Reset All Customizations does what?
Answers:
• It restores the Ribbon to the default settings.
• It restores the Quick Access Toolbar to the default settings.
• It restores both the Ribbon and the Quick Access Toolbar to the default settings.

13. 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?
Answers:
• It will select the whole sheet, having the same effect as that of Ctrl+A.
• It will close and save this particular worksheet of the workbook.
• Nothing will happen.
• It will hide this particular worksheet.

14. Why would you use content controls in a document?
Answers:
• To get information from another source and have it appear at a specific place in a document.For example, the customer data automatically appears when you create a new invoice.
• To create a document and restrict what people can do with it. For example, you create a document that contains legal language, and you want to ensure people don’t accidentally change or delete any of its text.
• To create structured regions of a document that people fill out. For example, the cover page of the proposal can’t be changed except by filling out the title and author.
• All of the above
• None of the above

15. Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?
Answers:
• Update records
• Create new records
• Delete records permanently
• Move records to the Deleted Items folder

16. 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 cells .
Answers:
• True
• False

17. 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?
Answers:
• Fill color, More Fill Colors
• Background Color
• Texture
• Pattern

18. 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:
Answers:
• “Add to Quick Style List” in the Styles pane.
• “New documents based on this template” under modify style option.
• Copy the style to each document manually each time you want to use it.

19. Which of the following delegate permission levels allows you to change and delete the items that the manager created?
Answers:
• Author
• Editor
• Reviewer

20. What is one way to ensure that the sound icon doesn’t show in the presentation?
Answers:
• By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon
• By applying a transparent picture fill effect to the sound icon on the slide
• By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show
• All of the above

21. Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?
Answers:
• 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.
• If you are running Outlook with a Microsoft Exchange account, your data for that account, including password access, is automatically managed by Microsoft Exchange.
• You can set a password for individual folders within the .pst.
• None of the above

22. 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?
Answers:
• Office Database connections
• Online Analytical Processing (OLAP) Queries
• Online Analytical Processing (OLAP) Cube Files

23. With which chart type(s) is the “Depth Gridlines” option available?
Answers:
• Bubble chart
• Line chart
• True 3D chart
• All of the above

24. Which of the following tag is not available in Microsoft Outlook 2010?
Answers:
• Unread/read
• Follow Up
• Categorize
• Show in Favorites

25. Below are two statements regarding Breaks in Microsoft Word 2010.

Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text.
Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page.

Which of the following options is correct?
Answers:
• Statement X is correct. Statement Y is incorrect.
• Statement X is incorrect. Statement Y is correct.
• Both Statements X and Y are correct.
• Both Statements X and Y are incorrect.

26. How can you remove duplicate emails present in a particular folder?
Answers:
• By using the Clean Up Folder option.
• By repeatedly using the Send/Receive mails option.
• By applying filtration of the email according to groups, in a particular folder.
• By sorting the emails received in a particular folder.

27. How do you turn off the controls that show in the lower left corner of the screen during a slide show?
Answers:
• Right-click the controls in the slide show and choose Don’t Show
• Choose the menu Tools -> Options and uncheck Show Popup Toolbar on the View tab
• Choose the menu File -> Options -> Advanced and select Show Popup Toolbar
• Press F1 during the slide show

28. You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?
Answers:
• Scenarios
• Data tables
• Goal Seek

29. 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?
Answers:
• lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.
• The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.
• 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.
• 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.

30. The image given above is that of the Recording toolbar, which appears when you Rehearse Timings. What does the part of the toolbar marked ‘A’ in the image refer to?
Answers:
• It displays the slide time.
• It displays the total presentation time.
• It displays the time taken by the first slide.
• None of the above

31. 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?
Answers:
• The red triangles represent the comment associated.
• The red triangles signify an associated data validation control.
• The red triangles represent the tracking of the cell.
• The red triangles signify that the cell is a hidden cell.

32. Which of the following are included in a digitally signed e-mail message?
Answers:
• Certificate
• CAPTCHA image
• Public key
• Sender’s full name

33. 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?
Answers:
• Ignore
• Clean Up
• Delete

34. 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?
Answers:
• Type the hyperlink in the body of the message.
• Drag a hyperlink into the body of the message.
• Click on the Insert tab-> Go to the Links group-> Add Hyperlink.
• Any of the above methods can be used.

35. 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?
Answers:
• Even Page
• Odd Page
• Continuous

36. Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?
Answers:
• Post
• Journal Entry
• Appointment
• Task Request

37. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Answers:
• Report Filter
• Row Labels
• Values

38. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answers:
• Lock the field.
• Protect the field.
• Make the field hidden.
• Turn field shading off.

39. Consider the following scenario:

A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:
Answers:
• be spread across both cells.
• be deleted.
• remain intact in the first cell and the second cell will be empty.

40. How will you read comments that reviewers have added to your presentation?
Answers:
• On the View tab, in the Show/Hide group, click on Show Comments.
• On the Review tab, in the Comments group, click on Show Markup.
• Both a and b
• None of the above

41. Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?
Answers:
• One by one
• As one object
• Dim after animation
• By 1st Level Paragraphs

42. What is one thing the Compress Pictures feature does?
Answers:
• Changes all pictures from color to black and white
• Decreases the contrast of all pictures in the presentation
• Permanently deletes cropped areas of pictures
• Condenses the pictures to one area of the slide

43. Refer to the image above and identify which Home tab group these commands belong to?
Answers:
• Move
• Quick Steps
• Respond
• Tags

44. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Answers:
• It helps you mitigate integrity threats.
• It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
• It enables you to specify cryptographic settings for encrypting documents.
• It is a security tool that enables users to designate safe documents.

45. Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?
Answers:
• In the Insert tab
• In the Design tab
• In the View tab
• In the Review tab

46. Which of the following types of tabs is displayed in the tab row when an object, such as an image, is selected or highlighted in the application workspace, in Microsoft Outlook 2010?
Answers:
• Standard ribbon tabs
• Modal tabs
• Contextual tabs

47. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Answers:
• An offline cube file stores data in the form of an OLAP cube.
• The file format for an offline cube file is .ocf.
• An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

48. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
Answers:
• References” > “Style”.
• References” >”Insert Citation” >”Add New Source.
• References” >”Insert Citation” >”Add New Placeholder.
• None of the above

49. You customized the navigation pane with a lot of folders and shortcuts but now you want to remove all of them. What command line switch would you use with outlook.exe to remove the folders you added?
Answers:
• /profiles
• /resetfolders
• /resetnavpane
• /recycle

50. How would you write on the slides during a slide show?
Answers:
• 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.
• On the Slide Show tab, in the Set Up group, select a pen and then drag it to write.
• 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.
• All of the above

51. 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?
Answers:
• Opportunity
• Marketing Activity
• Business Project
• Business Contact

52. The default chart colors are determined by what?
Answers:
• Slide Design Effects
• Slide Background Graphics
• Slide Fill Shading
• Slide Color Scheme

53. How would you assign a macro to a graphic?
Answers:
• On the Developer tab, in the Code group, click on Macros.
• 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.
• 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.
• You can use any of the above three techniques.
• You cannot assign a macro to a graphic.

54. 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?
Answers:
• It will shift the message to the Spam folder.
• It will disable all the links in the e-mail.
• It will disable the Reply and Reply All commands.
• It will delete the e-mail.

55. In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?
Answers:
• 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.
• 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.
• Both a and b
• None of the above

56. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Answers:
• Digital signatures help authenticate the source of the messages.
• 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.
• Digitally signed e-mails meet legal requirements for admissibility and authenticity.
• All of the above.

57. Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?
Answers:
• Excel displays data corresponding to the pivot report value on the same sheet.
• Excel creates a new sheet with data corresponding to the pivot report value.
• Excel creates a new workbook with data corresponding to the pivot report value.

58. Suppose you have created a report in Excel named ‘report.xlsx’. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
Answers:
• Share ‘report.xlsx’ by saving it to SkyDrive.
• Share ‘report.xlsx’ by saving it to a SharePoint site.
• Share ‘report.xlsx’ by sending it through email.

59. How would you add a logo to all the slides in a presentation?
Answers:
• In the Normal editing View, paste the logo onto every slide in the presentation.
• In the Slide Master View, add the logo to the slide master and the title slide layout.
• In the Slide Master View, add the logo to the blank slide layout.
• None of the above

60. In Microsoft Word 2010, “Keep lines together” paragraph formatting:
Answers:
• works well for paragraphs within a table if “Allow row to break across pages” is also selected.
• automatically enables the text rows to break across pages.
• does not work for paragraphs within a table if “Allow row to break across pages” is also selected.
• always works for paragraphs within a table.

61. Which of the following defines the correct purpose of using a poster frame image?
Answers:
• To add still image introduction to the video
• To add visual effect to the narration
• To insert a picture on any part of the screen
• To create or edit a presentation based on a set of pictures

62. 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?
Answers:
• Through
• Square
• In Front of Text
• In Line with Text

63. Which among the following settings is the default macro security setting?
Answers:
• Disable all macros without notification.
• Disable all macros except digitally signed macros.
• Disable all macros with notification.
• Enable all macros.

64. What does the Compare tool do?
Answers:
• Compares changes in two presentations
• Compares one image to another to indicate differences
• Compares file size
• Compares presentations for backward compatibility

65. Which among the following chart types do not have axes?
Answers:
• Bar charts
• XY (Scatter) charts
• Doughnut charts
• Area charts

66. Format Painter will not normally work with pictures in which the text wrapping is set to:
Answers:
• Square
• Behind Text
• In Front of Text
• In Line with Text

67. Which picture format maintains transparency in MS 2010 Powerpoint?
Answers:
• .png
• .gif
• .jpg
• .wmf

68. How do you insert a new slide master into a presentation?
Answers:
• In Master View, click the Insert Layout button
• In Master View, click the Insert Slide Master button
• In Slide Sorter View, click the Insert Slide Design button
• In Normal editing View, click the Insert Slide Design button

69. How many items can be maintained on the clipboard at one time?
Answers:
• One
• Up to 24
• Unlimited
• Up to 100

70. You added a custom tab in the Microsoft Excel Ribbon and exported this Ribbon Toolbar customization into a file named ‘custom.exportedUI’. After a few days, you import this Ribbon Toolbar customization file back to Microsoft Excel 2010. What will happen to the prior Ribbon Toolbar customizations made during this period?
Answers:
• All prior customizations will be retained.
• All prior customizations will be merged.
• All prior customizations will be lost.

71. How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?
Answers:
• By using the last backup .pst file.
• By scanning the .pst file with scanpst
• By re-logging into the mail account.
• The file cannot be repaired.

72. 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?
Answers:
• Info
• Open
• Options
• None of these

73. 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?
Answers:
• He sets the Line Spacing on the formatting toolbar to 1.0.
• 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.
• He uses the Shift and Enter keys at the same time to create a new paragraph.
• 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.

74. In the given screenshot, the contents of the ‘Name of User’ column have been oriented at an angle. How is this done?
Answers:
• By using the ‘Orientation’ button in the alignment group of the ‘Home’ tab.
• By using the ‘Format Cells’ in the context menu.
• By using the ‘Orientation’ button on the ‘Page Layout’ tab.
• By using the ‘WordArt’ button on the ‘Insert’ tab