Q#01
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?
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!
Answer
is (B). The value of cell D9 will be 42
Q#02
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.
Answer
is (B). The red triangles signify an associated data validation control
Q#03
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
Answer
is (A).Content that people with disabilities might find difficult to read.
Q#04
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
Answer
is (B).80
Q#05
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
Answer
is (A). Gradient Fill
Q#06
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
Answer
is (C).Values
Q#07
What is the
filename extension of Excel workbooks which are saved as 'Excel
Templates'?
a.
.xlsx
b.
.xslt
c. .xltx
d.
.slk
Answer
is (C).xltx
Q#08
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.
Answer
is (B). Disable all macros with notification
Q#09
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.
Answer
is (A).Share'report.xlsx' by saving it to skyDrive.
Q#10
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)
Answer
is (B).Excel Web Access (EWA)
Q#10
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
Answer
is (A).Ascending
Q#11
_________________________________________________________
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.
Answer
is (B).The data being imported into PowerPivot can be filtered before the
import.
Q#12
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.
Answer
is (C).it is not possible to use the CTR+Enter keyboard combination on formulas
entered in multiple cells inn a worksheet
Q#13
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
Answer
is (C).Font Style
Q#14
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
Answer
is (A).Scenarios
Q#15
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
Answer
is (B).Worksheet
Q#16
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.
Answer
is (C).An offline cube file allows you to work with PivotTable and PivotChart
reports even when the server is unavailable.
Q#17
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
Answer
is (C).4-Color Scale
Q#18
Microsoft
Excel Services is a component of:
a. Microsoft SharePoint
Technology
b.
Microsoft Server Technology
c.
Microsoft Virtualization Technology
Answer
is (A).Microsoft SharePoint Technology
Q#19
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
Answer
is (C).Result-vector
Q#20
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.
Answer
is (D).All of the above
Q#21
Excel keeps
the changed history of a workbook for ________ days by default.
a.
10 days
b.
20 days
c.
25 days
d.
30 days
Answer
is (D).30 days
Q#22
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.
Answer
is (B).80
Q#23
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.
Answer
is (B). It signifies that the document contains digital signatures.
Q#24
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
Answer
is (B). False
Q#25
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
Answer
is (B). it ensures that digital signatures remain valid and legally defensible
even if the certificate that is used to sign the document expires.
Q#26
which of the
following tools is used to format Excel worksheet data, as shown in the figure
above?
a.
Slicer
b.
SmartArt
c.
Macros
Answer
is (B). SmartArt
Q#27
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
Answer
is (C). online Analystical Processing (OLAP) Cube File
Q#28
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.
Answer
is (A). By using the 'Orientation' button in the alignment group of the
'Home' tab.
Q#29
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.
Answer
is (A). It will select the whole sheet, having the same effect as that of
Ctrl+A.
Q#30
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
Answer
is (B). False
Q#31
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
Answer
is (C). Cell left
Q#32
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.
Answer
is (C). Version control and tracking is supported by PowerPivot.
Q#33
Deleting a
PivotChart report automatically deletes the associated PivotTable
report.
a.
True
b.
False
Answer
is (B). False
Q#34
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)
Answer
is (D). =AVERAGE(E6
to E15)
Q#35
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
Answer
is (B). Cell Left
Q#36
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 (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.
Q#37
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.
Answer
is (A). All cloned copies of that slicer are also updated instantly.
Q#38
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
a.
True
b.
False
Answer
is (B). False