Microsoft Excel 2010 Test
State
whether the 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. 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.
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.
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.
a. Ascending
b. Descending
c. Either
ascending or descending
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
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
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
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.
Deleting
a PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False
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
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.
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.
Microsoft
Excel Services is a component of:
a. Microsoft
SharePoint Technology
b. Microsoft
Server Technology
c. Microsoft Virtualization Technology
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
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
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.
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?
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!
Excel
keeps the changed history of a workbook for ________ days by default.
a. 10
days
b. 20
days
c. 25
days
d. 30 days
Suppose
you have created a report in Excel named 'report.xlsx'. Now you want your team
members to 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 axis settings are available for the appearance of data bars
for negative values in Microsoft Excel 2010?
a. Automatic
b. Cell
right
c. Cell left
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
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 updates are allowed in slicers having cloned
copies.
d. None
of the above.
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
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.
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 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.
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)
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
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.
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
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
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
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
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.
b. It
will close and save this particular worksheet of the workbook.
c. Nothing
will happen.
d. It
will hide this particular worksheet.
What
is the filename extension of Excel workbooks which are saved as 'Excel
Templates'?
a. .xlsx
b. .xslt
c. .xltx
d. .slk
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.
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
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.
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)