Monday, July 27, 2015

Odesk Microsoft Word 2010 Test answer

No comments
later, you should:

a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.

Ans : A

Qu :To select vertical blocks of text, you would hold down which key while dragging the mouse?

a. Alt
b. Ctrl
c. Shift

Ans : b

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

Ans : C

Qu : Sarah receives a company turnoversummary in the form of an embedded Excelchart (as shown in the above image) in aMicrosoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?


a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into anexcel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.

Ans : C

Qu : 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 Font of Text
d. In Line with Text

Ans : b

Qu : Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?

a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.

Ans : B

Qu : A particular chart layout can be applied to a chart only if:

a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.

Ans : C

Qu : choose the INCORRECT statement:

a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.

Ans : A

Qu :Microsoft Word 2010 has enabled ligatures for which of the following fonts?

a. Open Type fonts
b. True Type fonts

Ans : a

Qu : 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

Ans : b

Qu : Which of the following is NOT an option under File > Print > Microsoft DocumentImage Writer?

a. PDF
b. TIFF
c. MDI

Ans : c

Qu : I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

a. BMP
b. PDF
c. XLS
d. JPG

Ans : c

Qu : What view must be used when inserting a subdocument?

a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading

Ans : b

Qu : Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?


a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.

Ans : C

Qu : Which of the following in NOT a type of Section Break?


a. Next Page
b. Linked
c. EvenPage
d. Continuous

Ans : d

Qu : Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010which can be used to achieve this result with a single click. Please identify it.

a. Breaks
b. Indentation
c. Orientation
d. Hyphenation

Ans : c

Qu : Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?

a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas

Ans : b

Qu : When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.

a. True
b. False

Ans : b

Qu : My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?

a. "Allow row to break across pages" is unchecked.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table

Ans :  a

Qu : Under Insert > Date & Time, you can create custom formats for date and time, and set them as default.

a. True
b. False

Ans : a

Qu : Martha is writing an article on time management. After typing some text, as shown in Image A, she goes to the other room to make a phone call. On returning, she finds that her 8-year-old son changed some settings in the document, saved and closed the file, so that on re-opening it looks as shown in Image B. What should Martha change to make the document look the same as before?

a. Select the paragraph and remove the numbering.
b. Set the "Line Numbers" to None under the Page Layout controls.
c. Select the paragraph and re-apply numbering.
d. Copy the complete text to notepad and then paste it back

Ans : a

Qu : Which among the following chart types do not have axes?

a. Bar charts
b. XY (Scatter) charts
c. Doughnut charts
d. Area charts

Ans : c

Qu : 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:

a. be spread across both cells.
b. be deleted.
c. remain intact in the first cell and the second cell will be empty

Ans : c

Qu : How many items can be maintained on the clipboard at one time?

a. One
b. Up to 24
c. Unlimited
d. Up to 100

Ans : c

Qu : 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

Ans : a

Qu : To convert an existing picture to the shape of a star, which of the options will be useful?

a. Picture Effects
b. Insert Shapes
c. Picture Layout
d. Crop to Shape

Ans : a

Qu : Why would you use content controls in a document?


a. 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.
b. 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.
c. 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.
d. All of the above
e. None of the above

Ans : d

Qu : Anna selects a paragraph in a Microsoft Word 2010file. On the horizontal ruler, she drags the Hanging Indent marker to the left. What will happen?

a. The whole paragraph will get indented to the left.
b. The first line will get indented to the left.
c. All but the first line will get indented to the left.

Ans : c

Qu : Which of the following protects a document from changes in Microsoft Word 2010?

a. Restrict Editing
b. Encrypt with Password
c. Add a Digital Signature
d. Mark as Final
e. All of the above

Ans : e

Qu : Which among the following is not true regarding the use of a pie chart?

a. A pie chart could be used when there is only one data series to be plotted.
b. A pie chart could be used when the data points in a pie chart are displayed as a percentage of the whole pie.
c. A pie chart could be used when none of the values that need to be plotted on the chart is negative.
d. A pie chart should be used when there are more than seven categories.

Ans : b

Qu : 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

Ans :d

Qu :Which among the following options represents Legend entries in the given picture?


a. A
b. B
c. C
d. None of the above

Ans :  a

Qu : The Insert Picture option allows you to insert:

a. Insert "Link to File"
b. Insert "File"
c. "Insert and Link" to a File

Ans :  b

Qu : You want to select all instances of a specific style used in your document. However, the Select All command in the Styles pane is not available (grayed out). You must enable:

a. Formatting marks
b. Keep track of formatting
c. Linked styles

Ans :  c

Qu : Applying a theme to your document affects all content except tables.

a. True
b. False

Ans :  b

Qu : What is the function of Widow/Orphan control in Microsoft Word 2010?

a. It is a feature that prevents single lines of paragraphs from appearing on a separate page from the rest of the paragraph.
b. It is a feature which indents only the first line of a paragraph.
c. It is a feature used to change the layout or formatting of a page or pages.
d. It is feature which is used to insert ghosted text behind the content of the page.

Ans :  c

Qu : You need to insert an image of only part of a web page that is currently open in your browser. You would use:

a. Insert, Screenshot
b. Insert, Screen Clipping
c. Print Screen
d. Insert, Image

Ans :  b

Qu : You need to email a picture to your co-workers, but the file is too large. Where on the Picture Tools ribbon would you find the option to minimize the file size for email sharing purposes:

a. Corrections
b. Change Picture
c. Compress Picture
d. Picture Layout

Ans :  c

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

a. True
b. False

Ans :  a

Qu : 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 

Ans : b

Q#01
In the above given screenshot
of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data.
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?  
    a. The value of cell D9 will be 24
    b. The value of cell D9 will be 42
    c. The value of cell D9 will be #VALUE!
Answer is (B). The value of cell D9 will be 42

Q#02
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.
Answer is (B). The red triangles signify an associated data validation control
Q#03
Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.  
    a. Content that people with disabilities might find difficult to read.
    b. Checking features not supported by earlier versions of Excel.
    c. Both a and b
Answer is (A).Content that people with disabilities might find difficult to read.

Q#04
Analyze the image shown.

What would be the output when you use the following formula in an MS Excel 2010 worksheet?
=SUM(A2:CHOOSE(2,A3,A4,A5))  
    a. 67
    b. 80
    c. 90
    d. 60
Answer is (B).80

Q#05
Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?  
    a. Gradient Fill
    b. Crystal Fill
    c. Texture Fill
Answer is (A). Gradient Fill

Q#06
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
Answer is (C).Values

Q#07 
What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?  
    a. .xlsx
    b. .xslt
    c. .xltx
    d. .slk
Answer is (C).xltx

Q#08
Which among the following settings is the default macro security setting?  
    a. Disable all macros except digitally signed macros.
    b. Disable all macros with notification.
    c. Enable all macros.
Answer is (B). Disable all macros with notification

Q#09
Suppose you have created a report in Excel named 'report.xlsx'. Now you want that 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?  
    a. Share 'report.xlsx' by saving it to SkyDrive.
    b. Share 'report.xlsx' by saving it to a SharePoint site.
    c. Share 'report.xlsx' by sending it through email.
Answer is (A).Share'report.xlsx' by saving it to skyDrive.

Q#10
Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
    a. Excel Calculation Services (ECS)
    b. Excel Web Access (EWA)
    c. Excel Web Services (EWS)
Answer is (B).Excel Web Access (EWA)

Q#10
Analyze the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value, lookup_vector, result_vector)
The values in the lookup_vector must be placed in ________ order.  
    a. Ascending
    b. Descending
    c. Either ascending or descending
Answer is (A).Ascending

Q#11
_________________________________________________________
Which of the following statements is NOT true regarding import of data into PowerPivot?  
    a. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.
    b. The data being imported into PowerPivot can be filtered before the import.
    c. The PowerPivot Import Wizard provides you with an SQL Query builder.
Answer is (B).The data being imported into PowerPivot can be filtered before the import.

Q#12
 Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?  
    a. The worksheet grid in Excel Web Access on SharePoint Foundation 2010 Server is limited to 20 columns and 75 rows.
    b. It is possible to select contiguous and noncontiguous cells on a worksheet using mouse and keyboard.
    c. It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.
Answer is (C).it is not possible to use the CTR+Enter keyboard combination on formulas entered in multiple cells inn a worksheet

Q#13
Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?  
    a. Cell Color
    b. Font Color
    c. Font Style
Answer is (C).Font Style

Q#14 
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?  
    a. Scenarios
    b. Data tables
    c. Goal Seek
Answer is (A).Scenarios
Q#15 

When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.  
    a. Table
    b. Worksheet
    c. Workbook
Answer is (B).Worksheet

Q#16 
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. If you delete the offline cube file for a report, still you can create a new offline cube file for the report.
    c. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
Answer is (C).An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

Q#17 
You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?  
    a. 2-Color Scale
    b. 3-Color Scale
    c. 4-Color Scale
    d. Data Bar
Answer is (C).4-Color Scale

Q#18 
Microsoft Excel Services is a component of:  
    a. Microsoft SharePoint Technology
    b. Microsoft Server Technology
    c. Microsoft Virtualization Technology
Answer is (A).Microsoft SharePoint Technology

Q#19 
Analyze the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value, lookup_vector, result_vector)
Which of the following arguments of the LOOKUP function is optional?  
    a. lookup_value
    b. lookup_vector
    c. result_vector
Answer is (C).Result-vector

Q#20 
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.
Answer is (D).All of the above

Q#21
Excel keeps the changed history of a workbook for ________ days by default.  
    a. 10 days
    b. 20 days
    c. 25 days
    d. 30 days
Answer is (D).30 days

Q#22
Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?  
    a. One limitation of PowerPivot is that it does not allow access to Slicers when working on data in PowerPivot.
    b. A connection to a server running SQL Server Analysis Services is required to answer PivotTable queries by the PowerPivot engine.
    c. Version control and tracking is supported by PowerPivot.
Answer is (B).80

Q#23
 What does the icon marked with a red square in the figure above signify?  
    a. It signifies that a macro is enabled.
    b. It signifies that the document contains digital signatures.
    c. It signifies that a macro is disabled.
    d. It signifies that a webcam has been detected.
Answer is (B). It signifies that the document contains digital signatures.

Q#24 
State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.  
    a. True
    b. False
Answer is (B). False

Q#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 cryptography settings for encrypting documents.
    d. None of the above
Answer is (B). it ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.

Q#26 
which of the following tools is used to format Excel worksheet data, as shown in the figure above?  
    a. Slicer
    b. SmartArt
    c. Macros
Answer is (B). SmartArt

Q#27 
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
    d. All of the above
Answer is (C). online Analystical Processing (OLAP) Cube File

Q#28
In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?  
    a. By using the 'Orientation' button in the alignment group of the 'Home' tab.
    b. By using the 'Orientation' button on the 'Page Layout' tab.
    c. By using the 'WordArt' button on the 'Insert' tab.
Answer is (A). By using the 'Orientation' button in the alignment group of the 'Home' tab.

Q#29

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.
Answer is (A). It will select the whole sheet, having the same effect as that of Ctrl+A.

Q#30
State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.  
    a. True
    b. False
Answer is (B). False

Q#31 
Which of the following axis settings are available for the appearance of bars for negative values in Microsoft Excel 2010?  
    a. Automatic
    b. Cell right
    c. Cell left
Answer is (C). Cell left

Q#32 
Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?  
    a. One limitation of PowerPivot is that it does not allow access to Slicers when working on data in PowerPivot.
    b. A connection to a server running SQL Server Analysis Services is required to answer PivotTable queries by the PowerPivot engine.
    c. Version control and tracking is supported by PowerPivot.
Answer is (C). Version control and tracking is supported by PowerPivot.

Q#33 
Deleting a PivotChart report automatically deletes the associated PivotTable report.  
    a. True
    b. False
Answer is (B). False

Q#34

With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?  
    a. =AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
    b. =AVERAGE(E6:E15)
    c. =(SUM(E6:E15)/COUNT(E6:E15))
    d. =AVERAGE(E6 to E15)
Answer is (D). =AVERAGE(E6 to E15)

Q#35 
Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?  
    a. Cell midpoint
    b. Cell left
    c. Cell right
Answer is (B). Cell Left

Q#36 
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.
Answer is (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.

Q#37

Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?  
    a. All cloned copies of that slicer are also updated instantly.
    b. Only the original slicer reflects the changes being made.
    c. An error is displayed because no updations are allowed in slicers having cloned copies.
    d. None of the above.
Answer is (A). All cloned copies of that slicer are also updated instantly.

Q#38 
State whether the following is true or false:
Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook  
    a. True
    b. False
Answer is (B). False

No comments :

Post a Comment