Note: Turn on Search with
CTRL+F for your convenience to find out easily answer.
Here you get only 100%
correct odesk test answers. No fake all odesk test answers correct & you
must pass with top 10% , 20% or 30% result.
Odesk MS word 10 skill test
Question: 1
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 (Answer)
c. The value of cell D9 will
be #VALUE!
Question: 2
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. (Answer)
c. The red triangles
represent the tracking of the cell.
d. The red triangles signify
that the cell is a hidden cell.
Question: 3
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. (Answer)
b. Checking features not
supported by earlier versions of Excel.
c. Both a and b
Question: 4
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
(Answer)
c. 90
d. 60
Question: 5
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 (Answer)
b. Crystal Fill
c. Texture Fill
Question: 6
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)
Question: 7
What is the filename
extension of Excel workbooks which are saved as 'Excel Templates'?
a. .xlsx
b. .xslt
c. .xltx
(Answer)
d. .slk
Question: 8
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. (Answer)
c. Enable all macros.
Question: 9
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. (Answer)
b. Share 'report.xlsx' by
saving it to a SharePoint site.
c. Share 'report.xlsx' by
sending it through email.
Question: 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) (Answer)
c. Excel Web Services (EWS)
Question: 11
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
(Answer)
b. Descending
c. Either ascending or
descending
Question: 12
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. (Answer)
c. The PowerPivot Import
Wizard provides you with an SQL Query builder.
Question: 13
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)
Question: 14
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)
Question: 15
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
(Answer)
b. Data tables
c. Goal Seek
Question: 16
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
(Answer)
c. Workbook
Question: 17
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)
Question: 18
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 (Answer)
d. Data Bar
Question: 19
Microsoft Excel Services is a
component of:
a. Microsoft
SharePoint Technology (Answer)
b. Microsoft Server
Technology
c. Microsoft Virtualization
Technology
Question: 20
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)
Question: 21
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)
Question: 22
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)
Question: 23
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. (Answer)
C. Version control and
tracking is supported by PowerPivot.
Question: 24
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. (Answer)
c. It signifies that a macro
is disabled.
d. It signifies that a webcam
has been detected.
Question: 25
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)
Question: 26
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. (Answer)
c. It enables you to
specify cryptography settings for encrypting documents.
d. None of the above
Question: 27
which of the following tools
is used to format Excel worksheet data, as shown in the figure
above?
a. Slicer
b. SmartArt
(Answer)
c. Macros
Question: 28
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 (Answer)
d. All of the above
Question: 29
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. (Answer)
b. By using the 'Orientation'
button on the 'Page Layout' tab.
c. By using the 'WordArt'
button on the 'Insert' tab.
Question: 30
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. (Answer)
b. It will close and save
this particular worksheet of the workbook.
c. Nothing will happen.
d. It will hide this
particular worksheet.
Question: 31
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)
Question: 32
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)
Question: 33
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)
Question: 34
Deleting a PivotChart report
automatically deletes the associated PivotTable report.
a. True
b. False
(Answer)
Question: 35
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)
Question: 36
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
(Answer)
c. Cell right
Question: 37
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)
Question: 38
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. (Answer)
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.
Question: 39
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)
No comments:
Post a Comment