'PAGLATJ'

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;">Odesk</span> Microsoft Excel 2010 Test answers and 100% pass<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCMTdq4xHY9Bkex8vJ8e6PxXcGM64BPc_qvwVlQxJoTBli1kF_Khns4aw6rvphjNtBJP6xMMI4NVsfEtdTp88Jwnxurn14hA9yUnLzYtJi4wG3zrOix4t0OF1GrIdcaFoM_XqFXXZwSJE/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCMTdq4xHY9Bkex8vJ8e6PxXcGM64BPc_qvwVlQxJoTBli1kF_Khns4aw6rvphjNtBJP6xMMI4NVsfEtdTp88Jwnxurn14hA9yUnLzYtJi4wG3zrOix4t0OF1GrIdcaFoM_XqFXXZwSJE/s1600/images.jpg" /></a></div>
<div style="text-align: center;">
<h2>
<span style="font-size: medium;"><b><i><u><span style="line-height: 115%;"><span style="background-color: white;">Odesk</span> Microsoft Excel 2010 Test</span></u></i></b></span></h2>
<h2 style="text-align: left;">
<span style="font-size: medium;"><b><i><u><span style="line-height: 115%;"><br /></span></u></i></b></span></h2>
</div>
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="6" data-iceapw="17" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="17" style="font-size: x-small;"><span data-iceapc="4" data-iceapw="17"><b data-iceapc="3" data-iceapw="17"><i data-iceapc="2" data-iceapw="17"><u data-iceapc="1" data-iceapw="17"><span data-iceapw="17" style="line-height: 115%;">Which
of the following statements is not true regarding offline cube files in
Microsoft Excel 2010?</span></u></i></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="14" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="14"><span data-iceapc="1" data-iceapw="14"><b data-iceapw="14">a.
An offline cube file stores data in the form of an OLAP cube.</b></span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="23" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="23" style="font-size: x-small;"><span data-iceapw="23">b. If you delete the offline cube
file for a report, still you can create a new offline cube file for the report.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="20" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="20" style="font-size: x-small;"><span data-iceapc="1" data-iceapw="20"><span data-iceapw="20" style="line-height: 115%;">c. An offline cube file allows you
to work with Pivot Table and Pivot Chart reports even when the server is
unavailable.</span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="42" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="42" style="font-size: x-small;"><span data-iceapc="4" data-iceapw="42"><b data-iceapc="3" data-iceapw="42"><i data-iceapc="2" data-iceapw="42"><u data-iceapc="1" data-iceapw="42"><span data-iceapw="42" style="line-height: 115%;">You
are creating a new formatting rule which will be used to format a Pivot Table
report. Which of the following formatting styles is NOT available while
formatting all cells of Pivot Table report based on their values in an MS Excel
2010 <span class="IL_AD" id="IL_AD2">worksheet</span>?</span></u></i></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3">a. 2-Color Scale</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3">b. 3-Color Scale</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="3"><span data-iceapc="1" data-iceapw="3"><b data-iceapw="3">c.
4-Color Scale</b></span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="3" style="font-size: x-small;"><span data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="line-height: 115%;">d. Data Bar</span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="44" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="44" style="font-size: x-small;"><span data-iceapc="4" data-iceapw="44"><b data-iceapc="3" data-iceapw="44"><i data-iceapc="2" data-iceapw="44"><u data-iceapc="1" data-iceapw="44"><span data-iceapw="44" style="line-height: 115%;">You
are a financial consultant to multiple clients and you made an investment <span class="IL_AD" id="IL_AD5">model
for</span> them. Now you want to find out how investment rates change under different
market conditions. Which of the following Microsoft Excel 2010 What-if <span class="IL_AD" id="IL_AD8">analysis</span>
tools will you use to study such conditions?</span></u></i></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><span data-iceapc="1" data-iceapw="2"><b data-iceapw="2">a.
Scenarios</b></span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3">b. Data tables</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="3" style="font-size: x-small;"><span data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="line-height: 115%;">c. Goal Seek</span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><a href="https://www.blogger.com/null" name="more"></a><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="22" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="22" style="font-size: x-small;"><span data-iceapc="4" data-iceapw="22"><b data-iceapc="3" data-iceapw="22"><i data-iceapc="2" data-iceapw="22"><u data-iceapc="1" data-iceapw="22"><span data-iceapw="22" style="line-height: 115%;">Which
of the following axis settings are available for the appearance of data bars
for negative values in Microsoft Excel 2010?</span></u></i></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3">a. Cell midpoint</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="3"><span data-iceapc="1" data-iceapw="3"><b data-iceapw="3">b.
Cell left</b></span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="3" style="font-size: x-small;"><span data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="line-height: 115%;">c. Cell right</span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="9" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="9" style="font-size: x-small;"><span data-iceapc="4" data-iceapw="9"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="line-height: 115%;">This
question is based upon the figure shown below</span></u></i></b></span></span></div>
<span style="font-size: xx-small;">
</span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw4-XeMQ7nO7bKLAFZqffxrkcISkIn-JoaT2AQHVr6sCIJVzU1zcaoTmV_m4_3jPVSqY09BD67bIE8l5pyJeF1l3N_-yOuxQNzPI7Nwo4qA_biScuFTLteSH_a3oRy28ZM0oo3Rw_g8k0/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw4-XeMQ7nO7bKLAFZqffxrkcISkIn-JoaT2AQHVr6sCIJVzU1zcaoTmV_m4_3jPVSqY09BD67bIE8l5pyJeF1l3N_-yOuxQNzPI7Nwo4qA_biScuFTLteSH_a3oRy28ZM0oo3Rw_g8k0/s1600/1.png" /></a></div>
<br />
<div class="MsoNormal" data-iceapc="6" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
</div>
<br />
<br />
<div class="MsoNormal" data-iceapc="6" style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0.0001pt; text-align: justify;">
<div class="MsoNormal" data-iceapc="2" data-iceapw="26" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="26" style="font-size: x-small;"><span data-iceapw="26" style="font-family: "Arial","sans-serif"; line-height: 115%;">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'?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a.
=AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b. =AVERAGE(E6:E15)</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">c. =(SUM(E6:E15)/COUNT(E6:E15))</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="4" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="4"><b data-iceapc="1" data-iceapw="4"><span data-iceapw="4" style="font-family: "Arial","sans-serif"; line-height: 115%;">d.
=AVERAGE(E6 to E15)</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="25" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="25" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="25"><i data-iceapc="2" data-iceapw="25"><u data-iceapc="1" data-iceapw="25"><span data-iceapw="25" style="font-family: "Arial","sans-serif"; line-height: 115%;">Suppose
you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility'
option. This option is used to check the workbook for __________.</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="9" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="9" style="font-size: x-small;"><span data-iceapw="9" style="font-family: "Arial","sans-serif";">a. <span class="IL_AD" id="IL_AD6">Content that</span> people with
disabilities might find difficult to read.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="9" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="9"><b data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif";">b.
Checking features not supported by earlier <span class="IL_AD" id="IL_AD1">versions</span> of Excel.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Both a and b</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="69" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="69" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="69"><i data-iceapc="2" data-iceapw="69"><u data-iceapc="1" data-iceapw="69"><span data-iceapw="69" style="font-family: "Arial","sans-serif"; line-height: 115%;">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?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif";">a. Share 'report.xlsx' by saving it
to Sky Drive.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="10" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="10"><b data-iceapc="1" data-iceapw="10"><span data-iceapw="10" style="font-family: "Arial","sans-serif";">b.
Share 'report.xlsx' by saving it to a SharePoint site.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Share 'report.xlsx' by sending it
through email.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="14" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following statements is NOT true regarding import of data into
Power Pivot?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="18" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="18" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="18"><span data-iceapw="18" style="font-family: "Arial","sans-serif";"><span style="background-color: yellow;">a.
Data can be imported into PowerPivot by either selecting list of tables or by
writing SQL query</span>.</span></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="13" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="13" style="font-size: x-small;"><span data-iceapw="13" style="font-family: "Arial","sans-serif";">b. The data being imported into
Power Pivot can be filtered before the import.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="12" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="12" style="font-size: x-small;"><span data-iceapw="12" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. The Power Pivot Import Wizard
provides you with an <span style="background-color: white;">SQL</span> Query builder.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="21" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="21" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="21"><i data-iceapc="2" data-iceapw="21"><u data-iceapc="1" data-iceapw="21"><span data-iceapw="21" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following axis settings are available for the appearance of bars for
negative values in Microsoft Excel 2010?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. Automatic</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">b. Cell right</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="3"><b data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="font-family: "Arial","sans-serif"; line-height: 115%;">c.
Cell left</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="14" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following statements is true regarding Power Pivot in Microsoft Excel
2010?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="20" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="20" style="font-size: x-small;"><span data-iceapw="20" style="font-family: "Arial","sans-serif";">a. One limitation of Power Pivot is
that it does not allow access to Slicers when working on data in Power Pivot.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="21" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="21" style="font-size: x-small;"><span data-iceapw="21" style="font-family: "Arial","sans-serif";">b. A connection to a server running
<span style="background-color: white;">SQL</span> Server Analysis Services is required to answer Pivot Table queries by the
Power Pivot engine.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">c.
Version control and tracking is supported by Power Pivot.</span></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="7" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="7" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="7"><i data-iceapc="2" data-iceapw="7"><u data-iceapc="1" data-iceapw="7"><span data-iceapw="7" style="font-family: "Arial","sans-serif"; line-height: 115%;">Microsoft
Excel Services is a component of:</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="4" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="4"><b data-iceapc="1" data-iceapw="4"><span data-iceapw="4" style="font-family: "Arial","sans-serif";">a.
Microsoft SharePoint Technology</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="4" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="4" style="font-size: x-small;"><span data-iceapw="4" style="font-family: "Arial","sans-serif";">b. Microsoft Server Technology</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Microsoft <span class="IL_AD" id="IL_AD12">Vitalization
Technology</span></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="23" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="23" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="23"><i data-iceapc="2" data-iceapw="23"><u data-iceapc="1" data-iceapw="23"><span data-iceapw="23" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following is available as fill options while formatting cells of an
Excel worksheet using the format style as Data Bar?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="3"><b data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">a.
Gradient Fill</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">b. Crystal Fill</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Texture Fill</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="18" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="18" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="18"><i data-iceapc="2" data-iceapw="18"><u data-iceapc="1" data-iceapw="18"><span data-iceapw="18" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following areas in the Microsoft Excel 2010 Pivot Table Field List,
calculates the aggregates of columns?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">a. Report Filter</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">b. Row Labels</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">c.
Values</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="14" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">What
is the purpose of time stamping a digital <span class="IL_AD" id="IL_AD3">signature</span> in Microsoft Excel 2010?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="7" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="7" style="font-size: x-small;"><span data-iceapw="7" style="font-family: "Arial","sans-serif";">a. It helps you mitigate integrity
threats.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="23" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="23"><b data-iceapc="1" data-iceapw="23"><span data-iceapw="23" style="font-family: "Arial","sans-serif";">b.
It ensures that digital signatures remain valid and legally defensible even if
the certificate that is used to sign the document expires.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="11" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="11" style="font-size: x-small;"><span data-iceapw="11" style="font-family: "Arial","sans-serif";">c. It enables you to specify
cryptographic settings for encrypting documents.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. None of the above</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below</span></u></i></b></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoB_p9SAm9_Jfcl04qm-540rdCp3fiotblV6YG0hsP6zLRaUGH6vAUoXH-3Rbl42qh1IGdUCE2PstG_zbkzcOMOt9gcZQTSnETO9DKjOL7R4JLzt-ifeD7ny7r6i1buJlmcA8jZUGwu24/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoB_p9SAm9_Jfcl04qm-540rdCp3fiotblV6YG0hsP6zLRaUGH6vAUoXH-3Rbl42qh1IGdUCE2PstG_zbkzcOMOt9gcZQTSnETO9DKjOL7R4JLzt-ifeD7ny7r6i1buJlmcA8jZUGwu24/s1600/2.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" style="font-size: x-small;"><b data-iceapc="3"><i data-iceapc="2"><u data-iceapc="1"><span style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
<span style="font-size: x-small;"> <span data-iceapc="1" data-iceapw="24"><span data-iceapw="24" style="font-family: "Arial","sans-serif"; line-height: 115%;">n
the given screenshot, there are red triangles in the upper-right corner of each
cell under the column titled 'Registrations'. What do these signify?</span></span></span>

<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="8" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="8"><b data-iceapc="1" data-iceapw="8"><span data-iceapw="8" style="font-family: "Arial","sans-serif";">a.
The red triangles represent the comment associated.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif";">b. The red triangles signify an
associated data validation control.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif";">c. The red triangles represent the tracking
of the cell.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="12" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="12" style="font-size: x-small;"><span data-iceapw="12" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. The red triangles signify that
the cell is a hidden cell.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiyu_MtqEn4rEJmNg5KajQWP4fc9J32kmOnCbwARlc4djXqBc-OE7YDCY3AF__Mx5kCjHYDzKi2j8C8ctt8MsUlLlKCA1qGWY-s5nQFZ0b9aBQHwowMhDPvVa4sJkTvy1AowKnWwhgpr4/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiyu_MtqEn4rEJmNg5KajQWP4fc9J32kmOnCbwARlc4djXqBc-OE7YDCY3AF__Mx5kCjHYDzKi2j8C8ctt8MsUlLlKCA1qGWY-s5nQFZ0b9aBQHwowMhDPvVa4sJkTvy1AowKnWwhgpr4/s1600/3.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="18" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="18" style="font-size: x-small;"><span data-iceapw="18" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following tools is used to format Excel worksheet data, as shown in the
figure above?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. Slicer</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b.
SmartArt</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Macros</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="28" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="28" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="28"><i data-iceapc="2" data-iceapw="28"><u data-iceapc="1" data-iceapw="28"><span data-iceapw="28" style="font-family: "Arial","sans-serif"; line-height: 115%;">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?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">a. Cell Color</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">b. Font Color</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="1" style="font-size: x-small;"><span style="background-color: yellow;"><b data-iceapc="1" data-iceapw="1"><span data-iceapw="1" style="font-family: "Arial","sans-serif"; line-height: 115%;">c.
<span class="IL_AD" id="IL_AD10">Font Style</span></span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="13" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="13" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="13"><i data-iceapc="2" data-iceapw="13"><u data-iceapc="1" data-iceapw="13"><span data-iceapw="13" style="font-family: "Arial","sans-serif"; line-height: 115%;">Excel
keeps the changed history of a workbook for ________ days by default.</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">a. 10 days</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">b. 20 days</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">c. 25 days</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="3" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="3"><b data-iceapc="1" data-iceapw="3"><span data-iceapw="3" style="font-family: "Arial","sans-serif"; line-height: 115%;">d.
30 days</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="25" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="25" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="11"><i data-iceapc="2" data-iceapw="11"><u data-iceapc="1" data-iceapw="11"><span data-iceapw="11" style="font-family: "Arial","sans-serif"; line-height: 115%;">Analyze
the syntax of <span style="background-color: white;">LOOKUP</span> function when used in vector form?<br />
</span></u></i></b><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
<span style="background-color: white;">LOOKUP(lookup</span>_value, <span style="background-color: white;">lookup</span>_vector, result_vector)<br />
<br />
Which of the following arguments of the LOOK UP function is optional?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. look up_value</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b. look up_vector</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">c.
result_vector</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9FIh9At7CWM9gPqyuov3yBRql8I7JYRVzqUDWsZp-n355JoG3MoPjgoK-dJa6g45o918EMgdfSTbhBYUrk3I_jrtmn933obUrU0CIqaRxYE7WE_TeJYx4Oeb28dwV3nH7IO4UZoGuw8s/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9FIh9At7CWM9gPqyuov3yBRql8I7JYRVzqUDWsZp-n355JoG3MoPjgoK-dJa6g45o918EMgdfSTbhBYUrk3I_jrtmn933obUrU0CIqaRxYE7WE_TeJYx4Oeb28dwV3nH7IO4UZoGuw8s/s1600/4.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
</div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="31" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="31" style="font-size: x-small;"><span data-iceapw="31" style="font-family: "Arial","sans-serif"; line-height: 115%;">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?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="15" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="15"><b data-iceapc="1" data-iceapw="15"><span data-iceapw="15" style="font-family: "Arial","sans-serif";">a.
It will select the whole sheet, having the same effect as that of Ctrl+A.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="12" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="12" style="font-size: x-small;"><span data-iceapw="12" style="font-family: "Arial","sans-serif";">b. It will close and save this
particular worksheet of the workbook.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="4" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="4" style="font-size: x-small;"><span data-iceapw="4" style="font-family: "Arial","sans-serif";">c. Nothing will happen.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. It will hide this particular worksheet.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below</span></u></i></b></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHaOvmjEEeK3p68TAjHWa6I-pGZnvytSBlKyKO_wyOKe8BkVnj3bbROVjfP6rF958rE-tizHx9S7FxPfI35FFMqAtuaVQUCM0kB3JjmhNUJXmVRCh8g4S3_a6b3SmN0eVRf3mct_Sm7sw/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHaOvmjEEeK3p68TAjHWa6I-pGZnvytSBlKyKO_wyOKe8BkVnj3bbROVjfP6rF958rE-tizHx9S7FxPfI35FFMqAtuaVQUCM0kB3JjmhNUJXmVRCh8g4S3_a6b3SmN0eVRf3mct_Sm7sw/s1600/5.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" style="font-size: x-small;"><b data-iceapc="3"><i data-iceapc="2"><u data-iceapc="1"><span style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="28" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="28" style="font-size: x-small;"><span data-iceapw="28" style="font-family: "Arial","sans-serif"; line-height: 115%;">When
you double-click on a pivot report value of a Pivot Table in Microsoft Excel
2010, Excel creates new ________ with data corresponding to the pivot report
value.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. Table</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b.
Worksheet</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Workbook</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLG7wVhEamD9yjcYy5nJd1kTpw0xIFlsbItHNjp22_fE6wCHW59R-Vdx9Ypuc2l1yjSO3psJj_xSYZVxSdsXRBynwmlnT2kpBz1jM56f1mungl2kWT4kHYEWdtAchkPWmI3naQUbw5BWQ/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLG7wVhEamD9yjcYy5nJd1kTpw0xIFlsbItHNjp22_fE6wCHW59R-Vdx9Ypuc2l1yjSO3psJj_xSYZVxSdsXRBynwmlnT2kpBz1jM56f1mungl2kWT4kHYEWdtAchkPWmI3naQUbw5BWQ/s1600/6.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="38" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="38" style="font-size: x-small;"><span data-iceapw="38" style="font-family: "Arial","sans-serif"; line-height: 115%;">In
the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two
columns B and D containing some integer data.<br />
Considering that cell D9 is assigned <span class="IL_AD" id="IL_AD11">the formula</span>: =SUM(D3:D7), which of the
following statements is true?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="9" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="9" style="font-size: x-small;"><span data-iceapw="9" style="font-family: "Arial","sans-serif";">a. The value of cell D9 will be 24</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="9" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif";"><span style="background-color: yellow;">b.
The value of cell D9 will be 4</span>2</span></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="9" style="font-size: x-small;"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. The value of cell D9 will be
#VALUE!</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="6" data-iceapw="22" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="22" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">State
whether following statement regarding images in Microsoft Excel 2010 is true or
false:<br />
</span></u></i></b><span data-iceapw="8" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
Microsoft Excel 2010 supports 3D rotation of images.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. True</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">b.
False</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggjOKoMqGI6d5f23-507HirCk5u_yqyDsNw2H0nkynS6xJ-3u-4TlVYPdiigpXY21O2AifBTHEMZHMKC3GCuXMhRYyQ-4WdOkllBQb9ZW0rH9MjI-Dg32n0Q7pK2zMFo7DJW7j9sBBKe4/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggjOKoMqGI6d5f23-507HirCk5u_yqyDsNw2H0nkynS6xJ-3u-4TlVYPdiigpXY21O2AifBTHEMZHMKC3GCuXMhRYyQ-4WdOkllBQb9ZW0rH9MjI-Dg32n0Q7pK2zMFo7DJW7j9sBBKe4/s1600/7.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="20" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="20" style="font-size: x-small;"><span data-iceapw="20" style="font-family: "Arial","sans-serif"; line-height: 115%;">In
the given screenshot, the contents of the 'Name of User' column <span class="IL_AD" id="IL_AD9">have been</span>
oriented at an angle. How is this done?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="14" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="14"><b data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif";">a.
By using the 'Orientation' button in the alignment group of the 'Home' tab.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="11" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="11" style="font-size: x-small;"><span data-iceapw="11" style="font-family: "Arial","sans-serif";">b. By using the 'Orientation' button
on the 'Page Layout' tab.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. By using the 'WordArt' button on
the 'Insert' tab.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="14" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following statements are true regarding Power Pivot in Microsoft Excel
2010?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="18" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="18"><b data-iceapc="1" data-iceapw="18"><span data-iceapw="18" style="font-family: "Arial","sans-serif";">a.
PowerPivot streamlines the process of integrating data from multiple sources
like databases, spreadsheets, reports and text files.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="14" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="14" style="font-size: x-small;"><span data-iceapw="14" style="font-family: "Arial","sans-serif";">b. Power Pivot does not allow access
to slicers when working on data in Power Pivot.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Version control and tracking are
NOT supported by Power Pivot.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="18" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="18" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="18"><i data-iceapc="2" data-iceapw="18"><u data-iceapc="1" data-iceapw="18"><span data-iceapw="18" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following statements is true regarding MS Excel Web Access on a
Share Point Foundation 2010 Server?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="21" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="21" style="font-size: x-small;"><span data-iceapw="21" style="font-family: "Arial","sans-serif";">a. The worksheet grid in Excel Web
Access on Share Point Foundation 2010 Server is limited to 20 columns and 75
rows.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="17" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="17" style="font-size: x-small;"><span data-iceapw="17" style="font-family: "Arial","sans-serif";">b. It is possible to select
contiguous and non contiguous cells on a worksheet using mouse and keyboard.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="21" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="21" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="21"><span data-iceapw="21" style="font-family: "Arial","sans-serif"; line-height: 115%;"><span style="background-color: yellow;">c.
It is not possible to use the CTRL+Enter keyboard combination on formulas
entered in multiple cells in a worksheet</span>.</span></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD_WT5u-AJHegw87bG1X4peOkaUDgDo9KmmbTSrxw5vArFQwBFrZHpR-pawZ93OR_TP65Fna2UNmNTJpgieaHgqDdx_4TYVKvghbPePTm8YX8w8CBkqlES-3Mm732KdgONLCOCETwHdsc/s1600/8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD_WT5u-AJHegw87bG1X4peOkaUDgDo9KmmbTSrxw5vArFQwBFrZHpR-pawZ93OR_TP65Fna2UNmNTJpgieaHgqDdx_4TYVKvghbPePTm8YX8w8CBkqlES-3Mm732KdgONLCOCETwHdsc/s1600/8.jpg" /></a></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="22" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="22" style="font-size: x-small;"><span data-iceapw="22" style="font-family: "Arial","sans-serif"; line-height: 115%;">Analyze
the image shown. What would be the output when you use the following formula in
an MS Excel 2010 worksheet?</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="1" style="font-size: x-small;"><span data-iceapw="1" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
=SUM(A2:CHOOSE(2,A3,A4,A5))</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. 67</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b.
80</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">c. 90</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. 60</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">How
would you assign a macro to a graphic?</span></u></i></b></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="12" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="12" style="font-size: x-small;"><span data-iceapw="12" style="font-family: "Arial","sans-serif";">a. On the Developer tab, in the Code
group, click on Macros.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="2" data-iceapw="32" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="32" style="font-size: x-small;"><span data-iceapw="32" style="font-family: "Arial","sans-serif";">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.</span></span></div>
<br />
<div class="MsoNormal" data-iceapc="3" data-iceapw="31" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="31"><b data-iceapc="1" data-iceapw="31"><span data-iceapw="31" style="font-family: "Arial","sans-serif"; line-height: 115%;">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.</span></b></span></span></div>
<br />
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVXYXPHBJAhYK5wrR0EiM4CUFy-8csvZ-BeUKDMFCw8kx-mLSO5i37oel9OIj-C0UHDJIjq-f889ZaDZe_qCN1R37_JHWcAMHgpK3Cxqh4GCxFOqogyuDvSjh6CVUuPZFNNLYf2pjZkRA/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVXYXPHBJAhYK5wrR0EiM4CUFy-8csvZ-BeUKDMFCw8kx-mLSO5i37oel9OIj-C0UHDJIjq-f889ZaDZe_qCN1R37_JHWcAMHgpK3Cxqh4GCxFOqogyuDvSjh6CVUuPZFNNLYf2pjZkRA/s1600/9.png" /></a></span></div>
<span style="font-size: x-small;"><br /></span>
<div class="MsoNormal" data-iceapc="2" data-iceapw="39" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="39" style="font-size: x-small;"><span data-iceapw="39" style="font-family: "Arial","sans-serif"; line-height: 115%;">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?</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="11" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="11" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="11"><span data-iceapw="11" style="font-family: "Arial","sans-serif";"><span style="background-color: yellow;">a.
All cloned copies of that slicer are also updated instantly</span>.</span></b></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif";">b. Only the original slicer reflects
the changes being made.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="15" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="15" style="font-size: x-small;"><span data-iceapw="15" style="font-family: "Arial","sans-serif";">c. An error is displayed because no
adaptions are allowed in slicers having cloned copies.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. None of the above.</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="6" data-iceapw="28" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="28" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="16"><i data-iceapc="2" data-iceapw="16"><u data-iceapc="1" data-iceapw="16"><span data-iceapw="16" style="font-family: "Arial","sans-serif"; line-height: 115%;">State
whether the following statement regarding cell references in Microsoft Excel
2010 is true or false:<br />
</span></u></i></b><span data-iceapw="12" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
An Absolute cell reference consists of the column letter and row number.</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a.
True</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">b. False</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="6" data-iceapw="25" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="25" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="11"><i data-iceapc="2" data-iceapw="11"><u data-iceapc="1" data-iceapw="11"><span data-iceapw="11" style="font-family: "Arial","sans-serif"; line-height: 115%;">Analyze
the syntax of LOOK UP function when used in vector form?<br />
</span></u></i></b><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
LOOK UP(look up_value, look up_vector, result_vector)<br />
<br />
The values in the look up_vector must be placed in ________ order.</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a.
Ascending</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b. Descending</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Either ascending or descending</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="6" data-iceapw="32" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="32" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="15"><i data-iceapc="2" data-iceapw="15"><u data-iceapc="1" data-iceapw="15"><span data-iceapw="15" style="font-family: "Arial","sans-serif"; line-height: 115%;">State
whether following statement regarding cell references in Microsoft Excel 2010
is true or false:<br />
</span></u></i></b><span data-iceapw="17" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br />
A Relative cell reference consists of the column letter and row number
surrounded by dollar signs ($).</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. True</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">b.
False</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="6" data-iceapw="26" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" data-iceapw="26" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="8"><i data-iceapc="2" data-iceapw="8"><u data-iceapc="1" data-iceapw="8"><span data-iceapw="8" style="font-family: "Arial","sans-serif"; line-height: 115%;">State
whether the following is true or false:<br />
<br />
</span></u></i></b><span data-iceapw="18" style="font-family: "Arial","sans-serif"; line-height: 115%;">Excel Web App supports Undo/Redo but it is disabled when
multiple users are collaborating on the same workbook</span></span></div>
<div class="MsoNormal" data-iceapc="6" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="5" style="font-size: x-small;"><b data-iceapc="4"><i data-iceapc="3"><u data-iceapc="2"><span data-iceapc="1" style="font-family: "Arial","sans-serif";"><span style="text-decoration: none;"><br /></span></span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. True</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="2"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">b.
False</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below</span></u></i></b></span></div>
</div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCCh3hGev73-BdkOi9jC3ivhBE1M7ePXdXVj5ejIQ5s8GXCcs3kzItx0ncMQ8kTJlY3nEUnUvjO5UAP8U7b7MVK4yv8b80BlaDBg5rOgL9wQzoVp_7d1hXoNvjodp84WlrmzOCuWT5WM/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCCh3hGev73-BdkOi9jC3ivhBE1M7ePXdXVj5ejIQ5s8GXCcs3kzItx0ncMQ8kTJlY3nEUnUvjO5UAP8U7b7MVK4yv8b80BlaDBg5rOgL9wQzoVp_7d1hXoNvjodp84WlrmzOCuWT5WM/s1600/10.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="14" style="font-size: x-small;"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">What
does the icon marked with a red square in the figure above signify?</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif";">a. It signifies that a macro is
enabled.</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="9" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="9"><b data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif";">b.
It signifies that the document contains digital signatures.</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif";">c. It signifies that a macro is
disabled.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="9" style="font-size: x-small;"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. It signifies that a webcam has
been detected.</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="13" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="13" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="13"><i data-iceapc="2" data-iceapw="13"><u data-iceapc="1" data-iceapw="13"><span data-iceapw="13" style="font-family: "Arial","sans-serif"; line-height: 115%;">What
are the benefits of digitally signing an e-mail in Microsoft Excel 2010?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="10" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="10" style="font-size: x-small;"><span data-iceapw="10" style="font-family: "Arial","sans-serif";">a. Digital signatures help
authenticate the source of the messages.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="27" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="27" style="font-size: x-small;"><span data-iceapw="27" style="font-family: "Arial","sans-serif";">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.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="11" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="11" style="font-size: x-small;"><span data-iceapw="11" style="font-family: "Arial","sans-serif";">c. Digitally signed e-mails meet
legal requirements for admissibility and authenticity.</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="5"><b data-iceapc="1" data-iceapw="5"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">d.
All of the above.</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="14" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="14" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="14"><i data-iceapc="2" data-iceapw="14"><u data-iceapc="1" data-iceapw="14"><span data-iceapw="14" style="font-family: "Arial","sans-serif"; line-height: 115%;">What
is the filename extension of Excel workbooks which are saved as 'Excel
Templates'?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. .xlsx</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">b. .xslt</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="2" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">c.
.xltx</span></b></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. .slk</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="32" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="32" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="32"><i data-iceapc="2" data-iceapw="32"><u data-iceapc="1" data-iceapw="32"><span data-iceapw="32" style="font-family: "Arial","sans-serif"; line-height: 115%;">Slicers
are filtering components which are used to filter the data in a Pivot Table
report or CUBE functions. Which of the following data sources is/are supported
by Slicers in Microsoft Excel 2010?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="3" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="3" style="font-size: x-small;"><span data-iceapw="3" style="font-family: "Arial","sans-serif";">a. Office Database connections</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="6" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="6" style="font-size: x-small;"><span data-iceapw="6" style="font-family: "Arial","sans-serif";">b. Online Analytical Processing
(OLA) Queries</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="7" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="7"><b data-iceapc="1" data-iceapw="7"><span data-iceapw="7" style="font-family: "Arial","sans-serif";">c.
Online Analytical Processing (OLAP) Cube Files</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. All of the above</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;">This
question is based upon the figure shown below </span></u></i></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzPF7u6kRoclt-cXA20idfMLtqZSV2aL1-lRgnptTr5rzjeuJq0AJhSOhhYpjVsxa2Ny8v4jJIs3ifwep3MSdOIXDcD-HxfvqVysKGVt1kJ_QCkgE87_OXglVwbowuj6UmEBKim6hCuvA/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzPF7u6kRoclt-cXA20idfMLtqZSV2aL1-lRgnptTr5rzjeuJq0AJhSOhhYpjVsxa2Ny8v4jJIs3ifwep3MSdOIXDcD-HxfvqVysKGVt1kJ_QCkgE87_OXglVwbowuj6UmEBKim6hCuvA/s1600/11.png" /></a></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="29" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="29" style="font-size: x-small;"><span data-iceapw="29" style="font-family: "Arial","sans-serif"; line-height: 115%;">In
the screenshot above, some product sales data is given followed by a pivot
table derived from that data. Which of the following options is correct
regarding the Pivot Table?</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="15" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="15" style="font-size: x-small;"><span data-iceapw="15" style="font-family: "Arial","sans-serif";">a. The data can only be sorted
according to the 'Total for three months' field.</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="12" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="12"><b data-iceapc="1" data-iceapw="12"><span data-iceapw="12" style="font-family: "Arial","sans-serif";">b.
The data can only be sorted according to the 'Product' field.</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="21" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="21" style="font-size: x-small;"><span data-iceapw="21" style="font-family: "Arial","sans-serif";">c. The data can be sorted according
to the 'Total for three months' field, along with filtration using the
'Product' field.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">d. None of the above</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="10" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="10" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="10"><i data-iceapc="2" data-iceapw="10"><u data-iceapc="1" data-iceapw="10"><span data-iceapw="10" style="font-family: "Arial","sans-serif"; line-height: 115%;">Deleting
a Pivot Chart report automatically deletes the associated Pivot Table report.</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="2" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="2" style="font-size: x-small;"><span data-iceapw="2" style="font-family: "Arial","sans-serif";">a. True</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="2" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="2" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="2"><span data-iceapw="2" style="font-family: "Arial","sans-serif"; line-height: 115%;">b.
False</span></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="20" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="20" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="20"><i data-iceapc="2" data-iceapw="20"><u data-iceapc="1" data-iceapw="20"><span data-iceapw="20" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following components of Excel Services enables the user to edit a
published workbook inside a web browser?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif";">a. Excel Calculation Services (ECS)</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="5" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: yellow; font-size: x-small;"><span data-iceapc="2" data-iceapw="5"><b data-iceapc="1" data-iceapw="5"><span data-iceapw="5" style="font-family: "Arial","sans-serif";">b.
Excel Web Access (EWA)</span></b></span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="5" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="5" style="font-size: x-small;"><span data-iceapw="5" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Excel Web Services (EWS)</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="11" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="11" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="11"><i data-iceapc="2" data-iceapw="11"><u data-iceapc="1" data-iceapw="11"><span data-iceapw="11" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
among the following settings is the default macro security setting?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="8" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="8" style="font-size: x-small;"><span data-iceapw="8" style="font-family: "Arial","sans-serif";">a. Disable all macros except digitally
signed macros.</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="6" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="6" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="6"><span data-iceapw="6" style="font-family: "Arial","sans-serif";">b.
Disable all macros with notification.</span></b></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="4" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="4" style="font-size: x-small;"><span data-iceapw="4" style="font-family: "Arial","sans-serif"; line-height: 115%;">c. Enable all macros.</span></span></div>
<div class="MsoNormal" data-iceapc="1" style="margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="16" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="16" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="16"><i data-iceapc="2" data-iceapw="16"><u data-iceapc="1" data-iceapw="16"><span data-iceapw="16" style="font-family: "Arial","sans-serif"; line-height: 115%;">Which
of the following statements is not true regarding offline cube files in
Microsoft Excel 2010?</span></u></i></b></span></div>
<div class="MsoNormal" data-iceapc="1" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="14" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="14" style="font-size: x-small;"><span data-iceapw="14" style="font-family: "Arial","sans-serif";">a. An offline cube file stores data
in the form of an OLAF cube.</span></span></div>
<div class="MsoNormal" data-iceapc="2" data-iceapw="23" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="1" data-iceapw="23" style="font-size: x-small;"><span data-iceapw="23" style="font-family: "Arial","sans-serif";">b. If you delete the offline cube
file for the report, still you can create a new offline cube file for the
report.</span></span></div>
<div class="MsoNormal" data-iceapc="3" data-iceapw="20" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="2" data-iceapw="20" style="font-size: x-small;"><b data-iceapc="1" data-iceapw="20"><span data-iceapw="20" style="font-family: "Arial","sans-serif"; line-height: 115%;"><span style="background-color: yellow;">c.
An offline cube file allows you to work with PivotTable and PivotChart reports
even when the server is unavailable</span>.</span></b></span></div>
<div class="MsoNormal" data-iceapc="5" data-iceapw="9" style="margin-bottom: 0.0001pt; text-align: justify;">
<span data-iceapc="4" data-iceapw="9" style="font-size: x-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
<span data-iceapc="4" data-iceapw="9" style="font-size: xx-small;"><b data-iceapc="3" data-iceapw="9"><i data-iceapc="2" data-iceapw="9"><u data-iceapc="1" data-iceapw="9"><span data-iceapw="9" style="font-family: "Arial","sans-serif"; line-height: 115%;"><br /></span></u></i></b></span></div>
</div>
</div>
</div>
</div>
<span data-iceapc="5" style="font-size: xx-small;"><span data-iceapc="4"><b data-iceapc="3"><i data-iceapc="2"><u data-iceapc="1"><span style="line-height: 115%;"></span></u></i></b></span></span></div>
</div>

Odesk Microsoft Excel 2010 Test answers 2014

Odesk Microsoft Excel 2010 Test answers and 100% pass Odesk Microsoft Excel 2010 Test Which of the following statements is no...

আরও পড়ুন »