oDesk MS Excel 2010 Test Answers (Updated)
Odesk Microsoft Excel 2010 Test (Updated)
I share a latest answer sheet that will help you a lot. Ii is updated answers. If you take part in the oDesk exam, you will get a good feedback.
To Find Answers Simply Press Ctrl+F......................
Lets Start::::::::::::::::::::::::::::::::::::::::::::::::
1.Question:
Deleting a PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False
2 Question:
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)
3Question:
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.
4 Question:
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
5. Question:
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
6. Question:
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
7.Question:
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)
Question:
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
Question:
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?
b. Share 'report.xlsx' by saving it to a SharePoint site.
c. Share 'report.xlsx' by sending it through email.
Question:
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
Question:
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
Question:
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
Question:
Excel keeps the changed history of a workbook for ________ days by default.
a. 10 days
b. 20 days
c. 25 days
d. 30 days
Question:
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
Question:
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
Question:
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
Question:
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
Question:
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!
Question:
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
Question:
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.
Question:
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.
Question:
Which of the following statements is true regarding MS Excel Web Access on aSharePoint 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 formulasentered in multiple cells in a worksheet
Question:
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
Question:
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
Question:
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
Question:
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
Question:
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
Question:
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
Question:
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
Question:
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
Question:
What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
a. .xlsx
b. .xslt
c. .xltx
d. .slk
Question:
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 answerPivotTable queries by the PowerPivot engine.
c. Version control and tracking is supported by PowerPivot.
Question:
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
Question:
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
Question:
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
Question:
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
Question:
Microsoft Excel Services is a component of:
a. Microsoft SharePoint Technology
b. Microsoft Server Technology
c. Microsoft Virtualization Technology
Question:
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.
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 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?
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
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.
c. 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.