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.
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. 2-Color Scale
b. 3-Color Scale
c. 4-Color Scale
d. Data Bar
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
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
This question is based upon the figure shown below
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)
Suppose you create a workbook in Microsoft Excel
2010 and run the 'Check Accessibility' option. This option is used to check the
workbook for __________.
a. Content that people with disabilities might find
difficult to read.
b. Checking features not supported by earlier
versions of Excel.
c. Both a and b
Suppose you have created a report in Excel named
'report.xlsx'. Now you want that your team members should be able to see the
report remotely on a web browser, and edit the report, as desired. Also it is
required that the previous versions of the report are maintained to protect
against any loss of data. Which of the following options is the most suitable
one to deploy this report?
a. Share 'report.xlsx' by saving it to SkyDrive.
b. Share 'report.xlsx' by saving it to a SharePoint
site.
c. Share 'report.xlsx' by sending it through email.
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.
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
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.
Microsoft Excel Services is a component of:
a. Microsoft SharePoint Technology
b. Microsoft Server Technology
c. Microsoft Virtualization Technology
Which of the following is available as fill options
while formatting cells of an Excel worksheet using the format style as Data
Bar?
a. Gradient Fill
b. Crystal Fill
c. Texture Fill
Which of the following areas in the Microsoft Excel
2010 PivotTable Field List, calculates the aggregates of columns?
a. Report Filter
b. Row Labels
c. Values
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 cryptographic settings
for encrypting documents.
d. None of the above
This question is based upon the figure shown below
In the given screenshot, there are red triangles in
the upper-right corner of each cell under the column titled 'Registrations'.
What do these signify?
a. The red triangles represent the comment
associated.
b. The red triangles signify an associated data
validation control.
c. The red triangles represent the tracking of the
cell.
d. The red triangles signify that the cell is a
hidden cell.
This question is based upon the figure shown below
Which of the following tools is used to format
Excel worksheet data, as shown in the figure above?
a. Slicer
b. SmartArt
c. Macros
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
Excel keeps the changed history of a workbook for
________ days by default.
a. 10 days
b. 20 days
c. 25 days
d. 30 days
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?
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
This question is based upon the figure shown below
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.
This question is based upon the figure shown below
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
This question is based upon the figure shown below
In the above given screenshot of a Microsoft Excel
2010 Worksheet, there are two columns B and D containing some integer data.
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
a. The value of cell D9 will be 24
b. The value of cell D9 will be 42
c. The value of cell D9 will be #VALUE!
State whether following statement regarding images
in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.
Microsoft Excel 2010 supports 3D rotation of images.
a. True
b. False
This question is based upon the figure shown below
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.
Which of the following statements are true
regarding PowerPivot in Microsoft Excel 2010?
a. PowerPivot streamlines the process of
integrating data from multiple sources like databases, spreadsheets, reports
and text files.
b. PowerPivot does not allow access to slicers when
working on data in PowerPivot.
c. Version control and tracking are NOT supported
by PowerPivot.
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.
This question is based upon the figure shown below
Analyze the image shown. What would be the output
when you use the following formula in an MS Excel 2010 worksheet?
=SUM(A2:CHOOSE(2,A3,A4,A5))
a. 67
b. 80
c. 90
d. 60
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.
This question is based upon the figure shown below
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.
State whether the following statement regarding
cell references in Microsoft Excel 2010 is true or false:
An Absolute cell reference consists of the column letter and row number.
An Absolute cell reference consists of the column letter and row number.
a. True
b. False
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.
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
State whether following statement regarding cell
references in Microsoft Excel 2010 is true or false:
A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
a. True
b. False
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
Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
a. True
b. False
This question is based upon the figure shown below
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.
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. 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.
What is the filename extension of Excel workbooks
which are saved as 'Excel Templates'?
a. .xlsx
b. .xslt
c. .xltx
d. .slk
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?
b. Online Analytical Processing (OLAP) Queries
c. Online Analytical Processing (OLAP) Cube Files
d. All of the above
This question is based upon the figure shown below
In the screenshot above, some product sales data is
given followed by a pivot table derived from that data. Which of the following
options is correct regarding the PivotTable?
a. The data can only be sorted according to the
'Total for three months' field.
b. The data can only be sorted according to the
'Product' field.
c. The data can be sorted according to the 'Total
for three months' field, along with filtration using the 'Product' field.
d. None of the above
Deleting a PivotChart report automatically deletes
the associated PivotTable report.
a. True
b. False
Which of the following components of Excel Services
enables the user to edit a published workbook inside a web browser?
a. Excel Calculation Services (ECS)
b. Excel Web Access (EWA)
c. Excel Web Services (EWS)
Which among the following settings is the default
macro security setting?
a. Disable all macros except digitally signed
macros.
b. Disable all macros with notification.
c. Enable all macros.
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 the
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.