Microsoft Office Skills Test (Upwork) | Practice Test / Quiz / MCQs

2. Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?

You can set a password for individual folders within the .pst.If you are running Outlook with a Microsoft Exchange account - your data for that account - including password access - is automatically managed by Microsoft Exchange.None of the aboveReviewerThere 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.

3. 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?

Business ContactBusiness ProjectMarketing ActivityReferences' >'Insert Citation' >'Add New Placeholder.Opportunity

4. How would you write on the slides during a slide show?

On the Slide Show tab - in the Set Up group - select a pen and then drag it to write.All of the aboveReferences' >'Insert Citation' >'Add New Placeholder.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.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.

5. Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?

Create new recordsUpdate recordsDelete records permanentlyMove records to the Deleted Items folderTo 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.

6. 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?

All prior customizations will be merged.All prior customizations will be retained.All prior customizations will be lost.UnlimitedUp to 100

8. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List - calculates the aggregates of columns?

AppointmentRow LabelsReport FilterValuesTask Request

9. Which of the following types of worksheets will not load in Microsoft Excel Services?

Worksheets with tablesWorksheets with Organization Charts and DiagramsMicrosoft Excel 2010 validates images which are in the form of external and active content.Worksheets with hyperlinksWorksheets with ActiveX controls

10. What is one way to ensure that the sound icon doesn't show in the presentation?

By applying a transparent picture fill effect to the sound icon on the slideAll of the aboveBy clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide showBy choosing Hide During Show from the Audio Tools Playback tab of the RibbonReviewer

11. 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?

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

13. How can you remove duplicate emails present in a particular folder?

By sorting the emails received in a particular folder.By using the Clean Up Folder option.By repeatedly using the Send/Receive mails option.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 applying filtration of the email according to groups - in a particular folder.

14. 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?

Statement X is correct. Statement Y is incorrect.CategorizeStatement X is incorrect. Statement Y is correct.Both Statements X and Y are incorrect.Both Statements X and Y are correct.

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

Contextual tabsModal tabsStandard ribbon tabsPlaces your cursor on the next object on the slideIn the Insert tab

16. Which of the following defines the correct purpose of using a poster frame image?

works well for paragraphs within a table if 'Allow row to break across pages' is also selected.To add visual effect to the narrationTo insert a picture on any part of the screenTo add still image introduction to the videoTo create or edit a presentation based on a set of pictures

18. Why would you use content controls in a document?

All of the aboveTo 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.Worksheets with Organization Charts and DiagramsTo 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.

19. Consider the following scenario: table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:

be spread across both cells.Turn field shading off.remain intact in the first cell and the second cell will be empty.Make the field hidden.be deleted.

20. What does the Compare tool do?

Disable all macros without notification.Compares presentations for backward compatibilityCompares file sizeCompares changes in two presentationsCompares one image to another to indicate differences

21. Which of the following statements regarding images in Microsoft Excel 2010 are true?

Cell midpointMicrosoft Excel 2010 validates images which are in the form of external and active content.Microsoft Excel 2010 supports 3D rotation of images.Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.

22. Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?

By 1st Level ParagraphsAs one objectOne by oneDim after animationbe spread across both cells.

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

Copy the style to each document manually each time you want to use it.Background Color'New documents based on this template' under modify style option.Pattern'Add to Quick Style List' in the Styles pane.

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

It displays the time taken by the first slide.FalseNone of the aboveTruelookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know? Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com