Ms Word 2007 odesk test answer 100% correct

Odesk Test Answers MS WORD 2007

Questions: 1:  To find the answer press CTRL+F in your keyboard and type the word(s) you want to find.

Which feature(s) should be selected in order to find and remove hidden data and personal information on office documents?
a.       Blog.
b.      Ballons.
Ans: c.       Document inspector.
d.      All of the above.

Questions: 2:  Which keyboard shortcut is used to make the text size smaller?
Ans: CTRL+SHIFT+<

Questions: 3:  Which among the following options will you use to add a command to the Quick Access Toolbar?
a.   Click on customize quick access toolbar and then click “more command” and choose the command from the list to be customized.
b.   Click on the Microsoft button and then select word options. Click on customized.
c.   On the ribbon, click the appropriate tab or group to display the command that you want to add to the Quick access toolbar. Right click on the command and then click on “Add to quick access toolbar” on the shortcut menu.
Ans:  d.   All of the above.

Questions: 4:  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.

Questions: 5:  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)

Questions: 6:  Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: Linked

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

Questions: 8:  How will you change the author name in an existing document?

Ans: All of the above

Questions: 9:  Which among the following is a keyboard shortcut to cut a table?
a.       CTRL+A.
b.      CTRL+V.
c.       CTRL+C.
Ans  d.      CTRL+X .

Questions: 10:  Which of the following is/are true about phishing?

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

D: Ans: All if the above

Questions: 11:  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

Ans:  b.   More fill colors.
c.   Background color.
d.   Texture.


Questions: 13:  Which among the following wildcards should be used to select any single character?
Ans: ?

Questions: 14:  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.

Questions: 15:  Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author

Questions: 16:  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.

Question 17: Which keyboard shortcut inserts a hyperlink?
a.       CTRL+H.
b.      CTRL+M.
c.       CTRL+P.
Ans: d.      CTRL+K .

Questions: 18:  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

Questions: 19:  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
Questions: 20:  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.

Questions: 21:  Which among the following options could be used to turn off the Office Clipboard?
Ans: All of the above

Questions: 22:  State whether true or false:
New text animation effects can be applied in Microsoft Word 2007.
Ans: False

Questions: 23:  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

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

Questions: 25:  Which among the following options should be used to start a bulleted list automatically?
Ans  a.   Type * (asterisk) and then press spacebar or the Tab key.
b.   Type # and then press the spacebar key.
c.   Type # and then press Enter..
d.   None of the above.


Questions: 26:  Which of the following options repeats a table heading on subsequent pages?
Ans: Repeat Header Rows

Questions: 27:  Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

Questions: 28:  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.

Questions: 29:    Which of the following is not correct regarding “hyphenation zone?
Ans  a.       The hyphenation zone is the maximum amount of space that word 2007 allows between a word and the right margin without hyphenating the word.
b.      The hyphenation zone cannot be changed to make it narrower.
Ans  c.       The number of hyphens can be reduced by making the hyphenation zone wider.
d.      None of the above.

Questions: 31:  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.

Questions: 32:  Which of the following is the correct order to convert a table to text?
a.       Select the table, right-click on it, and select “convert to text”.
Ans  b.      Under table tools, on the insert tab, in the tables group, click on the “convert to text”.
c.       None of the above.
Question 33: 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.

Questions: 34:  Which among the following is a keyboard shortcut to underline blank space for a form?
a.       Ctrl + Hyphen(-).
Ans b.      Shift + Hyphen(-).
c.       Alt + Hyphen(-).
d.      All of the above¬.
    
Questions: 35:  State whether true or false.
In Microsoft Word, a diagram can be converted to individual shapes.
a.       True.
Ans  b.      false.



To find the answer press CTRL+F in your keyboard and type the word(s) you want to find.
Which feature(s) should be selected in order to find and remove hidden data and personal information in Office documents?
Ans: Document Inspector
Which keyboard shortcut is used to make the text size smaller?
Ans: CTRL+SHIFT+<
Which among the following options will you use to add a command to the Quick Access Toolbar?
Ans: All of the above
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.
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) 
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.
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
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
Which among the following charts do not have axes?
Ans: Doughnut charts
Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: Linked
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.
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...
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
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.
Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Doubled
How will you change the author name in an existing document?
Ans: All of the above
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
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.
Which among the following is an invalid character to include in a file name?
Ans: All of the above
State whether true or false:
Gridlines do not print when a document is printed.
Ans: True
Which keyboard shortcut inserts a hyperlink?
Ans: CTRL+K
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.
Which of the following is/are true about phishing?
Ans: All if the above
With the help of which view will the Watermark not be seen?
Ans: Web Layout view
Which of the following types of charts are not supported by either Lines or Bars, as shown in the picture?
Ans: Area charts
Which among the following features could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive
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.
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
Which keyboard shortcut could be used to switch to Draft View?
Ans: ALT+CTRL+N
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
Which view(s) could be used to view the Equation placeholders in the Document Views group?
Ans: All of the above
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
Which of the following is not a Content Control?
Ans: Chart
This question is based upon the figure shown below
Ans: Numbering
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.
Which of the following options repeats a table heading on subsequent pages?
Ans: Repeat Header Rows
Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7
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.
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
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.
Which among the following macro settings is meant for developers only?
Ans: Trust access to the VBA project object model.
State whether true or false:
A building block can be added to as many galleries as you want.
Ans: True
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 information.
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.
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.
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
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
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.
Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author
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.
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.
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.                                                                            
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
predefined list styles are available when you first create a document in Word 2007.
Ans: False
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.
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
Which among the following options could be used to turn off the Office Clipboard?
Ans: All of the above
State whether true or false:
ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
Ans: True
State whether true or false:
New text animation effects can be applied in Microsoft Word 2007.
Ans: False
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
This question is based upon the figure shown below
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.
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


Questions: 36:  How does the “Gutter margin” help while using Page Setup, as shown in the picture?
Ans  a.       It ensures that the text is not obscured by binding.
b.      It prevents the “Full Screen Reading” view from opening automatically.
c.       It displays the field results instead of field codes.
d.      All of the above.

Questions: 37:  How would you divide your word 2007 document into three columns?
a.       Position your cursor where you would like to insert the columns. Open the insert ribbon. In the pages group, click columns, select three.
b.      Position your cursor where you would like to insert the columns. Open the insert ribbon. In the page group, click Page break. Select three.
Ans  c.       Position your cursor where you would like to insert the columns. Open the page layout ribbon. In the arrange section, select three.
d.      Position your cursor where you would like to insert the columns. Open the page layout ribbon. In the page setup section , click columns select three.

Questions: 38:  State whether true or false:
A building block can be added to as many galleries as you want.
Ans: True

Questions: 39:  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

Questions: 40:  This question is based upon the figure shown below
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.

Questions: 41:  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.

Questions: 42:  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.
Ans:  d.      A pie chart should be used when there are more than seven categories.


Question 43: Which keyboard shortcut could be used to switch to Draft View?
a.       ALT+CTRL+P.
b.      ALT+CTRL+O.
Ans: c.   ALT+CTRL+N.
d.      None of the above.

Questions: 44:  Which among the following charts do not have axes?
Ans: Doughnut charts

Questions: 45:  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

Questions: 46:  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.

Questions: 47:  Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Doubled

Questions: 48:  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

Questions: 49:  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.

Questions: 50:  Which among the following is an invalid character to include in a file name?
Ans: All of the above

Questions: 51:  State whether true or false:
Gridlines do not print when a document is printed.
Ans: True

Questions: 52:  With the help of which view will the Watermark not be seen?
Ans: Web Layout view

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

Questions: 54:  Which among the following features could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive

Questions: 55:  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?
a.       Select the Office button and then select Word Options. In the Word Options dialog box, select Proofing and then set your formatting options.
Ans: b.      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..
c.       Select the Office button and then select Track Changes. Set your formatting options in the Track Changes Options dialog box.
d.      Select the Office button and then select Word Options. In the Word Options dialog box, select Customize and then set your own customized formatting options

Questions: 56:  This question is based upon the figure shown below:
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

Questions: 57:  Which view(s) could be used to view the Equation placeholders in the Document Views group?
Ans: All of the above

Questions: 58:  Which of the following is not a Content Control?
Ans: Chart

Questions: 59:  This question is based upon the figure shown below
Ans: Numbering

Questions: 60:  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.

Questions: 61:  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.

Questions: 62:  Which among the following is a correct way to make your file “Read-only”?
a. Click on Open from the Microsoft Office Button. Click on Tools, select the Read-only recommended check box. Click OK.
b.  Select the text you have typed, right click on the mouse and select the “As Recommended” option and save it.
Ans  c.  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.
d.  None of the above.

Questions: 63:  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.

Questions: 64:  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

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

Questions: 66:  This question is based upon the figure shown below.
Which kind of figure does this figure represent?
a.       surface charts.
b.      stock charts.
c.       XY (scatter) charts.
Ans: d.      Area charts.

Questions: 67:  The question is based on the figure below.
Which among the following settings should be applied in the “Format Drawing Canvas” dialog box, as shown in the picture, to remove a border from a drawing object?
a.       Change dashed to none.
b.      Change weight to 0 pt.
Ans: c.       Change line – color to no color.
d.      Change style to none.

Questions: 68:  This question is based upon the figure below.

Refer to the picture given above. Which of the following options should be selected to scroll both documents together?
a.       A.
Ans: b.      B.
c.       C.
d.      None of the above.
     
Questions: 69:  This question is based upon the figure shown below.
For what purpose is the SmartArt graphic control used as shown in the picture?
a.       It is used to rotate the SmartArt graphic.
b.      It is used to add a watermark on shapes.
Ans  c.       It show the test pane on clicking the control.
d.      None of the above.

Questions: 70:  State whether true or false: Cover pages are always inserted at the beginning of a document, no matter where the cursor appears in the document.
Ans: a.       True.
b.      False.

HOW TO BOOT ABLE PENDRIVE FOR Hiren's BootCD

Hiren's BootCD TO

PEN DRIVE BOOT ABLE

First > download: USBFORMAT.zip  and  grub4dos.zip

FORMAT FAT32  and Start with the usbformat.zip >

RUN GRUB4dos and (part list: whole disk MBR click) > install click.

Copy everything from HIREN’S CD to USB Flash Driv.

Copy (grldr and menu.lst from grub4dos.zip) to the usb drive.

FOR LEARN : http://www.hiren.info/pages/bootcd-on-usb-disk

Pass Microsoft excel 2010 odesk test answer

Microsoft excel  2010

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.

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

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

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

This question is based upon the figure shown below

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)

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

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.

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.

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

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.

Microsoft Excel Services is a component of:

a. Microsoft SharePoint Technology

b. Microsoft Server Technology

c. Microsoft Virtualization Technology

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

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

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 cryptographic settings for encrypting documents.

d. None of the above

This question is based upon the figure shown below

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.

This question is based upon the figure shown below

Which of the following tools is used to format Excel worksheet data, as shown in the figure above?

a. Slicer

b. SmartArt

c. Macros

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

Excel keeps the changed history of a workbook for ________ days by default.

a. 10 days

b. 20 days

c. 25 days

d. 30 days

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

This question is based upon the figure shown below

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.

This question is based upon the figure shown below

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

This question is based upon the figure shown below

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!

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

This question is based upon the figure shown below

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.

Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?

a. PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.

b. PowerPivot does not allow access to slicers when working on data in PowerPivot.

c. Version control and tracking are NOT supported by PowerPivot.

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.

This question is based upon the figure shown below

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

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.

This question is based upon the figure shown below

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.

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false:

An Absolute cell reference consists of the column letter and row number.

a. True

b. False

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

State whether following statement regarding cell references in Microsoft Excel 2010 is true or false:

A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

a. True

b. False

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

This question is based upon the figure shown below

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.

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.

What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?

a. .xlsx

b. .xslt

c. .xltx

d. .slk

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

This question is based upon the figure shown below

In the screenshot above, some product sales data is given followed by a pivot table derived from that data. Which of the following options is correct regarding the PivotTable?

a. The data can only be sorted according to the 'Total for three months' field.

b. The data can only be sorted according to the 'Product' field.

c. The data can be sorted according to the 'Total for three months' field, along with filtration using the 'Product' field.

d. None of the above

Microsoft excel

Deleting a PivotChart report automatically deletes the associated PivotTable report.

a. True

b. False

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)

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.

Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?