MS Excel, Computer Skills

MS Excel

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

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

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

Note: Not available
1. Report
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 cryptography settings for encrypting documents.

D
None of the above

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 tools is used to format Excel worksheet data, as shown in the figure above?
A
Slicer

B
SmartArt

C
Macros

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

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

First Prev 1 2 3 4 Next Last

Question: What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

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

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

Question: What does the icon marked with a red square in the figure above signify?

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

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 tools is used to format Excel worksheet data, as shown in the figure above?

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

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?