Microsoft Word 2010 Test Answers 2017 - Upwork Microsoft 2010 Test Answers

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

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

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

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

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

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

4. Using the Draw Table option, it is possible to split an existing table cell into two separate and distinct cells:

Answers:
a. horizontally
b. vertically
c. diagonally

5. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

Answers:
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.

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

Answers:
a. Alt
b. Ctrl
c. Shift

7. Below are two statements regarding Breaks in Microsoft Word 2010.

Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text.
Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page.

Which of the following options is correct?

Answers:
a. Statement X is correct. Statement Y is incorrect.
b. Statement X is incorrect. Statement Y is correct.
c. Both Statements X and Y are correct.
d. Both Statements X and Y are incorrect.

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

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

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

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

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

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

11. Which of the following is NOT a type of Section Break?

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

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

Answers:
a. True
b. False

13. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:

Answers:
a. References” > “Style”.
b. References” >”Insert Citation” >”Add New Source.
c. References” >”Insert Citation” >”Add New Placeholder.
d. None of the above

14. What is the function of Widow/Orphan control in Microsoft Word 2010?

Answers:
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.
d. It is a feature used to change the layout or formatting of a page or pages.
e. It is feature which is used to insert ghosted text behind the content of the page.

15. Microsoft Word 2010 enables you to wrap text easily around pictures, shapes and tables with any position or style that you want. When should a “Text wrapping break” be used?

Answers:
a. While applying a wrapping style to an image.
b. While applying a wrapping style to a table.
c. When you want to separate text around objects on web pages.
d. When you want to see the hidden formatting marks used in the page.

16. Microsoft Word 2010 has enabled ligatures for which of the following fonts?

Answers:
a. Open Type fonts
b. True Type fonts

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

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

18. Consider the following scenario:

A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:

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

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

Answers:
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 View Tab.
d. A preset Watermark was inserted.

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

Answers:
a. True
b. False

21. Which among the following chart types do not have axes?

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

22. Martha is preparing a trigonometry worksheet for her students. She wants to include the following example in the sheet. Which is the quickest way to achieve this?

Answers:
a. Click Formula on the Insert tab.
b. Click Symbol on the Insert tab.
c. Click WordArt on the Insert tab.
d. Click Equation on the Insert tab.

23. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?

Answers:
a. Through
b. Square
c. In Front of Text
d. In Line with Text

24. If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?

Answers:
a. Even Page
b. Odd Page
c. Continuous

25. What view must be used when inserting a subdocument?

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

26. Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft 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 Sarah do to achieve this in the shortest possible time?

Answers:
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 an excel 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.

27. With which chart type(s) is the “Depth Gridlines” option available?

Answers:
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above

28. Dave receives a file named Theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

Answers:
a. By pasting all the text of the report in the PowerPoint file which opens on double clicking the .thmx file and then saving it as a Word document.
b. By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.
c. Dave’s Boss is wrong. No such arrangement is possible in Microsoft Word 2010.
d. By opening the Word file containing the report, and importing the theme from the .thmx file by using the “Browse for themes” option on the Page Layout tab.

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

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

30. If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cells.

Answers:
a. True
b. False

31. 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 2010 which can be used to achieve this result with a single click. Please identify it.

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

32. Which among the following options represents Legend entries in the given picture?

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

33. Which of the following protects a document from changes in Microsoft Word 2010?

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

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

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

35. When using the booklet-printing feature, the term “gutter” refers to the space between page content and the fold in the middle of the paper where you would normally bind pages together.

Answers:
a. True
b. False

36. While working on a project report, Anna inserts various citations in the MLA style by using the Insert Citation option on the References tab. On completing the report, she realizes that she was required to use the Chicago style. To correct this, Anna should:

Answers:
a. change all the citations individually to the desired style.
b. remove all the citations and then enter them afresh in the new style.
c. Select Chicago from the Style dropdown list on the References tab.

37. In Microsoft Word 2010, “Keep lines together” paragraph formatting:

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

38. On creating her two page resume, Emma finds the paragraph heading for her “Professional Achievements” paragraph is showing at the bottom of the first page, while the details are on the next page. To keep the paragraph heading as well as the paragraph text on the same page, and assuming there are no empty paragraph markers in the document and the widow/orphan option is turned on, Emma should click in the paragraph heading and select which option from the Paragraph group:

Answers:
a. Keep lines together
b. Keep with next
c. Widow/orphan

39. If your table of contents is not hyperlinking when you click on the page number, what do you need to do?

Answers:
a. Regenerate the table of contents.
b. Add \H to the table of contents field.
c. Add \L to the table of contents field.
d. Press Ctrl H.

40. Choose the INCORRECT statement:

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

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

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

42. You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

Answers:
a. Fill color, More Fill Colors
b. Background Color
c. Texture
d. Pattern

43. If you want to create a citation and fill in the source information later, you should:

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

44. Josh is to create a technical write-up comprising short paragraphs with double line spacing. Each paragraph is to be separated from the other by a single line space. He writes a paragraph, selects the text, points to Line Spacing on the paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The moment he clicks enter to start a new paragraph, it automatically gets double spaced. How can Josh achieve paragraphs separated by single line spaces from each other within the document?

Answers:
a. He sets the Line Spacing on the formatting toolbar to 1.0.
b. He selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to zero.
c. He uses the Shift and Enter keys at the same time to create a new paragraph.
d. He selects the double-spaced paragraphs and clicks on Paragraph. Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to Auto.

45. Which of the following is NOT an option when inserting a Cross-reference?

Answers:
a. Numbered item
b. SmartArt
c. Heading
d. Equation
e. Table
46. How many items can be maintained on the clipboard at one time?

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

47. You are editing a shape. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

Answers:
a. Fill color, More Fill Colors
b. Background Color
c. Texture
d. Pattern

48. While editing a Word document on his computer, Pete looked aside to pick up his ringing mobile phone. In the process, he mistakenly pressed a key on the Word 2010 Ribbon area and the document’s appearance changed from as in Image A to as in Image B. Which of the following options could be the cause?

Answers:
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns were added to the document.
c. Gridlines were enabled from the View Tab.
d. A preset Watermark was inserted.
49. 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:

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

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

Answers:

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

Answers:

By using Format Painter.
By altering the Line Color.
By using the Recolor option under Format Picture.
This can’t be achieved in Microsoft Word 2010.

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

Answers:

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

4. Using the Draw Table option, it is possible to split an existing table cell into two separate and distinct cells:

Answers:

horizontally
vertically
diagonally

5. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

Answers:

Lock the field.
Protect the field.
Make the field hidden.
Turn field shading off.

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

Answers:

Alt
Ctrl
Shift

7. Below are two statements regarding Breaks in Microsoft Word 2010.

Which of the following options is correct?

Answers:

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

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

Answers:

Picture Effects
Insert Shapes
Picture Layout
Crop to Shape

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

Answers:

Insert Clip Art
Insert Flowchart
Insert SmartArt
Insert Quick Parts
Insert Drawing Canvas

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

Answers:

Insert, Screenshot
Insert, Screen Clipping
Print Screen
Insert, Image

11. Which of the following is NOT a type of Section Break?

Answers:

Next Page
Linked
EvenPage
Continuous

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

Answers:

True
False

13. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:

Answers:

References” > “Style”.
References” >”Insert Citation” >”Add New Source.
References” >”Insert Citation” >”Add New Placeholder.
None of the above

14. What is the function of Widow/Orphan control in Microsoft Word 2010?

Answers:

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

15. Microsoft Word 2010 enables you to wrap text easily around pictures, shapes and tables with any position or style that you want. When should a “Text wrapping break” be used?

Answers:

While applying a wrapping style to an image.
While applying a wrapping style to a table.
When you want to separate text around objects on web pages.
When you want to see the hidden formatting marks used in the page.

16. Microsoft Word 2010 has enabled ligatures for which of the following fonts?

Answers:

Open Type fonts
True Type fonts

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

Answers:

Formatting marks
Keep track of formatting
Linked styles

18. Consider the following scenario:

A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:

Answers:

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

Answers:

Margins were activated on the document.
Tables with maximum number of rows and columns was added to the document.
Gridlines were enabled from the View Tab.
A preset Watermark was inserted.

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

Answers:

True
False

21. Which among the following chart types do not have axes?

Answers:

Bar charts
XY (Scatter) charts
Doughnut charts
Area charts

22. Martha is preparing a trigonometry worksheet for her students. She wants to include the following example in the sheet. Which is the quickest way to achieve this?

Answers:

Click Formula on the Insert tab.
Click Symbol on the Insert tab.
Click WordArt on the Insert tab.
Click Equation on the Insert tab.

23. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?

Answers:

Through
Square
In Front of Text
In Line with Text

24. If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?

Answers:

Even Page
Odd Page
Continuous

25. What view must be used when inserting a subdocument?

Answers:

Print Layout
Web Layout
Outline
Full Screen Reading

Answers:

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 an excel sheet.
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.
Change chart type to a line chart and type all the values into an Excel file.
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.

27. With which chart type(s) is the “Depth Gridlines” option available?

Answers:

Bubble chart
Line chart
True 3D chart
All of the above

Answers:

By pasting all the text of the report in the PowerPoint file which opens on double clicking the .thmx file and then saving it as a Word document.
By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.
Dave’s Boss is wrong. No such arrangement is possible in Microsoft Word 2010.
By opening the Word file containing the report, and importing the theme from the .thmx file by using the “Browse for themes” option on the Page Layout tab.

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

Answers:

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.
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.
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.
All of the above
None of the above

Answers:

True
False

Answers:

Breaks
Indentation
Orientation
Hyphenation

32. Which among the following options represents Legend entries in the given picture?

Answers:

A
B
C
None of the above

33. Which of the following protects a document from changes in Microsoft Word 2010?

Answers:

Restrict Editing
Encrypt with Password
Add a Digital Signature
Mark as Final
All of the above

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

Answers:

The whole paragraph will get indented to the left.
The first line will get indented to the left.
All but the first line will get indented to the left.<

35. When using the booklet-printing feature, the term “gutter” refers to the space between page content and the fold in the middle of the paper where you would normally bind pages together.

Answers:

True
False

Answers:

change all the citations individually to the desired style.
remove all the citations and then enter them afresh in the new style.
Select Chicago from the Style dropdown list on the References tab.

37. In Microsoft Word 2010, “Keep lines together” paragraph formatting:

Answers:

works well for paragraphs within a table if “Allow row to break across pages” is also selected.
automatically enables the text rows to break across pages.
does not work for paragraphs within a table if “Allow row to break across pages” is also selected.
always works for paragraphs within a table.

Answers:

Keep lines together
Keep with next
Widow/orphan

39. If your table of contents is not hyperlinking when you click on the page number, what do you need to do?

Answers:

Regenerate the table of contents.
Add H to the table of contents field.
Add L to the table of contents field.
Press Ctrl H.

40. Choose the INCORRECT statement:

Answers:

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

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

Answers:

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

42. You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

Answers:

Fill color, More Fill Colors
Background Color
Texture
Pattern

43. If you want to create a citation and fill in the source information later, you should:

Answers:

insert a caption.
add a placeholder.
add a new source.
insert a cross-reference.

Answers:

He sets the Line Spacing on the formatting toolbar to 1.0.
He selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to zero.
He uses the Shift and Enter keys at the same time to create a new paragraph.
He selects the double-spaced paragraphs and clicks on Paragraph. Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to Auto.

45. Which of the following is NOT an option when inserting a Cross-reference?

Answers:

Numbered item
SmartArt
Heading
Equation
Table

46. How many items can be maintained on the clipboard at one time?

Answers:

One
Up to 24
Unlimited
Up to 100

47. You are editing a shape. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

Answers:

Fill color, More Fill Colors
Background Color
Texture
Pattern

Answers:

Margins were activated on the document.
Tables with maximum number of rows and columns were added to the document.
Gridlines were enabled from the View Tab.
A preset Watermark was inserted.

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

Answers:

Corrections
Change Picture
Compress Picture
Picture Layout

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

Question:

What view must be used when inserting a sub-document?

a. Print Layout

b. Web Layout

c. Outline

d. Full screen reading

Answer: c: outline

Question:

Dave receives a file named theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

a. By pasting all the text of the report in the PowerPoint file which opens on double clicking the .thmx file and then saving it as a word document.

b. By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.

c. Dave's boss is wrong. No such arrangement is possible in Microsoft word 2010.

d. By opening the word file containing the report, and importing the theme from the .thmx file by using "Brows for themes" option on the page layout tab.

Answer: b. By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.

Question:

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

a. Formatting marks

b. Keep track of formatting

c. Linked styles

Answer: b. Keep track of formatting

Question:

Below are two statements regarding breaks in Microsoft word 2010?

Statement X: text wrapping page break separates text around objects on web pages, such as caption text from body text.

Statement Y: continuous section break inserts a section break and starts the new section on the next page.

a. Statement X is correct. Statement Y is incorrect.

b. Statement X is incorrect. Statement Y is correct.

c. Both statements X and Y are correct.

d. Both statements X and Y are incorrect.

Answer: c: both statements X and Y are correct.

Question:

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

a. A

b. B

c. C

d. None of the above.

Answer: c

Question:

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.

Answer: b: Line chart

Question:

A table cell contains text. You place you 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.

Answer: c: remain intact in the first cell and the second cell will be empty.

Question:

While working on a project report, Anna inserts various citations in the MLA style by using the insert citation option on the references tab. On completing the report, she realizes that she was required to use the Chicago style. To correct this, Anna should:

a. Change all the citations individually to the desired style.

b. Remove all the citations and then enter them afresh in the new style.

c. Select Chicago from the style dropdown list on the references tab.

Answer: c: Select Chicago from the style dropdown list on the references tab.

Question:

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

a. True

b. False

Answer: a: True

Question:

Josh is creating a collage for his collage project. He has an image -Image A- while he wants to show in different color themes so as to represent different moods in the collage (Image 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.

Answer: c: by using the recolor option under format picture.

Question:

Which of the following is NOT a type of section break?

a. Next page

b. Linked

c. EvenPage

d. Continuous

Answer: b: linked

Question:

You need 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

Answer: c: compress picture

Question:

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

Answer: a: True

Question:

Applying a theme you document affects all content except tables.

a. True

b. False

Answer: a: True

Question:

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.

Answer: d. Always works for paragraphs within a table.

Question:

Why would you use content controls in a document?

a. To get information from another source and have it appears 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.

Answer: d: All of the above.

Question:

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

Answer: a: Picture effects

Question:

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

a. Alt

b. Ctrl

c. Shift

Answer: b: Ctrl

Question:

Josh is to create a technical write-up comprising short paragraphs with double line spacing. Each paragraph is to be separated from the other by a single line space. He writes a paragraph, selects the text, points to line spacing on the paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The moment he clicks enter to start a new paragraph, it automatically gets double spaced. How can Josh achieve paragraphs separated by single spaces from each other within the document?

a. He sets the line spacing on the formatting toolbar to 1.0

b. He selects the double-spaced paragraphs and clicks on paragraph. Then under indents and spacing, he sets the spacing "before" and "after" options to zero.

c. He uses the shift and enter keys the same time to create a new paragraph

d. He selects the double spaced paragraphs and clicks on paragraph. Then under indents and spacing, he sets the spacing "before" and "after" options to auto.

Answer: d: he selects the double spaced paragraphs and clicks on paragraph. Then under indents and spacing, he sets the spacing "before" and "after" options to auto.

Question:

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

Answer: a: True

Question:

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.

Answer: c: it is a 2D chart.

Question:

Martha is preparing a trigonometry worksheet for her students. She wants to include the following example in the sheet. Which is the quickest way to achieve this?

a. Click formula on the insert tab.

b. Click symbol on the insert tab.

c. Click WordArt on the insert tab.

d. Click Equation on the insert tab.

Answer: d: click Equation on the insert tab.

Question:

Roger was editing a word document, when his mobile phone rang. By mistake, some button got click 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 active on the document.

b. Tables with maximum number of rows and columns were added to the document.

c. Gridlines were enabled from the view tab.

d. A preset watermark was inserted.

Answer: d. A preset watermark was inserted.

Question:

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

a. Insert, screenshot

b. Insert, screen clipping

c. Print screen

d. Insert, image

Answer: a: insert, screenshot

Question:

Microsoft word 2010 has enabled ligatures for which of the following fonts?

a. Open type fonts

b. True type fonts

Answer: a: open type fonts

Question:

If you want to create a citation and fill in the source information later, you should:

a. Insert a caption.

b. Add a placeholder

c. Add a new source.

d. Insert a cross-reference.

Answer: a: insert a caption.

Question:

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.

Answer: b: References" > "insert citation">"add new source.

Question:

Anna selects a paragraph in a Microsoft word 2010 file. 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 in indented to the left.

c. All but the first line will get indented to the left.

Answer: c: all but the first line will get indented to the left.

Question:

Using the draw table option, it is possible to split an existing table cell into two separate and distinct cells:

a. Horizontally

b. Vertically

c. Diagonally

Answer: a: and b: horizontally and vertically

Question:

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.

Answer: a: only high-risk documents from an uncertain location are opened in Read-Only view.

Question:

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

a. One

b. Up to 24

c. Unlimited

d. Up to 100

Answer: b: Up to 24

Question:

If you were writing a book and wanted each to start on the right page, which section break would you use to begin each chapter?

a. Even page

b. Odd page

c. Continuous

Answer: b. Odd page

Question:

Microsoft word 2010 enables you to wrap text easily around pictures, shapes and tables with any position or style that you want. When should a "Text wrapping break" be used?

a. While applying a wrapping style to an image.

b. While applying a wrapping style to a table.

c. When you want to separate text around objects on web pages.

d. When you want to see the hidden formatting marks used in the pages.

Answer: c: when you want to separate text around objects on web pages.

Question:

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

a. Brooks

b. Indentation

c. Orientation

d. Hyphenation

Answer: a. Brooks

Question:

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.

Answer: c. There are hard page breaks in my table.

Question:

On creating her two page resume, Emma finds the paragraph heading for her "Professional Achievement" paragraph is showing at the bottom of the first page, while the details are on the next page. To keep the paragraph heading as well as the paragraph text on the same page, and assuming there are no empty paragraph makers in the document and window/orphan option is turned in, Emma should click in the paragraph heading and select which option from the paragraph group:

a. Keep lines together

b. Keep with next

c. Window/orphan

Answer: b: keep with next

Question:

What is the function of window/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.

Answer: a: it is a feature that prevents single lines of paragraphs from appearing on a separate page from the rest of the paragraph.

Question:

Which of the following is NOT an option when inserting a cross-reference?

a. Numbered item

b. SmartArt

c. Heading

d. Equation

e. Table

Answer: b: SmartArt

Question:

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

a. A pie chart could be used when 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.

Answer: b: A pie chart could be used when the data points in a pie chart are displayed as a percentage of the whole pie.

Question:

If your table of contents is not hyperlinking when you click on the page number, what do you need to do?

a. Regenerate the table of contents.

b. Add\H to the table of contents field.

c. Add\L to the table of contents field.

d. Press Ctrl H.

Answer: d: Press Ctrl H

Question:

Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft 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 company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separate in an Excel file. What should Linda do to achieve this in the shortest 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 an excel 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 sent it over.

c. Change chart type to a line a 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.

Answer: c: Change chart type to a line a chart and type all the values into an Excel file.

Question:

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.

Answer: c: Make the field hidden

Question:

You are editing a shape using the drawing tools. Which among the following shape fill options in the shape style group gives you control over the transparency for a shape?

a. Fill color, more fill colors

b. Backgroup color

c. Texture

d. Pattern

Answer: a: Fill color, more fill colors

Question:

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

Answer: b: Encrypt with password

Question:

You want to add an image as the first character in you paragraph. Which type of text wrapping treats you graphics as if it were a character?

a. Through

b. Square

c. In front of text

d. In line with text

Answer: d. In line with text

Question:

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

Answer: a. Insert clip art

Question:

Which among the following chart types do not have axes?

a. Bar charts

b. XY (scatter) charts

c. Doughnut charts

d. Area charts

Answer: c: Doughnut charts