Computer Skills

Computer Skills - Upwork

Question: Microsoft Excel Services is a component of:
A
Microsoft SharePoint Technology

B
Microsoft Server Technology

C
Microsoft Virtualization Technology

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

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

First Prev 8 9 10 11 12 Next Last

Question: Microsoft Excel Services is a component of:

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?

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?