Computer Skills

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

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

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

First Prev 9 10 11 12 Next Last

Question: In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?

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

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?