oDesk
এ যারা Excel এর কাজ করতে চান তাদের জন্য প্রয়োজন oDesk Microsoft Excel
Exam এ পরীক্ষা দিয়ে পাশ করা। আর তাই আজ আপনাদের জানাবো ২০১৩-২০১৪ এর oDesk
Microsoft Excel 2010 Test Answer------
1. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: a. An offline cube file stores data in the form of an OLAP cube.
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?
Ans: c. 4-Color Scale
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?
Ans: a. Scenarios
4. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: b. Cell left
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'?
Ans: 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 __________.
Ans: b. Checking features not supported by earlier versions of Excel.
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?
Ans: b. Share 'report.xlsx' by saving it to a SharePoint site.
8. Which of the following statements is NOT true regarding import of data into PowerPivot?
Ans: a. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.
9. Which of the following axis settings are available for the appearance of bars for negative values in Microsoft Excel 2010?
Ans: c. Cell left
10. Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
Ans: c. Version control and tracking is supported by PowerPivot.
11. Microsoft Excel Services is a component of:
Ans: a. Microsoft SharePoint 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?
Ans: a. Gradient Fill
13. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Ans: c. Values
14. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Ans: b. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
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?
Ans: a. The red triangles represent the comment associated.
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?
Ans: b. SmartArt
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?
Ans: c. Font Style
18. Excel keeps the changed history of a workbook for ________ days by default.
Ans: d. 30 days
19. Analyze the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value,lookup_vec
Which of the following arguments of the LOOKUP function is optional?
Ans: 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 Ans: Ctrl+A.
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.
Ans: b. Worksheet
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?
Ans: b. The value of cell D9 will be 42
23. State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.
Ans: 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?
Ans: a. By using the 'Orientation' button in the alignment group of the 'Home' tab.
25. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
Ans: a. PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.
26. Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
Ans: 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))
Ans: b. 80
28. How would you assign a macro to a graphic?
Ans: 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
Ans: a. All cloned copies of that slicer are also updated instantly.
30. State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false:
Ans: a. True
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.
Ans: a. Ascending
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 ($).
Ans: 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
Ans: 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?
Ans: b. It signifies that the document contains digital signatures.
35. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Ans: d. All of the above.
36. What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
Ans: c. .xltx
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?
Ans: c. Online Analytical Processing (OLAP) Cube Files
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?
Ans: b. The data can only be sorted according to the 'Product' field.
39. Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: b. False
40. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
Ans: b. Excel Web Access (EWA)
41. Which among the following settings is the default macro security setting?
Ans: b. Disable all macros with notification.
42. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: c. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
1. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: a. An offline cube file stores data in the form of an OLAP cube.
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?
Ans: c. 4-Color Scale
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?
Ans: a. Scenarios
4. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: b. Cell left
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'?
Ans: 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 __________.
Ans: b. Checking features not supported by earlier versions of Excel.
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?
Ans: b. Share 'report.xlsx' by saving it to a SharePoint site.
8. Which of the following statements is NOT true regarding import of data into PowerPivot?
Ans: a. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.
9. Which of the following axis settings are available for the appearance of bars for negative values in Microsoft Excel 2010?
Ans: c. Cell left
10. Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
Ans: c. Version control and tracking is supported by PowerPivot.
11. Microsoft Excel Services is a component of:
Ans: a. Microsoft SharePoint 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?
Ans: a. Gradient Fill
13. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Ans: c. Values
14. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Ans: b. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
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?
Ans: a. The red triangles represent the comment associated.
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?
Ans: b. SmartArt
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?
Ans: c. Font Style
18. Excel keeps the changed history of a workbook for ________ days by default.
Ans: d. 30 days
19. Analyze the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value,lookup_vec
Which of the following arguments of the LOOKUP function is optional?
Ans: 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 Ans: Ctrl+A.
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.
Ans: b. Worksheet
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?
Ans: b. The value of cell D9 will be 42
23. State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.
Ans: 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?
Ans: a. By using the 'Orientation' button in the alignment group of the 'Home' tab.
25. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
Ans: a. PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.
26. Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
Ans: 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))
Ans: b. 80
28. How would you assign a macro to a graphic?
Ans: 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
Ans: a. All cloned copies of that slicer are also updated instantly.
30. State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false:
Ans: a. True
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.
Ans: a. Ascending
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 ($).
Ans: 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
Ans: 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?
Ans: b. It signifies that the document contains digital signatures.
35. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Ans: d. All of the above.
36. What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
Ans: c. .xltx
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?
Ans: c. Online Analytical Processing (OLAP) Cube Files
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?
Ans: b. The data can only be sorted according to the 'Product' field.
39. Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: b. False
40. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
Ans: b. Excel Web Access (EWA)
41. Which among the following settings is the default macro security setting?
Ans: b. Disable all macros with notification.
42. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: c. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
