oDesk MS Word 2007 Test with Answers

1.  Which among the following methods would you select when you want to add protection to parts of a template?

Ans:  Go to the Developer tab, click on Properties in the Controls group and then click any of the Locking options in the Content Control Properties dialog box.

2. Which of the following is/are true about phishing?

Ans: All if the above

3. This question is based upon the figure shown below

In some cases, when lists are combined into one "List," the formatting is not updated. Refer to the picture given above. Which among the following options should be used to update this formatting?

Ans: D

4. Which among the following charts do not have axes?

Ans: Doughnut charts

5. Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:

Ans: Linked

6. This question is based upon the figure shown below

 Ans: It ensures that the text is not obscured by binding.

7. With the help of which view will the Watermark not be seen?

Ans: Web Layout view

8. This question is based upon the figure shown below

How will the Message Bar alerts be enabled as shown in the given picture?

Ans: Select Word Options from the Microsoft Office Button. Click on Trust Center, then click Trust Center Settings, and then click Message Bar.

9. Which among the following is not a Bookmark option to sort the list of bookmarks in the document?

Ans: Author

10.  This question is based upon the figure shown below

 Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?

Ans: This option allows you to remove the Page Number from the first page.

11. State whether true or false:
Once a bullet is removed from the "Bullet Library" and it is no longer available in the "Document Bullets" area, the bullet cannot be added back to the Bullet Library.

Ans: False

12.  This question is based upon the figure shown below

Which of the following types of charts are not supported by either Lines or Bars, as shown in the picture?

Ans: Area charts

13. Which among the following features could be used to create a connection to a Shared Network folder?

Ans: Map Network Drive

14. Edit tracking changes are typically formatted in the following manner: (1) deletions—red strikethroughs, (2) additions—green and underlined, and (3) formatting changes are made bold in almost any other desired color. Where in Word 2007 could you set your own custom formatting options for tracking changes?

Ans: Select the Review ribbon and then select the triangle by Track Changes. In the drop-down menu, select "Change Tracking Options" and then set your formatting options in the Track Changes Options dialog box.

15. How will you insert text boxes for a printed form?

Ans: Select the Insert tab, in the Text group, click on Text Box and then select Draw Text Box.

16. To enter a symbol or special character into your document (to where the cursor is located), which of the following methods could you employ in Word 2007?

Ans: Open the Insert ribbon. Click Symbol in the Symbols group. A menu will appear with a small selection of symbols. If you don't see the symbol or character you'd like to insert, click More Symbols. Choose the special character (or symbol) that you want and then click Insert and click Close.

17. You are editing a figure using the Drawing Tools > Format options. Which among the following Shape Fill options in the Shape Styles group adds a solid color and transparency to a shape?

Ans: More Fill Colors...

18. State whether true or false:
When you save a document as a Web page, the textures and gradients are saved as JPEG files and the patterns are saved as GIF files.

Ans: True

19. Which among the following options is the reason of text deletion at the insertion point when you type a document?

Ans: The "overtype mode" is turned on in Word options.

20. What is meant by Enhanced ScreenTips?

Ans:  Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic.

21. This question is based upon the figure shown below

Refer to the given picture. Which of the following Line Numbers should be used when each page has to begin with the number 1?

Ans: Restart Each Page

22. Which keyboard shortcut could be used to switch to Draft View?

Ans: ALT+CTRL+N

23. State whether true or false:

The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.

Ans: True

24. Which view(s) could be used to view the Equation placeholders in the Document Views group?

Ans: All of the above

25. State whether true or false:
Any changes that are saved to "Normal.dotm" will be applied to the documents that you create in the future.

Ans: True

26. State whether true or false:
Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.

Ans: True

27. How will you set the default font so that every time you open Microsoft Word it will use the settings that you had selected?

Ans: Select the Home tab, and then click the Font Dialog Box Launcher. Select the font style and size. Click on Default... and then click Yes.

28. Which of the following line-spacing options sets fixed line spacing that Word does not adjust?

Ans: Doubled

29. How will you change the author name in an existing document?

Ans: All of the above

30. State whether true or false:
Microsoft Office programs store some additional information within the digital signature automatically that might not be visible in the current view document.

Ans: True

31. Which among the following options could be used to turn off the Office Clipboard?

Ans: All of the above

32. What does the command "Winword.exe /f MyDocument.docx" mean?

Ans: This command instructs Word to start and immediately open a file named MyDocument.docx.

33. Which among the following is an invalid character to include in a file name?

Ans: All of the above

34. State whether true or false:
Gridlines do not print when a document is printed.

Ans: True

35. Which keyboard shortcut inserts a hyperlink?

Ans: CTRL+K

36. Which among the following wildcards should be used to select any single character?

Ans: ?

37.  This question is based upon the figure shown below

 Refer to the given image. Which option should be selected to convert a professionally formatted equation into an equation on one line?

Ans: C

38. Which of the following is not a Content Control?

Ans: Chart

39. This question is based upon the figure shown below

Ans: Numbering

40. Which among the following is a correct way to make your file "Read-only?"

Ans: Click "Save As" from the Microsoft Office Button. Click on Tools and then click General Options. Select the Read-only recommended check box. Click OK. Click on Save.

41.  Which among the following options should be used to start a bulleted list automatically?

Ans: Type * (asterisk) and then press spacebar or the Tab key.

 42.

Which of the following can be the reason for the appearance of the red X, as shown in the picture?

Ans: All of the above

43. State whether true or false:
ASCII-formatted text contains no formatting information such as bold, italic, or fonts.

Ans: True

44.  State whether true or false:
New text animation effects can be applied in Microsoft Word 2007.

Ans: False

45. Which among the following options should be used to number the cells in a table?

Ans: Select the table cells that need to be numbered. On the Home tab, in the Paragraph group, click on Numbering.

46. Which of the following options repeats a table heading on subsequent pages?

Ans: Repeat Header Rows

47. Which keyboard shortcut could be used to check the spelling of a text file?

Ans: F7

48. Which among the following is not true regarding the use of a pie chart?

Ans: A pie chart should be used when there are more than seven categories.

49. This question is based upon the figure shown below

Refer to the given picture. Which of the following options turns off Enhanced ScreenTips but keeps the ScreenTips still visible?

Ans: B

50. Unlike the other types of styles (paragraph, character, linked, and table), predefined list styles are available when you first create a document in Word 2007.

Ans: False

51. This question is based upon the figure shown below

What is the maximum number of columns that can be created in the Columns dialog box as shown in the picture?

Ans: 13

52.  This question is based upon the figure shown below

Refer to the given image. In Picture1, axes appear on the left side. Which setting should you use to make them appear on the right side, as shown in Picture2?

Ans: Select the Axis Options tab in the Format Axis dialog box. Set the Axis labels: field to High.

53.  Which of the following two paragraphs is/are true for Word 2007?
(1)To show or hide formatting marks in your editing markup — on the Home ribbon, in the Paragraph group, click the Show/Hide button.
(2) The Show/Hide button will not hide all the formatting marks in the document if you selected those marks that are to be displayed at all times (such as paragraph marks, tab characters, hidden text, optional hyphens, object anchors, or spaces). To turn off any or all of these selected formatting marks, follow this procedure: Click the Microsoft Office Button and then click Word Options. Then Click Display. Under "Always show these formatting marks on the screen," clear the check boxes for any formatting marks that you do not want to show at all times in your documents.

Ans: Both (1) and (2)

54. This question is based upon the figure shown below

 In the given picture, the "Washout" option has been selected. What purpose does it serve?

Ans: It lightens the picture so that it does not interfere with the text.

55. The default installation of Word 2007 includes several built-in character styles. Which of the following is NOT one of the default, built-in character styles:

Ans: Special Emphasis

56. What steps should be followed to replace a shape with other shape?

Ans: Select the shape to be changed. Select the Format tab; use the "Change Shape" button in the Shape Styles group.

57. Just as in Word 2003 or prior Word versions, the default standard view for Word 2007 is the Draft view (and is still also called the Normal view in Word 2007):

Ans: False

58. This question is based upon the figure shown below

 What is the purpose of the "Demote" button as shown in the diagram?

Ans: It increases the level of a selected bullet or a shape.

59. Which feature(s) should be selected in order to find and remove hidden data and personal information in Office documents?

Ans: Document Inspector

60. Which keyboard shortcut is used to make the text size smaller?

Ans: CTRL+SHIFT+<

61.  Which among the following options will you use to add a command to the Quick Access Toolbar?

Ans: All of the above

62. Which option(s) should you select to remove a chart or axis title from a chart?

Ans: To remove an axis title, select the Layout tab. In the Labels group, click on Axis Titles, click the type of axis title, and then click None.

63.  Which among the following macro settings is meant for developers only?

Ans: Trust access to the VBA project object model.

64. State whether true or false:

A building block can be added to as many galleries as you want.

Ans: True

65. Which of the following is/are true about phishing?

Ans: It is an online fraud technique used by criminals to lure users into disclosing their personal in

MS Word 2003 Odesk test answers

1. If the word “trick” is displayed on the screen, with the cursor between the letters ‘i’ and ‘c’ and the Delete key is pressed.  said word appear on the screen?

Ans: trik

2. How can you create a non-breaking hyphen?
   
Ans: Press CTRL+SHIFT+HYPHEN
   ­
3. When you left-click on the Insert menu option and click Page Numbers, a pop up window opens. Which of the following  is/are available in the pop-up menu?  

Ans: Position

4. The figure shows the Margins tab under the File > Page Setup menu. The gutter margin has been set at 0.1″. What is a gutter margin?
   
Ans: Some extra space added to the right margin of the page required for cutting the page into even sizes at the time of binding.

5. The title bar is present at the top of the Microsoft Word 2003 window.  What does it contain at the left corner?

Ans: Maximize Button

6. Which of the following are valid sources for storing the addressee information required for Word 2003 mail merge?
  
Ans: All of above

7. What are sections used for in a Word 2003 document?  
Ans: They are used to divide the document into parts so that each part may be independently printed when the print command is given.

8.  State whether True or False. In a Word 2003 document, if the formatting is restricted, the commands and keyboard shortcuts that apply formatting directly not available.

Ans: True

9. How can you create a box around the text that is placed on a web page,  as shown in the figure?
   
Ans: Draw a rectangle around the text using the rectangle drawing tool.

10. A documents having many paragraphs, the appearance of the documents can be improved by increasing the spacing between paragraphs. Where in word, is the built-in option that allows you to add such space?
  
Ans: Click on Format- Paragraph;   go to the Spacing section and change the “Before”  and  “After “ fields.

11.  State whether the following statement is true or false. Once a macro is running,  it is not possible to stop it.  

Ans: False

12. What does the CTRL+U shone accomplish in Word 2003?   

Ans: It underlines the selected word

13. What is the function of AutoSummarize feature in Word 2003?   

Ans:  It summarizes the statistics of the document into a report, such as total words,  total characters, total pages, total  paragraphs, file size etc.
 
14. How can you resize the width or height of a picture in a Word 2003 document?  Select all of the answers below that  apply.   

Ans: By right-clicking on the picture and, from the Format Picture floating menu, choose the “Size” tab.

15.  What is the tab stop in Word 2003?   

Ans: A position you set for placing and aligning text on a page.

16. Where is the mail Merge feature located in the main menu?


Ans:  In the Tools menu

17. How can you insert a sound file in a Word 2003 Document?   

Ans: From the Insert > Object menu option

18. Which font effect has been applied on the text shown in the figure?  
Ans: Emboss

19. What does the CIRL+I shortcut accomplish in Word 2003?

Ans:  It applies italic formatting to the selected text.

20. You are required to prepare an essay in Word 2003 consisting of only 250 words. What is the most convenient way for you to count the total number of words in your document?

Ans:  Choose the “Word Count” option under the Tools menu.

21. What is the method to disable the Reading Layout feature and open documents in the default (Print Layout)?  

Ans: Click the Tools menu and choose Options; when the Options multi-tabbed dialog box appears, click General. Uncheck ‘Allow Starting in Reading Layout.” Click OK.

22. You want to view a document in the Reading Layout view. What will you do?  

Ans: Press ALT+R
 
23. A paragraph can be made to stand out from the rest of the document by giving it a border or shading. How can you give a (selected) paragraph a special shade?  

Ans: Select Format > Borders and Shading. Select the Shading tab. Select the Color and click OK.

24. When you right-click on a cell of a table drawn in a Word 2003 document, you can see the properties and options and figure. The Split Cells option has been highlighted in the figure. What is the function this option  

Ans: It allows you to divide an existing cell of a table into more rows and columns.

25. Can you give a 3-D (3-Dimensional) effect to your text and, graphics using Word 2003?
Ans: Yes

26. Which feature of Word 2003 allows you to use information from two different files for the quick creation correspondence and other documents like interview letters and invitations?   

Ans: Mail Merge

27. What does the CTRL+B shortcut accomplish in Word 2003?  

Ans: It makes the selected text bold.

28. State whether the following statement is true or False. It is possible to add custom words to the dictionary that Word 2003 uses to check spelling errors in document.  

Ans: True

29. There are over a hundred predefined formatting styles in Word 2003 to choose from. However, only a small number of them are displayed in the default list of styles. If you want to see all formatting styles (both predefined and customized), you could:  

Ans: Press the SHIFT key and click the arrow on the Style drop-down menu button on the formatting toolbar.

30. What will you do to print an A5-size (148mm x 210mm) document on A4-size (210 x 297mm) paper?

Ans: Select File > Print. Under Zoom, specify the paper size in the “Scale to Paper Size” list as A4.

31. Can you change the background picture of a Word 2003 Theme that has been applied to a page?  

Ans: Yes

32. What are bookmarks used for?   

Ans:  To quickly jump to a specific location in the document.

33. Normally when you click on the File menu, Microsoft Word 2003 shows you the names of the last four files used. How can that be increased?
  
Ans:  Under Tools > Options: click the General tab. Increase the number on the “Recently Used File List” option.

34.State Whether True or False You can open the Find and Replace dialog box by pressing the CTRL+F key combination  

Ans: True

35.Can you insert a new table inside a cell of an existing table in your word 2003 document.  

Ans: Yes

36. The figure shows the edit tab under the Tool >Options menu The Enable click and type Options has been checked what does the this potation performs.   

 Ans:  Its allows you to quickly insert text, graphics, table or other items in a blank area of a document.

37.Which of the following functions is used to replace quotes (“) will smart quotes (“) in the text documents.  

Ans: Tools> Auto format

38.Wrapping Styles can be used to modify the layout of text in relation to a graphic. Which style wraps the text around a graphic in a irregular bounding the actual image? (the graphic will move as text is added or deleted.

Ans: in line with text

39. The given figure shows the reviewing toolbar. What function is performed by the button marked by the letter X.

Ans:  It allows you to highlight the selected text or graphic in a document.

40. The fiqure shows the Save As dialog box under File menu. The Save As type has been specified as XML document and them apply transfrom option has been checked (selected). What does this mean.  

Ans: It allows you to change the author name for the XML file.

41. In Microsoft word 2003, you can easily created bulleted or numbered lists of items. What is the method for removing the numbering.

Ans: Highlight the number list choose formats > Bullets and numbers from the menu and click none click ok.


42. Which word 2003 toolbar is show in the figure?
Ans: Picture toolbar

oDesk skill test MS word 2010 Answers

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