MS Excel, Computer Skills

MS Excel

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

Note: Not available
1. Report
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

Note: Not available
1. Report
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 answer PivotTable queries by the PowerPivot engine.

C
Version control and tracking is supported by PowerPivot.

Note: Not available
1. Report
Question: Deleting a PivotChart report automatically deletes the associated PivotTable report.
A
True

B
False

Note: Not available
1. Report
Question: 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)

Note: Not available
1. Report
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

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: 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.

Note: Not available
1. Report
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

Note: Not available
1. Report

First Prev 2 3 4 Next Last

Question: State whether following statement regarding images in Microsoft Excel 2010 is true or false: Microsoft Excel 2010 supports 3D rotation of images.

Question: Which of the following axis settings are available for the appearance of bars for negative values in Microsoft Excel 2010?

Question: Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?

Question: Deleting a PivotChart report automatically deletes the associated PivotTable report.

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

Question: Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

Question: How would you assign a macro to a graphic?

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

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