oDesk skill test MS word 2010 Answers
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
0 comments:
Post a Comment