MICROSOFT EXCEL 2010 TEST 2016
1. 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?
Answers:
1.
All
cloned copies of that slicer are also updated instantly.
2.
Only the original
slicer reflects the changes being made.
3.
An error is displayed
because no updations are allowed in slicers having cloned copies.
4.
None of the above.
2. How would you assign a macro to a graphic?
Answers:
1.
On the Developer tab,
in the Code group, click on Macros.
2.
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.
3.
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.
3. 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 ($).
Answers:
1.
True
2.
False
4. 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?
Answers:
1. Office Database connections
2. Online Analytical Processing (OLAP) Queries
3. Online Analytical Processing
(OLAP) Cube Files
4. All of the above
5. Which of the following tools is used to format Excel
worksheet data, as shown in the figure above?
Answers:
1.
Slicer
2.
SmartArt
3.
Macros
6. 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?
Answers:
1. It will select the whole
sheet.
2. It will close and save this particular
worksheet of the workbook.
3. Nothing will happen.
4. It will hide this particular worksheet.
7. Which of the following components of Excel Services enables
the user to edit a published workbook inside a web browser?
Answers:
1.
Excel Calculation
Services (ECS)
2.
Excel
Web Access (EWA)
3.
Excel Web Services
(EWS)
Answers:
1.
.xlsx
2.
.xslt
3.
.xltx
4.
.slk
9. 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.
Answers:
1. True
2. False
10. 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
Answers:
1.
The value of cell D9
will be 24
2.
The
value of cell D9 will be 42
3.
The value of cell D9
will be #VALUE!
11. Which of the following statements are true regarding
PowerPivot in Microsoft Excel 2010?
Answers:
1.
PowerPivot
streamlines the process of integrating data from multiple sources like
databases, spreadsheets, reports and text files.
2.
PowerPivot does not
allow access to slicers when working on data in PowerPivot.
3.
Version control and
tracking are NOT supported by PowerPivot.
12. 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’?
Answers:
1.
=AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
2.
=AVERAGE( E6: E15)
3.
=( SUM( E6: E15) /COUNT( E6: E15))
4.
=AVERAGE( E6
to E15)
13. Which of the following statements is true regarding MS Excel
Web Access on a SharePoint Foundation 2010 Server?
Answers:
1.
The worksheet grid in
Excel Web Access on SharePoint Foundation 2010 Server is limited to 20 columns
and 75 rows.
2.
It is possible to
select contiguous and noncontiguous cells on a worksheet using mouse and
keyboard.
3.
It is
not possible to use the CTRL+Enter keyboard combination on formulas entered in
multiple cells in a worksheet.
14. 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
Answers:
1.
True
2.
False
15. What does the icon marked with a red square in the figure
above signify?
Answers:
1.
It signifies that a
macro is enabled.
2.
It
signifies that the document contains digital signatures.
3.
It signifies that a
macro is disabled.
4.
It signifies that a
webcam has been detected.
16. Excel keeps the changed history of a workbook for ________
days by default.
Answers:
1.
10 days
2.
20 days
3.
25 days
4.
30
days
17. Which of the following is available as fill options while
formatting cells of an Excel worksheet using the format style as Data Bar?
Answers:
1.
Gradient
Fill
2.
Crystal Fill
3.
Texture Fill
18. Suppose you create a workbook in Microsoft Excel 2010 and
run the ‘Check Accessibility’ option. This option is used to check the workbook
for ____________.
Answers:
1.
Content that people
with disabilities might find difficult to read.
2.
Checking features not
supported by earlier versions of Excel.
3.
Both
a and b
19. Which of the following axis settings are available for the
appearance of data bars for negative values in Microsoft Excel 2010?
Answers:
1.
Automatic
2.
Cell right
3.
Cell
left
20. What is the purpose of time stamping a digital signature in
Microsoft Excel 2010?
Answers:
1.
It helps you mitigate
integrity threats.
2.
It
ensures that digital signatures remain valid and legally defensible even if the
certificate that is used to sign the document expires.
3.
It enables you to
specify cryptographic settings for encrypting documents.
4.
None of the above
21. Microsoft Excel Services is a component of:
Answers:
1.
Microsoft
SharePoint Technology
2.
Microsoft Server
Technology
3.
Microsoft
Virtualization Technology
22. Which of the following statements is NOT true regarding
import of data into PowerPivot?
Answers:
1.
Data
can be imported into PowerPivot by either selecting list of tables or by
writing SQL query .
2.
The data being
imported into PowerPivot can be filtered before the import.
3.
The PowerPivot Import
Wizard provides you with an SQL Query builder.
23. Which among the following settings is the default macro
security setting?
Answers:
1.
Disable all macros
except digitally signed macros.
2.
Disable
all macros with notification.
3.
Enable all macros.
24. 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?
Answers:
1.
Cell Color
2.
Font Color
3.
Font
Style
25. 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.
Answers:
1.
True
2.
False
26. In the given screenshot, the contents of the ‘Name of User’
column have been oriented at an angle. How is this done?
Answers:
1.
By
using the ‘Orientation’ button in the alignment group of the ‘Home’ tab.
2.
By using the
‘Orientation’ button on the ‘Page Layout’ tab.
3.
By using the ‘WordArt’
button on the ‘Insert’ tab.
27. Which of the following statements is not true regarding
offline cube files in Microsoft Excel 2010?
Answers:
1.
An offline cube file
stores data in the form of an OLAP cube.
2.
If you delete the offline
cube file for the report, still you can create a new offline cube file for the
report.
3.
An
offline cube file allows you to work with PivotTable and PivotChart reports
even when the server is unavailable.
28. 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?
Answers:
1.
The
red triangles represent the comment associated.
2.
The red triangles
signify an associated data validation control.
3.
The red triangles represent
the tracking of the cell.
4.
The red triangles
signify that the cell is a hidden cell.
29. 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.
Answers:
1.
Table
2.
Worksheet
3.
Workbook
30. What are the benefits of digitally signing an e-mail in
Microsoft Excel 2010?
Answers:
1.
Digital signatures
help authenticate the source of the messages.
2.
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.
3.
Digitally signed
e-mails meet legal requirements for admissibility and authenticity.
4.
All
of the above.
31. Deleting a PivotChart report automatically deletes the
associated PivotTable report.
Answers:
1.
True
2.
False
32. 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?
Answers:
1.
Scenarios
2.
Data tables
3.
Goal Seek
33. Which of the following axis settings are available for the
appearance of data bars for negative values in Microsoft Excel 2010?
Answers:
1.
Cell midpoint
2.
Cell left
3.
Cell
right
34. Which of the following areas in the Microsoft Excel 2010
PivotTable Field List, calculates the aggregates of columns?
Answers:
1.
Report Filter
2.
Row Labels
3.
Values
35. 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.
Answers:
1.
Ascending
2.
Descending
3.
Either ascending or
descending
36. 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?
Answers:
1.
2-Color Scale
2.
3-Color Scale
3.
4-Color
Scale
4.
Data Bar
37. 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))
=SUM(A2:CHOOSE(2,A3,A4,A5))
Answers:
1.
67
2.
80
3.
90
4.
60
38. 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?
Answers:
1.
lookup_value
2.
lookup_vector
3.
result_vector
39. Which of the following statements is true regarding
PowerPivot in Microsoft Excel 2010?
Answers:
1.
One limitation of
PowerPivot is that it does not allow access to Slicers when working on data in
PowerPivot.
2.
A connection to a
server running SQL Server Analysis Services is required to answer PivotTable
queries by the PowerPivot engine.
3.
Version
control and tracking is supported by PowerPivot.
40. 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?
Answers:
1.
Share ‘report.xlsx’ by
saving it to SkyDrive.
2.
Share
‘report.xlsx’ by saving it to a SharePoint site.
3.
Share ‘report.xlsx’ by
sending it through email.
41. 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 ($).
Answers:
1.
True
False
