MS Excel, Computer Skills

MS Excel

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

B
Descending

C
Either ascending or descending

Note: Not available
1. Report
Question: Which of the following statements is NOT true regarding import of data into PowerPivot?
A
Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.

B
The data being imported into PowerPivot can be filtered before the import.

C
The PowerPivot Import Wizard provides you with an SQL Query builder.

Note: Not available
1. Report
Question: Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
A
The worksheet grid in Excel Web Access on SharePoint Foundation 2010 Server is limited to 20 columns and 75 rows.

B
It is possible to select contiguous and noncontiguous cells on a worksheet using mouse and keyboard.

C
It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.

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

B
Font Color

C
Font Style

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

B
Data tables

C
Goal Seek

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

B
Worksheet

C
Workbook

Note: Not available
1. Report
Question: Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
A
An offline cube file stores data in the form of an OLAP cube.

B
If you delete the offline cube file for a report, still you can create a new offline cube file for the report.

C
An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

Note: Not available
1. Report
Question: 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?
A
3-Color Scale

B
4-Color Scale

C
Data Bar

D
2-Color Scale

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

First Prev 1 2 3 4 Next Last

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

Question: Which of the following statements is NOT true regarding import of data into PowerPivot?

Question: Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?

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

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

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

Question: Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?

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

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?