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.Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift

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.

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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?

a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into 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.

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

a. Through
b. Square
c. In Font of Text
d. In Line with Text

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

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

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.
Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?

a. Open Type fonts
b. True Type fonts
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
Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?

a. PDF
b. TIFF
c. MDIQuestion:I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

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

Question:What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading

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

a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.
Question: Which of the following in NOT a type of Section Break?

a. Next Page
b. Linked
c. EvenPage
d. Continuous
Question: 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.

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

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 CanvasQuestion:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.

a. True
b. False
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

01. Q: If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.

02. Q: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl
03. Q: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answer: c. Make the field hidden.
04. Q: 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 Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.
05. Q: 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?
Answer: b. Square
06. Q: 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?
Answer: b. Tables with maximum number of rows and columns was added to the document.07. Q: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.

08. Q: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.
09. Q: With which chart type(s) is the "Depth Gridlines" option available?
Answer: b. Line chart
10. Q: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI
11. Q: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Answer: c. XLS
12. Q: What view must be used when inserting a subdocument?
Answer: b. Web Layout

13. Q: 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?
Answer: c. By using the Recolor option under Format Picture.14. Q: Which of the following in NOT a type of Section Break?
Answer: d. Continuous

15. Q: 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.
Answer: c. Orientation

16. Q: 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?
Answer: b. Insert Flowchart17. Q: 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.
Answer: b. False

18. Q: 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?
Answer: a. "Allow row to break across pages" is unchecked.19. Q: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Answer: a. Open Type fonts

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

Ans: a. insert a caption.21.Q:To select vertical blocks of text, you would hold down which key while dragging the mouse?Ans: b. Ctrl

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

Ans: c. Make the field hidden.

23.Q: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 Linda do to achieve this in the shortest possible time?

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

24.Q: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?

Ans: b. Square
25.Q: 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?

Ans: b. Tables with maximum number of rows and columns was added to the document.

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

Ans: c. it is a 2D chart.

27.Q:Choose the INCORRECT statement:
Ans: a. Only high-risk documents from an uncertain location are opened in Read-Only view.
28.Q:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

29.Q:With which chart type(s) is the "Depth Gridlines" option available?

Ans:b. Line chart

30.Q:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?

Ans:c. MDI

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

Ans:c. XLS

32.Q:What view must be used when inserting a subdocument?

Ans: b. Web Layout

33.Q: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?

Ans:c. By using the Recolor option under Format Picture.

.
34.Q: Which of the following in NOT a type of Section Break?

Ans: d. Continuous

35.Q: 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.

Ans: c. Orientation

36.Q: 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?

Ans: b. Insert Flowchart

37.Q: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.
Ans: b. False

38. Q: 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?
Ans: a. "Allow row to break across pages" is unchecked.

39.Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.

40.Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl
41.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?
c. Make the field hidden.

42.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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.
43.Question: You want to add an image as the first character in your paragraph. Which type nf text wrapping treats your graphic as if it were a character?
b. Square
44.Question: 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?

b. Tables with maximum number of rows and columns was added to

45.Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

46.Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
47.Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

48.Question: With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart

49.Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

51.Question: What view must be used when inserting a subdocument?
b. Web Layout
52.Question: 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?
c. By using the Recolor option under Format Picture.

53.Question: Which of the following in NOT a type of Section Break?
d. Continuous
54.Question: 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.
c. Orientation

55.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?
b. Insert Flowchart

56.Question: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.
b. False

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

58.Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.

58.Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl
59.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?
c. Make the field hidden.

60.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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.61.Question: 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?
b. Square

62.Question: 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?
b. Tables with maximum number of rows and columns was added to the document.

63.Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

64.Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

65.Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?

Ans: a

66.Question: With which chart type(s) is the "Depth Gridlines" option available?

Ans: b

67.Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?

Ans: c

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

Ans: c

69.Question: What view must be used when inserting a subdocument?

Ans: b
70.Question: 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?

Ans: c
71.Question: Which of the following in NOT a type of Section Break?

Ans: d
72.Question: 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.

Ans: c
73.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?

Ans: b
74.Question: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.

Ans: b
75.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?

Ans: a

Q1: figure shows a view of the Standard Toolbar. What function is performed by the button marked bythe letter 'Z'?

Ans:It copies the formatting properties from one cell to another

Q2:The figure shows the AutoFit Selection menu option. What function does it perform?

Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Q:How does the AutoComplete feature in Excel help you save time?

Ans:It automatically completes abbreviated words

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Ans:It is used to add a hyperlink

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans:Apply the Text Format to empty cells, and then type the numbers

Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans:A_B

Q:How can you select all the blank cells in your worksheet?

Ans:This must be done manually as it is not automated through any built-in feature

Q:What is the quickest way to select all the columns on a worksheet?

Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q:Which of the following functions would return a value of 8?

Ans:b and c

Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans:3 new rows will be inserted after row 9

Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?

Ans:It inserts a Diagram or Organization Chart in the worksheet

Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Ans:TRUE

Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

Ans:Select the cells, open the Window menu and click on Hide

Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans:DATEVALUE

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?

Ans:It adds up the values in the selected cells

Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Ans:#N/A

Q:Which of the following function you will use to find the highest number in a series of numbers?

Ans:MAX(B1:B3)

Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans:Date

Q:You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans:b

Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans:#N/A

Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans:TRUE

Q:What does the NOW() function returns?

Ans:Returns the serial number of the current date and time

Q:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans:Hold down the CTRL key during startup

Q:Which toolbar is shown in the figure?

Ans:Forms toolbar

Q:When you clear the contents from a cell, the formatting of the cell is also lost.

Ans:FALSE

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

Answer: Alt

#2 Question:
Why would you use content controls in a document?

Answer: All of the above

#3 Question:
Which of the following is NOT an option when inserting a Cross-reference?

Answer: b. SmartArt

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

Answer: b. add a placeholder.

#5 Question:
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?

Answer: a. Fill color, More Fill Colors

#6 Question:
Which of the following protects a document from changes in Microsoft Word 2010?

Answer: b. Encrypt with Password

#7 Question:
Microsoft Word 2010 has enabled ligatures for which of the following fonts?

Answer: Open Type fonts

8 Question:
With which chart type(s) is the "Depth Gridlines" option available?

Answer: b. Line chart

#9 Question:
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:

Answer: b. Keep with next

#10 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?

Answer: a. "Allow row to break across pages" is unchecked.

#11 Question:
Which among the following chart types do not have axes?

Answer: c. Doughnut charts

#12 Question:
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:

Answer: b. References" >"Insert Citation" >"Add New Source. http://blog.microcentertech.com/2011/06/how-to-insert-citation-into-microsoft.html

#13 Question:
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:

Answer: d. Picture Layout http://office.microsoft.com/en-us/powerpoint-help/reduce-the-file-size-of-a-picture-HA010355854.aspx

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

Answer: a. horizontally http://www.tutorialspoint.com/word_2010/word_split_table.htm

#15 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?

Answer: c. Make the field hidden.

#16 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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?

    a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into 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.

Answer: dont know

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

Answer: d. Press Ctrl H.

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

Answer: b. False

#19 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. C

#20 Question:
In Microsoft Word 2010, "Keep lines together" paragraph formatting:

Answer: c. does not work for paragraphs within a table if "Allow row to break across pages" is also selected.

#21 Question:
Applying a theme to your document affects all content except tables.

Answer: a. True

#22 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?

Answer: d. Click Equation on the Insert tab.

#23 Question:
What view must be used when inserting a subdocument?

Answer: c. Outline

#24 Question:
Which of the following is NOT a type of Section Break?

Answer: b. Linked

#25 Question:
What is the function of Widow/Orphan control in Microsoft Word 2010?

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

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

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

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

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

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

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

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

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

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

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

11. Microsoft Excel Services is a component of:

a. Microsoft SharePoint Technology
b. Microsoft Server Technology
c. Microsoft Virtualization Technology

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

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

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

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

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

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

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

a. 10 days
b. 20 days
c. 25 days
d. 30 days

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

36. What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?

a. .xlsx
b. .xslt
c. .xltx
d. .slk

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

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

39. Deleting a PivotChart report automatically deletes the associated PivotTable report.

a. True
b. False

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

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

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

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

44. To select vertical blocks of text, you would hold down which key while dragging the mouse?a. Alt
b. Ctrlc. Shift
Answer : b
45. 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
46. 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 Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into 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.

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

a. Through
b. Squarec. In Font of Text
d. In Line with Text

Answer: b
48. Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.

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

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

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

a. Open Type fontsb. True Type fonts

Ans: a
52. With which chart type(s) is the “Depth Gridlines” option available?

a. Bubble chart
b. Line chartc. True 3D chart
d. All of the above
Answer : b
53. Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDFb. TIFF
c. MDI
Answer : c
54. I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

a. BMP
b. PDF
c. XLSd. JPG

Answer : c
55. What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Answer : b
56. Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.d. This can’t be achieved in Microsoft Word 2010.
Answer : c
57. Which of the following in NOT a type of Section Break?

a. Next Page
b. Linked
c. EvenPage
d. Continuous
Answer : d
58. 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.
a. Breaks
b. Indentation
c. Orientationd. Hyphenation

Answer : c

59. 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 Flowchartc. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas

Answer: b
60. When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
a. True
b. False
Answer : b
61. 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: a

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

Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

Question: 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?
b. Tables with maximum number of rows and columns was added to the document.

Question:A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question:Choose the INCORRECT statement:
a.       Only high-risk documents from an uncertain location are opened in Read-Only view.

Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a.       Open Type fonts

Question:With which chart type(s) is the "Depth Gridlines" option available?
b.      Line chart

Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

Question:What view must be used when inserting a subdocument?
b. Web Layout

Question: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?
c. By using the Recolor option under Format Picture.

Question: Which of the following in NOT a type of Section Break?
d. Continuous

Q1: figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?

Ans:It copies the formatting properties from one cell to another

Q2:The figure shows the AutoFit Selection menu option. What function does it perform?

Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Q:How does the AutoComplete feature in Excel help you save time?

Ans:It automatically completes abbreviated words

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Ans:It is used to add a hyperlink

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans:Apply the Text Format to empty cells, and then type the numbers

Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans:A_B

Q:How can you select all the blank cells in your worksheet?

Ans:This must be done manually as it is not automated through any built-in feature

Q:What is the quickest way to select all the columns on a worksheet?

Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q:Which of the following functions would return a value of 8?

Ans:b and c

Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans:3 new rows will be inserted after row 9

Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?

Ans:It inserts a Diagram or Organization Chart in the worksheet

Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans:DATEVALUE

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?

Ans:It adds up the values in the selected cells

Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Ansna

Q:Which of the following function you will use to find the highest number in a series of numbers?

Ans:MAX(B1:B3)

Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans:Date

Q:You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans:b

Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans: na

Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans:true

Q:What does the NOW() function returns?

Ans:Returns the serial number of the current date and time

Q:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans:Hold down the CTRL key during startup

Q:Which toolbar is shown in the figure?

Ans:Forms toolbar

Q:When you clear the contents from a cell, the formatting of the cell is also lost.

Ans:FALSE

odesk Microsoft Excel 2010 Test answers.

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.

Ans: a

Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Ans: b

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.
Ans: c

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

a. Through
b. Square
c. In Font of Text
d. In Line with Text
Ans: b

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

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.
Ans: c

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.
Ans: a

Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
Ans: a

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

Ans: b

Question: Which of the following is NOT an option under File > Print > MicrosoftDocument Image Writer?
a. PDF
b. TIFF
c. MDI
Ans: c

Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG
Ans: c

Question: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Ans: b

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

Ans: c

Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous

Ans: d

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

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
Ans: b

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

a. True
b. False

Ans: b

Ans: a

Microsoft Excel 2010 Test Answer

Syllabus of the Test

Managing Worksheets

Microsoft Excel 2010 Advanced Features

Analyzing Data- PivotCharts and PivotTables

Web based Co-authoring and Streamlined Communications

Document Customizing-Working with Themes, Language, Images, Ribbon

Microsoft Excel 2010 Documents Security, Privacy and Recovery

01. Question: Question:If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.

02. Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl

03. 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?
Answer: c. Make the field hidden.

04. 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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.

05. Question: 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?
Answer: b. Square

06. Question: 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?
Answer: b. Tables with maximum number of rows and columns was added to the document.

07. Question: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.

08. Question: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.

09. Question: With which chart type(s) is the "Depth Gridlines" option available?
Answer: b. Line chart

10. Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI

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

12. Question: What view must be used when inserting a subdocument?
Answer: b. Web Layout

13. Question: 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?
Answer: c. By using the Recolor option under Format Picture.

14. Question: Which of the following in NOT a type of Section Break?
Answer: d. Continuous

15. Question: 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.
Answer: c. Orientation

16. 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?
Answer: b. Insert Flowchart

17. Question: 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.
Answer: b. False

18. 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?
Answer: a. "Allow row to break across pages" is unchecked.

19. Question: Microsoft Word 2010 has enabled ligatures for which of the following 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.

Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.

Question: You want to add an image as the first character in your paragraph. Which type nf text wrapping treats your graphic as if it were a character?
b. Square

Question: 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?

b. Tables with maximum number of rows and columns was added to

Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

Question: With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart

Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

Question: What view must be used when inserting a subdocument?
b. Web Layout

Question: 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?
c. By using the Recolor option under Format Picture.

Question: Which of the following in NOT a type of Section Break?
d. Continuous

Question: 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.
c. Orientation

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?
b. Insert Flowchart

Question: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.
b. False

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.

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

Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.

Question: 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?
b. Square

Question: 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?
b. Tables with maximum number of rows and columns was added to the document.

Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
Ans: a

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
Ans: b

Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Ans: c

Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG
Ans: c

Question: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Ans: b

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

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

Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
Ans: d

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

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

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
Ans: b

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

a. True
b. False
Ans: b

Q1:
figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?
Ans:It copies the formatting properties from one cell to another

Q2:The figure shows the AutoFit Selection menu option. What function does it perform?
Ans:It automatically re sizes the column height and width to the minimum necessary to fit the contents of the selected cell

Q:How does the AutoComplete feature in Excel help you save time?
Ans:It automatically completes abbreviated words

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?
Ans:It is used to add a hyperlink

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans:Apply the Text Format to empty cells, and then type the numbers

Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans:A_B

Q:How can you select all the blank cells in your worksheet?
Ans:This must be done manually as it is not automated through any built-in feature

Q:What is the quickest way to select all the columns on a worksheet?
Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q:Which of the following functions would return a value of 8?
Ans:b and c

Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans:3 new rows will be inserted after row 9

Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?
Ans:It inserts a Diagram or Organization Chart in the worksheet

Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans:TRUE

Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans:Select the cells, open the Window menu and click on Hide

Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans:DATEVALUE

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?
Ans:It adds up the values in the selected cells

Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans:#N/A

Q:Which of the following function you will use to find the highest number in a series of numbers?
Ans:MAX(B1:B3)

Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans:Date

Q:You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?
Ans:b

Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?
Ans:#N/A

Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Ans:TRUE

Q:What does the NOW() function returns?
Ans:Returns the serial number of the current date and time

Q:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Ans:Hold down the CTRL key during startup

Q:Which toolbar is shown in the figure?
Ans:Forms toolbar

Q:When you clear the contents from a cell, the formatting of the cell is also lost.
Ans:FALSE

01. Question: Question:If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.

02. Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl

03. 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?
Answer: c. Make the field hidden.

04. 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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.

05. Question: 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?
Answer: b. Square

06. Question: 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?
Answer: b. Tables with maximum number of rows and columns was added to the document.

07. Question: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.

08. Question: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.

09. Question: With which chart type(s) is the "Depth Gridlines" option available?
Answer: b. Line chart

10. Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI

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

12. Question: What view must be used when inserting a subdocument?
Answer: b. Web Layout

13. Question: 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?
Answer: c. By using the Recolor option under Format Picture.

14. Question: Which of the following in NOT a type of Section Break?
Answer: d. Continuous

15. Question: 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.
Answer: c. Orientation

16. 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?
Answer: b. Insert Flowchart

17. Question: 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.
Answer: b. False

18. 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?
Answer: a. "Allow row to break across pages" is unchecked.

19. Question: Microsoft Word 2010 has enabled ligatures for which of the following 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.

Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

Question: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?
b. Square

Question: 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?
b. Tables with maximum number of rows and columns was added to the document.

Question:A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question:Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

Question:With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart

Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

Question:What view must be used when inserting a subdocument?
b. Web Layout

Question: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?
c. By using the Recolor option under Format Picture.

Question: Which of the following in NOT a type of Section Break?
d. Continuous

Question: 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.
c. Orientation

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?
b. Insert Flowchart

Question: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.
b. False

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.

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

Question:
To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.

Question:
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?
b. Square

Question:
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?
b. Tables with maximum number of rows and columns was added to the document.

Question:
A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question:
Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

Question:
Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

Question:
With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart

Question:
Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

Question:
What view must be used when inserting a subdocument?
b. Web Layout

Question:
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?
c. By using the Recolor option under Format Picture.

Question:
Which of the following in NOT a type of Section Break?
d. Continuous

Question:
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.
c. Orientation

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?
b. Insert Flowchart

Question:
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.
b. False

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.

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

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

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?
Ans: c

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 the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Ans: c

Question:
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?
Ans: b

Question:
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?
Ans: b

Question:
A particular chart layout can be applied to a chart only if:
Ans: c

Question:
Choose the INCORRECT statement:
Ans: a

Question:
Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Ans: a

Question:
With which chart type(s) is the "Depth Gridlines" option available?
Ans: b

Question:
Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Ans: c

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

Question: What view must be used when inserting a subdocument?
Ans: b

Question:
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?
Ans: c

Question: Which of the following in NOT a type of Section Break?
Ans: d

Question:
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.
Ans: c

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?
Ans: b

Question:
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.
Ans: b

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?
Ans: a

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

a. insert a caption.

Question:
To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

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?
c. Make the field hidden.

Question:
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?
b. Tables with maximum number of rows and columns was added to the document.

Question:
A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

Question:
Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

Question:
Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts

Question:
With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart

Question:
Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

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

Question:
What view must be used when inserting a subdocument?
b. Web Layout

Question:
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?
b. Square

Question:
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?

c. By using the Recolor option under Format Picture.

Question:
Which of the following in NOT a type of Section Break?
d. Continuous

Question:
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.
c. Orientation

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?
b. Insert Flowchart

Question:
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.
b. False

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
Ans: a

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.

01. You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Ans: Hold down the CTRL key during startup

02. How does the AutoComplete feature in Excel help you save time?
Ans: It automatically completes abbreviated words

03. The figure shows a view of the Standard Toolbar. What function is performed by the buttonmarked by the letter 'Z'?
Ans: It copies the formatting properties from one cell to another

04. The figure shows the AutoFit Selection menu option. What function does it perform?
Ans: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

05. The figure shows a view of the Standard Toolbar. What function is performed by the buttonmarked by the letter 'A'?
Ans: It is used to add a hyperlink

06. Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans: Apply the Text Format to empty cells, and then type the numbers

07. What is the quickest way to select all the columns on a worksheet?
Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

08. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans: A_B

09. How can you select all the blank cells in your worksheet?
Ans: This must be done manually as it is not automated through any built-in feature

10. The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q#01

In the above given screenshot

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

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

Ques: figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Z’?

Ans: It copies the formatting properties from one cell to another

Ques: The figure shows the AutoFit Selection menu option. What function does it perform?

Ans: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Ques: How does the AutoComplete feature in Excel help you save time?

Ans: It automatically completes abbreviated words

Ques: The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘A’?

Ans: It is used to add a hyperlink

Ques: Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans: Apply the Text Format to empty cells, and then type the numbers

Ques: Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans: A_B

Ques: How can you select all the blank cells in your worksheet?

Ans:This must be done manually as it is not automated through any built-in feature
Ques:What is the quickest way to select all the columns on a worksheet?

Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Ques: The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Ques: Which of the following functions would return a value of 8?

Ans: b and c

Ques: You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans: 3 new rows will be inserted after row 9

Ques: The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter ‘X’ ?

Ans: It inserts a Diagram or Organization Chart in the worksheet

Ques: When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Ans: TRUE

Ques: You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

Ans: Select the cells, open the Window menu and click on Hide

Ques: Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans: DATEVALUE

Ques: The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Y’?

Ans: It adds up the values in the selected cells

Ques: Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Ans: #N/A

Ques: Which of the following function you will use to find the highest number in a series of numbers?

Ans: MAX(B1:B3)

Ques: You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans: Date

Ques: You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans: b

Ques: What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans: #N/A

Ques: AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans: TRUE

Ques: What does the NOW() function returns?

Ans: Returns the serial number of the current date and time

Ques: You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans: Hold down the CTRL key during startup

Ques: Which toolbar is shown in the figure?

Ans: Forms toolbar

Ques: When you clear the contents from a cell, the formatting of the cell is also lost.

Ans: FALSE
Question 101: Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
a. By selection
Ans: b. By corresponding field
Ans: c. By value field
d. By number field

Question 102: 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
Ans: b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas

Question 103: Which of the following is not a valid file extension in which an Excel file can be saved?
a. XLSB
b. XLSM
Ans: c. PXL
Ans: d. All of the above are valid

Question 104: Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
Ans: a.     A (No fill)
Ans b.     B
Ans: c.     C
d.     D

Question 105: Which of the following charts shows numerical values on the vertical (value) axis and textual groupings (or categories) on the horizontal axis?
Ans: c. Area charts

Question 106: When would you use smart graphic?
Ans:List information b. create a matrix illustration c. Show a relationship between parts, such as overlapping concepts

Question 107: Which tab is required to work with Macros?
Ans: b. Developer tab. e. View tab

Question 108: State whether true or false:
Case-sensitive sorting of text in Excel2007 can be performed.
Ans: a. True
b. False

Question 109: State whether true or false:
A Macro project can be digitally signed.
Ans: a. True
Ans: b. False

Question 110: Which of the following is true about a freeform shape?
Ans: d. All of the above is true

Question 111: Deleting the PivotChart report automatically deletes the associated PivotTable report.
Ans: b. False

Question 112: Which of the following is a default method of a PivotTable report for scoping the conditional format of a fields in the values area?
Ans: a. By selection.
Ans: b. By corresponding field.
c. By value field.
d. By number field.

Question 113: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
Ans: a. Automatically updated properties
b. Standard properties
c. Custom properties
d. Properties for the organization

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

Question 115: How will you reverse the direction of a SmartArt graphic?
Ans: -Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to

Question 116: Which of the following options would you choose to clear a PivotChart report?
a.     On the Analyze tab, in the Data group, click on Clear, and then click ‘Clear All’
b.     On the Options tab, in the Actions group, click on Clear, and then click??’Clear All’
c.     Both a and b
Ans: d.     None of the above

Question 117: For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
Ans: a. True
b. False

Question 118: 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?
Ans: 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

Question 119: How can a chart be modified?
a. By modifying a legend
b. By modifying the display of chart axes
Ans: c. By modifying titles and data labels
Ans: d. All of the above

Question 120: When would the data validation command be unavailable on the data tab?
a. When an Excel table is linked to a SharePoint site
b. When data in a cell is entered
Ans: c. When the workbook is shared or protected
Ans: d. All of the above

Question 121: Which option would you choose to display a list of formula used in the current PivotTable report?
a. On the Options tab, in the Tools group, click on Formula, and then click ‘Solve Order’”
b. On the Formula tab, in the Function library, click ‘Show Formula’
Ans: c. On the Options tab, in the Tools group, click on Formula, and then click ‘List Formula’
d. None of the above

Question 122: Which type of additional information is stored within the digital signature?
a. Date information
b. Time information
c. The Office version number of the program in which the file was created
Ans: d. All of the above

Question 123: For XY (scatter) and bubble charts, error bars for the x values, the y values , or both can be displayed.
Ans: a. true

Question 124: Which database function estimates variance based on a sample from selected database entries?
a. DSTDEV
b. DSUM
Ans: c. DVAR
d. DVARP

Question 125: Which of the following options is not available on the Status bar?
a. Cell mode
Ans: b. Selection mode
d. End mode
Ans e. Start mode
Question 26: Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?
a.         Scoping by selection
Ans: b.         Scoping by corresponding field
Ans: c.         Scoping by value field
d.         All of the above

Question 27: Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
Ans; a. Consolidate by position
b.         Consolidate by category
c.         Consolidate by formula
d.         None of the above

Question 28: Which method will you use to update table data from a Sharepoint list?
a.         On the Data tab, in the Data Tools group, click Refresh
b.         On the View tab, in the Show/Hide group, click Refresh
Ans: c. On the Design tab, in the External Data group, click Refresh
Ans: d. In the Design tab, On the External Data Tools group, Click Refresh
e.         None of the above

Question 29: To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Ans: False

Question 30: Which of the given methods would you follow to add an alternative text to a picture?
Ans: a.        Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
Ans: b.        Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
c.        Both a and b
d.        None of the above

Question 31: Which of the following is not true about an offline cube file?
a. It stores data in the form of an OLAP cube
Ans: b. The file format for an offline cube file is .CUE
c. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable

Question 32: Which among the following is not true regarding a calculated column?
a.         It uses a single formula that adjusts for each row
b.         It automatically expands to include additional rows
c.         A formula is required to be entered only once in a calculated column
Ans: d. Additional formulae cannot be entered in a calculated column as exceptions

Question 33: Which of the following is not true regarding column width?
a. If the column width is set to 0, the column is hidden
Ans: b. A column width between 0 to 255 can be specified
c. The default column width is 8.43 characters
Ans: d. All of the above are true

Question 34: Which of the following is not true regarding naming a cell?
Ans: a. Names are case sensitive
b. A name can contain up to 255 characters
c. Names can contain uppercase and lowercase letters
Ans: d. Some keyboard characters can cause unexpected results if used in cell names

Question 35: Which of the following methods would you follow to remove subtotals?
Ans: a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
b. On the Data tab, in the Data Tools, select Remove Subtotals
Ans: c. Both a and b
d. None of the above

Question 36: Deleting the PivotChart report automatically deletes the associated PivotTable report.
a. True
Ans: b. False

Question 37: If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
Ans: a. True.
Ans: b. False.

Question 38: Which of the following is not a tab on the Chart Options dialog box?
Ans: Patterns

Question 39: No data is deleted when an outline is hidden or removed.
Ans: a. True
Ans: b. False

Question 40: When a part of a formula is replaced with its calculated value, it cannot be restored.
Ans: a. True.
b. false.

Question 41: When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
Ans: a. True
b. False

Question 42: Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells
Ans: False

Question 43: When does the triangle appear in the top-left corner of the cell, as shown in the picture?
a.         When the cell contains hidden information
Ans: b.         When the cell contains the Time function
Ans: c.         When there is an error in the formula
d.         None of the above

Question 44: When does the error, as shown in the picture, occur?
a. It occurs when a column is not wide enough
b. It occurs when a negative date is used
Ans: c. It occurs when a negative time is used
Ans: d. All of the above

Question 45: Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
a.     A
Ans: b. B
c.        C
d.         D

Question 46: Certain chart elements automatically inserted in a chart created by Chart Wizard include a chart legend, labels for the x-axis and y-axis, and a chart title
Ans: False

Question 47: Refer to the given image. Which formula should be written on the given table to display “Nancy Davolio”?
a.         =UPPER(A2)
b.         =LOWER(A2)
Ans: c.         =PROPER(A2)
d.         None of the above

Question 48: What would be the result, when =T(A4) is applied on the given table?
Ans: a. The text True is returned
b.         The text Rainfall is returned
c.         Empty text is returned
d.         None of the above

Question 49: You can double-click a chart element to display the appropriate formatting dialog box.
Ans: True

Question 50: Refer to the given image. What will be the result if the formula =B3&”, “&A3 is applied on the given table?
a.     It will display Nancy Davolio
Ans: b.     It will display Fuller Andrew
c.     It will display Fuller, Andrew
Ans; d.     Both b and c

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

oDesk Microsoft Excel 2010 Skill Test Answers

a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
Answer: a
Qu: To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Answer : b
Qu: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

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

Answer : c
Qu: 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 Linda do to achieve this in the shortest possible time?

a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into 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.

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

a. Through
b. Square
c. In Font of Text
d. In Line with Text

Answer: b
Qu: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.

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

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

Answer : c
Qu: Choose the INCORRECT statement:

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

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

a. Open Type fonts
b. True Type fonts

Ans: a
Qu: With which chart type(s) is the “Depth Gridlines” option available?

a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above
Answer : b
Qu: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Answer : c
Qu: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

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

Answer : c
Qu: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Answer : b
Qu: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can’t be achieved in Microsoft Word 2010.
Answer : c
Qu: Which of the following in NOT a type of Section Break?

a. Next Page
b. Linked
c. EvenPage
d. Continuous
Answer : d
Qu: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation

Answer : c
Qu: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas

Answer: b
Qu:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
a. True
b. False
Answer : b
Qu: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?

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

Which of the following conditions should be satisfied to create a one-to-one relationship between tables?

a. The primary key and foreign key fields must have a unique index.

b. The indexed property for the primary key and the foreign key fields should be set to Yes.

c. The common fields must have a unique index.

d. All of the above

Which of the following Aggregates expressions is not allowed in Query Columns context of a Web database?

a. Avg

b. Count

c. Sum

d. VarP

e. Like

What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?

a. Close

b. Delete

c. Move up

d. Move Down

Which of the following statements is not true about the Work Offline option in an Access database linked to SharePoint?

a. Working offline allows you to work on SharePoint data locally.

b. Within Microsoft Access, data is visible to only those users who have permission to view it on SharePoint.

c. Discard All My Changes option lets you reject all changes made while offline.

d. Changes made in Access are synchronized with SharePoint when you reconnect.

Microsoft Access 2010 does not support more than _________ fields in a table.

a. 55

b. 155

c. 200

d. 255

Which of the following is true of the Ribbon interface?

a. Ribbons can be dragged and dropped to be on the side or the bottom of the screen.

b. Ribbons can be minimized or collapsed.

c. Ribbons can be replaced with command bars.

d. New ribbons can be created using the Office Ribbon Generator.

What is the purpose of Option Explicit?

a. It is a database object.

b. Requires variable declarations.

c. It contains all of the data access pages that are currently open in a Microsoft Access project.

d. It contains all open standard modules and class modules in a Microsoft Access database.

Which of the following are reserved for use by SharePoint and is not supported on the Web?

a. Solutions

b. Docs

c. Lists

d. UserInfo

e. Reports

Which one of the following correctly selects rows from the students table that have null in column1?

a. Select * from students where column1 is null

b. Select * from students where column1 = null

c. Select * from students where column1 EQUALS null

d. Select * from students where column1 NOT null

e. Select * from students where column1 CONTAINS null

What will be the result of the following?
InStr(1, “John Smith”, “S”)

a. 5

b. 6

c. 7

d. 4

Which of the following data-definition queries creates a table named Cars, with the following fields

a. CREATE Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)

b. CREATE TABLE Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)

c. CREATE TABLE Cars (Name(40), Year(4), Price)

d. CREATE Cars (Name(40), Year(4), Price)

Which of the following is true about a.accde file in Microsoft Access 2010?

a. It contains compiled VBA code to prevent users from viewing the code.

b. It can be saved as a.accdb file in order to make design changes.

c. It allows users to import forms and reports from other databases.

d. It allows users to view, but not modify VBA code.

How can you tell if a report has no records to display or print in Microsoft Access 2010?

a. By using the report’s Error event.

b. By using the report’s ApplyFilter event.

c. By using the report’s NoData event.

d. By using the report’s Filter event.

Which of the following is correct regarding Crosstab queries?

a. Multiple Value fields can be specified.

b. Multiple Column headings can be specified.

c. Multiple Row headings can be specified.

d. An unlimited number of columns can be returned.

What will happen when we select the option “Check for truncated number fields” (marked as A in the image) under Current Database settings?

a. The values visible in a column are truncated based on what can fit in the column.

b. Access displays numbers as “#####” when a column is too narrow to display the entire value.

c. Access displays numbers as “*****” when a column is too narrow to display the entire value.

d. Access expands the column if it is too narrow to display the entire value.

Which of the following is NOT possible when you link to an Excel worksheet from within Access?

a. You can append data to an existing table.

b. You can create a database containing multiple linked tables.

c. You can edit the Excel spreadsheet by making changes in to the linked table.

d. By creating a linked table any changes that are made to the data in Excel are automatically reflected in the linked table.

How do you start a Microsoft Access application so that the user can’t see or use the Navigation Pane (or database container)?

a. Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys.

b. Set the Access Option to hide the navigation pane, and press ALT+F1 special keys.

c. Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11.

d. Set the Access Option to hide the navigation pane, and press CTRL+G special keys.

What is the purpose of the option marked as A (see image), under General options for working with Access?

a. It allows users to preview how a formatting option will appear.

b. It indicates that the text will be displayed in a format that is easier to read.

c. It enables ScreenTips and Enhanced ScreenTips.

d. Both b and c.

In a report with grouping, how can you display the count of records in each group?

a. Add a text box to the group’s footer section and set its control source to =Count(*).

b. Set the report’s Group Count property to True.

c. Add a label to the group’s header section and set the Caption property to Count Rows.

d. Add a Summary control to the report’s footer section.

Using the Package and Sign tool, how many databases can you add to a package that you want to distribute to other users in Microsoft Access?

a. Unlimited

b. 5

c. 1

d. 10

Using which of the following Microsoft Access 2010 database file formats, can we use the Package and Sign tool?

a. .accdb

b. .accdc

c. .accde

d. .mdb

Which text box property in Microsoft Access 2010 Reports allows the text box to be expanded so that all the text can be fit into it?

a. CanGrow

b. Reading Order

c. Display When

d. None of the above

How do you create a report for a Crosstab Query if certain column values are missing?

a. Set the Value field in the Crosstab.

b. Set the Column Heading field in the Crosstab.

c. Set the Pivot list in the Crosstab.

d. Set the report’s Crosstab property to True

See the image above. How would you filter the table so that it returns names of only those students whose last name begins with A, O or Y?

a. Select lastname from students where lastname like ‘[A,O, Y]*’

b. Select lastname from students where lastname like ‘*[A, O, Y]‘

c. Select lastname from students where lastname not like ‘*[A, O, Y]‘

d. Select lastname from students where lastname not like ‘[A,O, Y]*’

e. Select lastname from students where lastname=’A’ or lastname=’O’or lastname=’Y’

When you run the Compatibility Checker in Microsoft Access 2010, in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?

a. Name of an order by element is not valid.

b. Name of source table is not valid.

c. Sort order is set to an option other than ascending or descending.

d. The expression is not valid.

e. All of the above

Which of the following elements are mandatory for the CREATE INDEX command?

a. The name of the index.

b. The ON argument.

c. The list of fields to be included in the index.

d. The name of the table that contains the fields that you want to index.

e. All of the above.

Which of the following Microsoft Access 2010 components can pose security risks in an untrusted database?

a. Action queries (queries that insert, delete, or change data)

b. Macros

c. Forms

d. VBA code

Which of the following is incorrect about the Quick Access Toolbar?

a. You can move the Quick Access Toolbar from its default location.

b. Toolbar can be minimized or collapsed.

c. You cannot display the Quick Access Toolbar on multiple lines.

d. You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.

Which feature in Microsoft Access 2010 can be used to ensure consistency in appearance between forms and reports?

a. Web 2.0-like Controls

b. Web Browser Controls

c. Office Themes

d. Backstage View

What can you do in Report View that you cannot do in Print Preview in Microsoft Access 2010 Reports?

a. You can Filter, Copy, Search, etc.

b. You can make most, but not all, changes to your report.

c. You can display the structure of your report.

d. Resize report sections, such as Headers, Detail, and Footers

Microsoft Access uses indexes in a table to find data. Which of the following field types cannot be indexed?

a. OLE Object

b. Attachment

c. Memo

d. Calculated

Password protected databases offer:

a. Only one password with full rights.

b. Different user rights for different logins/passwords.

c. Integrated security with Active Directory.

d. Integrated security with Windows Logins.

What could be the problem when an error message “#Error” is received in a query?

a. The query is joining fields that have different data types.

b. A field’s alias conflicts with a component of the expression for that field.

c. The object or the database is damaged.

d. The denominator of a calculated field is zero.

Which of the following describes the Data Execution Prevention (DEP) support for Office applications?

a. It is a software component that helps reduce the attack surface by identifying files that do not follow a valid file format definition.

b. It is a feature that helps mitigate attacks by enabling users to preview untrusted or potentially harmful files in a sandbox environment.

c. It is a hardware and software technology that helps harden the attack surface by preventing viruses and worms that exploit buffer overflow vulnerabilities from running.

d. All of the above

Which of the following is not true regarding Information Rights Management (IRM) for e-mail messages in Microsoft Access 2010?

a. It prevents restricted e-mail content from being copied by using the Print Screen feature in Microsoft Windows.

b. It restricts the e-mail content from being copied by using third-party screen-capture programs.

c. It prevents an unauthorized recipient from accessing e-mail content, including attachments.

d. It restricts content wherever the e-mail is sent.

Which of the following is not done when you compact a database?

a. Table records and objects are restructured and then stored in successive memory blocks.

b. Databases linked to the compacted database are compacted and repaired.

c. Table records are restored into their primary key order, if a primary key exists in the table.

d. The physical size of the database is reduced by making an exact duplicate of the database.

Which of the following is the correct way to enter the beginning or ending characters of the fields named (UnitPrice and CompanyName) in the AutoIndex onImport/Create field to create an Auto Index ?

a. unit.name

b. unit;name

c. unit,name

d. ‘unit’,’name’

What is the advantage of a Class Module versus a Standard Module?

a. Encapsulation, Inheritance

b. Data Abstraction

c. Polymorphism

d. Reusability

What is the purpose of time stamping a digital signature in Microsoft 2010?

a. It helps 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. It is a security tool that enables users to designate safe documents.

Suppose you want to use data from two tables in a query: tblCustomer and tblOrder. The two tables both have a field, CustomerID, that identifies a customer. Each record in the tblCustomer table may have one or more corresponding records in the tblOrder table, and the corresponding values can be determined by values in the CustomerID field. You now want to join the tables so that the query combines the records from the tables, excluding records from either table if there is no corresponding record in the other table. Which of the following FROM clauses will you use?

a. FROM [tblCustomer] LEFT JOIN [tblOrder] ON

[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]

b. FROM [tblCustomer] RIGHT JOIN [tblOrder] ON

[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]

c. FROM [tblCustomer] INNER JOIN [tblOrder] ON

[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]

d. FROM [tblCustomer], [tblOrder]

What is the purpose of the Application Parts option in Microsoft Access 2010?

a. It enables you to reduce coding errors and easily incorporate more complex logic to create robust applications.

b. It integrates your Access reports using multiple data connections and information linked or imported from other sources.

c. It integrates your Access data with live web content.

d. It turns portions of your database into reusable templates.

If you want to encrypt a database by using a password, then the database must be opened in ________ mode.

a. Open Exclusive

b. Open Exclusive Read-Only

c. Open Read-Only

d. Open Password-Enabled

Layouts are guides to align controls that you add to your forms or reports. Which layout has been depicted in the image above?

a. Print Preview

b. Tabular format

c. Stacked format

d. Grid format

Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields, with a space between them.Which of the following expressions will you enter in the Expression Builder?

a. [firstName] +” “+[lastName]

b. [firstName] +” #”+[lastName]

c. [firstName] &” “& [lastName]

d. [firstName] &”,”& [lastName]

Which of the following functions determines if a phrase exists in a longer string?

a. InStr

b. Len

c. Trim

d. Left

What is the function of the ‘Single Step’ in Macros as shown in the image?

a. This command is saves expressions one at a time.

b. This command executes an action one at a time.

c. This command saves all queries in a single step.

d. This command saves all reports in a single step.

What happens when a user has a database open in Exclusive mode and another user attempts to open it?

a. The second user can open the database and make changes to objects and data.

b. The second user receives a ‘File already in use’ message.

c. The second user receives a ‘File is deleted’ message.

d. The second user can open the database and make changes to data, but not to objects.

Which form property determines whether the current record has been modified since it was last saved?

a. Cycle property

b. Dirty property

c. Filter property

d. FilterOn property

Which textbox property in Microsoft Access 2010 determines that the text box is bound, unbound or calculated?

a. RecordSource

b. ControlSource

c. CanGrow

d. RowSource

Which of the following is not a Relationship and Lookup error?

a. Lookups require an associated Relationship to be compatible with the Web.

b. Limit to List must be set to True if Allow Multiple Values is set to True.

c. Enable Referential Integrity must be False if Allow Multiple Values is set to True for a lookup.

d. A table with more than 220 fields is incompatible with the Web.

Consider the following tables:
Books
———
BookId
BookName
AuthorId
SubjectId
PopularityRating (the Popularity of the book on a scale of 1 to 10)
Language(such as French, English, German etc)

What is the query to determine which German books (if any) are more popular than all the French books?

a. Select bookname from books where language=’German’ and popularityrating =(Select popularityrating from books where language=’French’)

b. Select bookname from books where language=’German’ and popularityrating > (Select popularityrating from books where language=’French’)

c. Select bookname from books where language=’French’ and popularityrating > (Select max(popularityrating) from books where language=’German’)

d. Select bookname from books where language=’German’ and popularityrating > (Select max(popularityrating) from books where language=’French’)

Which of the following rules apply when you use referential integrity?

a. You cannot delete a record from the primary table if matching records exist in the related table.

b. You cannot enter a value in the foreign key field of the related table that does not exist in the primary key of the primary table.

c. You can change the primary key value in the primary table, if that record has related records in the related tables.

d. All of the above

Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?

a. Indexed

b. Validation Rule

c. Input Mask

d. Default Value

For what reason(s) can a digital signature or certificate be regarded as invalid?

a. The publisher is not a trusted publisher.

b. The digital signature has expired.

c. The certificate was not issued by a certified authority.

d. All of the above.

How can you share common objects between multiple projects in Microsoft Access 2010?

a. By customizing tabs.

b. By creating Data Macros.

c. By using a Web Browser Control.

d. By creating Application Parts.

A query that uses the BETWEEN operator for two numbers is identical to:

a. >= and <=

b. > and <

c. >= and <

d. > and <=

Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in the descending order of the CurrentStock column.

a. Select * from Products order by CurrentStock, ProductGroup.

b. Select * from Products order by CurrentStock DESC, ProductGroup.

c. Select * from Products order by ProductGroup, CurrentStock.

d. Select * from Products order by ProductGroup, CurrentStock DESC.

e. None of the above.

A company has the following departments:
Marketing, Designing, Production, Packing

What will be the result of the following query?

Select department from table where department < ‘Marketing’

a. The query will return “Designing, Packing”

b. The query will return “Designing, Production”

c. The query will return “Production, Packing”

d. The query will return “Designing”

An Excel workbook saved in HTML format allows Internet or intranet users to have access to workbook data even if they do not have Excel installed

Ans: True

Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells
Ans: False

Certain chart elements automatically inserted in a chart created by Chart Wizard include a chart legend, labels for the x-axis and y-axis, and a chart title
Ans: False

You can double-click a chart element to display the appropriate formatting dialog box.
Ans: True

Time in a cell in Excel is stored as a decimal fraction representing a portion of the day
Ans:True

The PMT function is used to calculate a loan payment based on a variable interest rate, payment, and the time period.
Ans: False

The gridlines that appear on your worksheet will print as displayed.
Ans: False

The FV function is used to calculate the future value of an investment based on a periodic constant payment and interest rate
Ans: True

If the text you entered into a cell does not fit, Excel will display ##### to indicate that the text is too long
Ans: True

By default, data in a cell is centered
Ans: False

When a new row is added into an Excel worksheet, by default, this row will be inserted just below the active cell.
Ans: True

To insert a row, click Insert and then Rows
Ans: True

The Split option causes the worksheet to be split into two window panes.
Ans: False

To select nonadjacent cells, columns, or rows, you must
Ans: hold down the Ctrl key while clicking column, row header, or specific cells

When copying selected cells to a new location, you must position the mouse pointer on any border around the selected cells until it turns into a(n)
Ans: arrow pointer

When data is linked, a change made in a linked cell is automatically made to other cells in the link.
Ans: True

Selected cells and cell contents can be moved or copied within a worksheet but not between worksheets.
Ans: False

What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Ans: It allows you to scroll through two or more workbooks simultaneously

Which of the following functions would return a value of 8?
Ans: round(8.4999,0)

What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?
Ans: 0

Which of the following date and time function will you use to return the serial number of the last day of the month before or after specified number of months?
Ans: EOMONTH

Which of the following shortcuts can be used to insert a new line in the same cell?
Ans: Alt+Enter

Which of the following function you will use to find the highest number in a series of numbers?
Ans: MAX(B1:B3)

Which of the following statements regarding the QUARTILE function is not true?
Ans: The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.

You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans: Date

This question is based upon the figure shown below
What will be the value in the cell C2 as shown in the figure when we use formula = A2+B2?
Ans: 120

What is the quickest way to select all the columns on a worksheet?
Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

What does the NOW() function returns?
Ans: Returns the serial number of the current date and time

You would like to restrict the values that can be entered into a cell so that only whole numbers between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?
Ans: The setting tab under the menu Data->Validation

You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Ans: Hold down the CTRL key during startup

How does the AutoComplete feature in Excel help you save time?
Ans: It automatically completes abbreviated words

The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Z?
Ans: It copies the formatting properties from one cell to another

How can you select all the blank cells in your worksheet?
Ans: This must be done manually as it is not automated through any built-in feature

The figure shows an Excel worksheet. If you want to F the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter X ?
Ans: It inserts a Diagram or Organization Chart in the worksheet

When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans: TRUE

What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?
Ans: #N/A

AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Ans: TRUE

Which toolbar is shown in the figure?
Ans: Forms toolbar

When you clear the contents from a cell, the formatting of the cell is also lost.
Ans: FALSE

When the AutoSum button is clicked, Excel first looks for a range of numbers above the active cell.
Ans: True

A relative cell reference changes when a formula is copied or moved to other locations.
Ans: True

If cell entries are changed, the formula will automatically recalculate the values and insert the result in the cell containing the formula.
Ans: True

The Merge button on the Formatting toolbar will merge selected cells and right align data within the cells.
Ans: False

To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Ans: False

Which of the following is not a tab on the Chart Options dialog box?
Ans: Patterns

This chart is the default chart
Ans: Column Chart

Which of the following displays the contents of the active cell?
Ans: Formula bar

A worksheet is an individual page or tab in the workbook.
Ans: True

You can copy cell formats from one cell to another by using the
Ans: Format Painter

Donelp you do this?
Ans: Select the cells, open the Window menu and click on Hide

The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y
Ans: It adds up the values in the selected cells

You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Print What->Selection. What will happen?
Ans: The selected area will be printed

By default, how is text horizontally aligned inside a cell in Excel?
Ans: Left aligned

When using the AutoFill handle to quickly fill a range of cells with the same or consecutive data, the cells need not be adjacent as long as they are within the same sheet.
Ans: False

This question is based upon the figure shown bellow
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
Ans: There is a comment associated with the cell

You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans: 3 new rows will be inserted after row 9

A smart tag will be removed from a cell when……………….
Ans: The data in the cell is changed or deleted

The figure shows the AutoFit Selection menu option. What function does it perform?
Ans: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide

Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans: DATEVALUE

You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?
Ans: b

figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Z’?
Ans: It copies the formatting properties from one cell to another

The multiplication arithmetic operator is represented by which of the following symbols
Ans: *

To apply page numbering to a worksheet page, which option in the Page Setup dialog box should you choose
Ans: Header/Footer

If a function is included in an argument within a function, it is called a
Ans: Nested Function

If you want row and column headings to print, which tab do you click from the Page Setup dialog box?
Ans: Header/Footer

A new workbook initially contains this many sheets
Ans: Three

You can change the size of an image by using the white sizing handles.
Ans: True

The question is based upon the figure shown
The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells

You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu

Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: #N/A

Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get John_Smith in Cell C1?
Ans: = A1&”_”&B1

The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter A
Ans: It is used to add a hyperlink

Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans: Apply the Text Format to empty cells, and then type the numbers

Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans: A_B

You can select the current row by pressing
Ans: Shift + Spacebar

A column is inserted immediately to the left of the column containing the active cell unless you choose otherwise
Ans: True

To delete a specific cell as well as the text within it, make the cell active and then
Ans: click Edit and then Delete

Which of the following is an absolute cell reference
Ans: $B3

How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option

State Whether True or false.
Ans: True

This question is based upon the figure bellow
What does the purple triangle at the bottom right corner of the cell signify?
Ans: Smart Tag

You have created a worksheet which consists a confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide

A document created in Excel is referred to as a
Ans: workbook

Use this handle to automatically insert the next month in the series, January:
Ans: Fill

Which of these operators are in the correct order of operations?
Ans: ^,*,-

To move the insertion point down to the next cell, press:
Ans: Enter

The cell range A3 through G3 should be keyed in as:
Ans: A3:G3

Q1. Which of the following is NOT an option under File -> Print -> Microsoft DocumentImage Writer?
a. PDF
b. TIFF
c. MDI

Q2. Which of the following is NOT a type of section break?
a. Next page
b. Linked
c. EvenPage
d. Continuous

Q3. To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift

Q4. Which of the following in NOT a type of Section Break?

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

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

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

Q7. Which among the following chart types do not have axes?
a. Bar charts
b. XY (scatter) charts
c. Doughnut charts
d. Area charts

Q8. Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.

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

Q10. 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 Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into 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.

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

Q12. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Font of Text
d. In Line with Text

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

Q14. Applying a theme you document affects all content except tables.
a. True
b. False

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

Q16. Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts

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

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

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

Q20. I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG

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

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

Q23. What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading

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

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

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

Q27. Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can’t be achieved in Microsoft Word 2010.

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

Q29. 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.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation

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

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

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

Q33. Which among the following options represents Legend entries in the given picture?
a. A
b. B
c. C
d. None of the above.

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

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

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

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

Q38. How many items can be maintained on the clipboard at one time?
a. One
b. Up to 24
c. Unlimited
d. Up to 100

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

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

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

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

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

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

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

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

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

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

Q49. Which of the following is NOT an option when inserting a cross-reference?
a. Numbered item
b. SmartArt
c. Heading
d. Equation
e. Table

Search This Blog

Freelancer Oriention Exam Answers

Microsoft Excel 2010 Odesk Answers

odesk Microsoft Excel 2010 Test answers.