Upwork Test Answers: Get all the correct answers of most recent and possible Upwork Tests A to Z (Updated on Jan, 2016)
Cover Letter Templates: These cover letter samples are not only for Upwork job, but also you will have some idea about your real life job
 
Freelance Profile Overviews: Different Profile samples and overviews of experts, advanced and intermediate level freelancers
For Newbie of Upwork: Upwork Help - How to apply for a job in Upwork with 10 most important articles about Upwork

A to Z View - All Upwork Test Answers

Knowledge of Microsoft Office Skills Test Answer

New Test Answers of Upwork Knowledge of Microsoft Office Skills Test Updated on October 2015:


In Microsoft Word 2010, "Keep lines together" paragraph formatting:
Answers: • does not work for paragraphs within a table if "Allow row to break across pages" is also selected.

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: • In Line with Text

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.

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.

Which of the following types of worksheets will not load in Microsoft Excel Services?
Answers: • Worksheets with ActiveX controls

Why would you use content controls in a document?
Answers: • All of the above

Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?
Answers: • Delete records permanently

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: • False

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

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: • "New documents based on this template" under modify style option.

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

What is one way to ensure that the sound icon doesn't show in the presentation?
Answers: • By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show

Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?
Answers: • You can set a password for individual folders within the .pst.

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: • Online Analytical Processing (OLAP) Cube Files

With which chart type(s) is the "Depth Gridlines" option available?
Answers: • True 3D chart

Which of the following tag is not available in Microsoft Outlook 2010?
Answers: • Unread/read

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

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: • Both Statements X and Y are correct.

Which of the following is not a category of transition?
Answers: • Dynamic Content

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

How can you remove duplicate emails present in a particular folder?
Answers: • By using the Clean Up Folder option.

How do you turn off the controls that show in the lower left corner of the screen during a slide show?
Answers: • Choose the menu File -> Options -> Advanced and select Show Popup Toolbar

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: • Data tables

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

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.

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

Which of the following are included in a digitally signed e-mail message?
Answers: • Certificate

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

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: • Any of the above methods can be used.

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

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

Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Answers: • Values

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.

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: • remain intact in the first cell and the second cell will be empty.

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.

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

What is one thing the Compress Pictures feature does?
Answers: • Permanently deletes cropped areas of pictures

Which of the following is NOT an option when inserting a Cross-reference?
Answers: • SmartArt

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

What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Answers: • It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.

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

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

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

Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Answers: • The file format for an offline cube file is .ocf.

To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
Answers: • References" >"Insert Citation" >"Add New Source.

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: • /resetnavpane

How would you write on the slides during a slide show?
Answers: • 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.

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: • Business Project

The default chart colors are determined by what?
Answers: • Slide Fill Shading

How would you assign a macro to a graphic?
Answers: • You can use any of the above three techniques.

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 disable all the links in the e-mail.

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.

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Answers: • All of the above.

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.

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 a SharePoint site.

How would you add a logo to all the slides in a presentation?
Answers: • In the Slide Master View, add the logo to the slide master and the title slide layout.

Which of the following defines the correct purpose of using a poster frame image?
Answers: • To add still image introduction to the video

Which among the following settings is the default macro security setting?
Answers: • Disable all macros with notification.

What does the Compare tool do?
Answers: • Compares changes in two presentations

Which among the following chart types do not have axes?
Answers: • Doughnut charts

Format Painter will not normally work with pictures in which the text wrapping is set to:
Answers: • In Line with Text

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: • Safe Lists Only

Which picture format maintains transparency in MS 2010 Powerpoint?
Answers: • .gif

How do you insert a new slide master into a presentation?
Answers: • In Master View, click the Insert Slide Master button

In the Customize Ribbon dialog, choosing Reset All Customizations does what?
Answers: • It restores the Ribbon to the default settings.

How many items can be maintained on the clipboard at one time?
Answers: • Up to 24

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

How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?
Answers: • By scanning the .pst file with scanpst

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: • Open

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 selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents and Spacing, he sets the Spacing "Before" and "After" options to zero.

No comments:

Post a Comment