IITM

Add New Topic

Chapter Details

Select Subject

Display Order

Topic Title

Content Details

<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">Filter: -Here filter
means display the records conditionally. There are two types filter used in
MS-Excel: -<o:p></o:p>Ã˜ Auto Filter<o:p></o:p>Ã˜ Advanced
Filter<o:p></o:p>Auto Filter:
-It is a part
of filter method when you use the auto filter then a combo box will come out of
selected data range then you select any one particular record.<o:p></o:p>Process: -<o:p></o:p>Ã˜
Select your
data range<o:p></o:p>Ã˜
Click on
data tab<o:p></o:p>

Click on filter Advance filter: - It is also
part of filter this command is used for filtering the condition out of data
range.<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" width="384" style="width: 4in; margin-left: 6.75pt; margin-right: 6.75pt;">
 <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-width: 1pt; border-style: solid; border-color: windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">ROLL</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">NAME</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">PHY</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">CHE</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">MATH</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">TOTAL</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:1;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">1</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">RAJ</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">78</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">87</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">67</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">232</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:2;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">2</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">SOHAN</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">45</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">87</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">78</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">210</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:3;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">3</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">JILANI</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">67</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">98</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">98</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">263</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:4;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">4</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">AMIT</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">89</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">76</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">45</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">210</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:5;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">5</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">IRSHAD</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">67</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">56</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">67</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">190</blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:6;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">MATH </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 </tr>
 <tr style="mso-yfti-irow:7;mso-yfti-lastrow:yes;height:15.0pt">
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> >=80</blockquote></blockquote>
 </td>
 <td width="64" nowrap="" valign="bottom" style="width: 48pt; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;">
 <blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote></blockquote>
 </td>
 </tr>
</tbody></table> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">Ã¼ Create a
condition out of data range<o:p></o:p>

Ã¼ <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter">
 <v:formulas>
 <v:f eqn="if lineDrawn pixelLineWidth 0">
 <v:f eqn="sum @0 1 0">
 <v:f eqn="sum 0 0 @1">
 <v:f eqn="prod @2 1 2">
 <v:f eqn="prod @3 21600 pixelWidth">
 <v:f eqn="prod @3 21600 pixelHeight">
 <v:f eqn="sum @0 0 1">
 <v:f eqn="prod @6 1 2">
 <v:f eqn="prod @7 21600 pixelWidth">
 <v:f eqn="sum @8 21600 0">
 <v:f eqn="prod @7 21600 pixelHeight">
 <v:f eqn="sum @10 21600 0">
 </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect">
 <o:lock v:ext="edit" aspectratio="t">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_12" o:spid="_x0000_s1026" type="#_x0000_t75" style="position:absolute;left:0;text-align:left;margin-left:305.25pt;
 margin-top:4.05pt;width:172.5pt;height:177.75pt;z-index:251730944;
 visibility:visible;mso-wrap-style:square;mso-wrap-distance-left:9pt;
 mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;
 mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;
 mso-position-horizontal-relative:text;mso-position-vertical:absolute;
 mso-position-vertical-relative:text" strokeweight="3e-5mm">
 <v:imagedata src="file:///C:\Users\ICA\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title="" croptop="10923f" cropbottom="34389f" cropleft="17536f" cropright="33280f">
 <w:wrap type="square">
</w:wrap></v:imagedata></v:shape>Select your
data range<o:p></o:p>

Ã¼ Click on
advance<o:p></o:p>

<span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:
minor-latin;mso-hansi-theme-font:major-latin;mso-bidi-font-family:Mangal;
mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">Then a dialog box open </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:
minor-latin;mso-hansi-theme-font:major-latin;mso-bidi-font-family:Mangal;
mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA"><img src="https://i.imgur.com/b1Leroo.jpg" width="237"> </blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:
minor-latin;mso-hansi-theme-font:major-latin;mso-bidi-font-family:Mangal;
mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">List range: -It means data range<o:p></o:p>

Criteria range: -It means condition cell address<o:p></o:p>

Copy to: -It means result cell address<o:p></o:p>

Ã¼
Check copy
to another location<o:p></o:p>

Ã¼ Click on Ok<o:p></o:p>Text to
columns: -It
is used to split the data in one cell into separate columns.<o:p></o:p>Process: -<o:p></o:p>Ã¼ Select your
cell<o:p></o:p>Ã¼ Click on
data tab<o:p></o:p>Ã¼ Click on
text to columns<o:p></o:p>Ã¼ Check
delimited option<o:p></o:p>Ã¼ Click on
next<o:p></o:p>Ã¼ Check any
option (Like: -Comma, Semicolon, Space etc)<o:p></o:p>Ã¼ Click on
next<o:p></o:p>Ã¼ Click on
finish<o:p></o:p> Validation:
-MS-Excel
provides the features of validation which used to specify as user need
condition on selected cells and also given message after specified the
condition when the user enter as your required data and the enter data does not
satisfied your specified condition then ignore and display message.Process: -<o:p></o:p>Ã¼ <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter">
 <v:formulas>
 <v:f eqn="if lineDrawn pixelLineWidth 0">
 <v:f eqn="sum @0 1 0">
 <v:f eqn="sum 0 0 @1">
 <v:f eqn="prod @2 1 2">
 <v:f eqn="prod @3 21600 pixelWidth">
 <v:f eqn="prod @3 21600 pixelHeight">
 <v:f eqn="sum @0 0 1">
 <v:f eqn="prod @6 1 2">
 <v:f eqn="prod @7 21600 pixelWidth">
 <v:f eqn="sum @8 21600 0">
 <v:f eqn="prod @7 21600 pixelHeight">
 <v:f eqn="sum @10 21600 0">
 </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect">
 <o:lock v:ext="edit" aspectratio="t">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_11" o:spid="_x0000_s1026" type="#_x0000_t75" style="position:absolute;left:0;text-align:left;margin-left:198pt;
 margin-top:7.15pt;width:309pt;height:175.5pt;z-index:251732992;visibility:visible;
 mso-wrap-style:square;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;
 mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;
 mso-position-horizontal:absolute;mso-position-horizontal-relative:text;
 mso-position-vertical:absolute;mso-position-vertical-relative:text" strokeweight="3e-5mm">
 <v:imagedata src="file:///C:\Users\ICA\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title="" croptop="7595f" cropbottom="30976f" cropleft="12224f" cropright="28032f">
 <w:wrap type="through">
</w:wrap></v:imagedata></v:shape>Select your
cell range<o:p></o:p>Ã¼ Click on
data tab<o:p></o:p>Ã¼ Click on
validation<o:p></o:p>Ã¼ Then a
dialog box open<o:p></o:p>Ã¼ Click on
setting tab<o:p></o:p>

Ã¼ Click on
allow drop down list and select whole number<o:p></o:p><img src="https://i.imgur.com/FFRQWC0.jpg" width="400"> Ã¼ Enter
minimum and maximum value<o:p></o:p>Ã¼ Click on
error alert tab and enter message (Please enter your value >=80
&<=30)<o:p></o:p>Ã¼ Click on ok<o:p></o:p>Goal Seek: -It is an
analysis of MS-Excel which used to modify the value of precedents cell that
increase or decrease with current row single cell.<o:p></o:p>Process: -<o:p></o:p>Ã¼ Select your
precedents cell value<o:p></o:p>Ã¼ Click on
data tab<o:p></o:p>Ã¼ Click on
what if analysis<o:p></o:p>Ã¼ Click on
goal seek<o:p></o:p>

Then a dialog box open <img src="https://i.imgur.com/tnxnYf8.jpg" width="217"> Set cell: -It means
enter that cell address which you have to modify.<o:p></o:p>To value: -It means
target cell address.<o:p></o:p>By changing
cell: -It
means that cell address which you have to share the value.<o:p></o:p>Ã¼ Click on ok<o:p></o:p>Ã¼ Again click
on ok<o:p></o:p>Scenario: -It is an
analysis of MS-Excel which used to modify the value of depending cell and final
change to precedents cell.<o:p></o:p>Process: -<o:p></o:p>Ã¼ Select your
data range which you have to modify<o:p></o:p>Ã¼ Click on
data tab<o:p></o:p>Ã¼ <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter">
 <v:formulas>
 <v:f eqn="if lineDrawn pixelLineWidth 0">
 <v:f eqn="sum @0 1 0">
 <v:f eqn="sum 0 0 @1">
 <v:f eqn="prod @2 1 2">
 <v:f eqn="prod @3 21600 pixelWidth">
 <v:f eqn="prod @3 21600 pixelHeight">
 <v:f eqn="sum @0 0 1">
 <v:f eqn="prod @6 1 2">
 <v:f eqn="prod @7 21600 pixelWidth">
 <v:f eqn="sum @8 21600 0">
 <v:f eqn="prod @7 21600 pixelHeight">
 <v:f eqn="sum @10 21600 0">
 </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect">
 <o:lock v:ext="edit" aspectratio="t">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_9" o:spid="_x0000_s1026" type="#_x0000_t75" style="position:absolute;left:0;text-align:left;margin-left:253.5pt;
 margin-top:15.2pt;width:234.75pt;height:125.25pt;z-index:251677696;
 visibility:visible;mso-wrap-style:square;mso-wrap-distance-left:9pt;
 mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;
 mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;
 mso-position-horizontal-relative:text;mso-position-vertical:absolute;
 mso-position-vertical-relative:text" strokeweight="3e-5mm">
 <v:imagedata src="file:///C:\Users\ICA\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title="" croptop="13909f" cropbottom="37376f" cropleft="14848f" cropright="30656f">
 <w:wrap type="square">
</w:wrap></v:imagedata></v:shape>Click on
what if analysis<o:p></o:p>Ã¼ Click on
scenario<o:p></o:p>Ã¼ Click on add
button<o:p></o:p>Ã¼ Enter any
name<o:p></o:p>Ã¼ Click on ok<o:p></o:p>

Ã¼ Modify the
value of selected cells<o:p></o:p><img src="https://i.imgur.com/WdwkzxW.jpg" width="316"> Ã¼ Click on ok<o:p></o:p>Ã¼ Click on
show<o:p></o:p><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter">
 <v:formulas>
 <v:f eqn="if lineDrawn pixelLineWidth 0">
 <v:f eqn="sum @0 1 0">
 <v:f eqn="sum 0 0 @1">
 <v:f eqn="prod @2 1 2">
 <v:f eqn="prod @3 21600 pixelWidth">
 <v:f eqn="prod @3 21600 pixelHeight">
 <v:f eqn="sum @0 0 1">
 <v:f eqn="prod @6 1 2">
 <v:f eqn="prod @7 21600 pixelWidth">
 <v:f eqn="sum @8 21600 0">
 <v:f eqn="prod @7 21600 pixelHeight">
 <v:f eqn="sum @10 21600 0">
 </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect">
 <o:lock v:ext="edit" aspectratio="t">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_10" o:spid="_x0000_s1026" type="#_x0000_t75" style="position:absolute;left:0;text-align:left;margin-left:333pt;
 margin-top:33.45pt;width:182.25pt;height:3in;z-index:251678720;visibility:visible;
 mso-wrap-style:square;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;
 mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;
 mso-position-horizontal:absolute;mso-position-horizontal-relative:text;
 mso-position-vertical:absolute;mso-position-vertical-relative:text" strokeweight="3e-5mm">
 <v:imagedata src="file:///C:\Users\ICA\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title="" croptop="6912f" cropbottom="30293f" cropleft="16704f" cropright="32320f">
 <w:wrap type="square">
</w:wrap></v:imagedata></v:shape>Subtotal: -MS-Excel provides the feature of
subtotal which used to calculate subtotal and grand total value according to
control field to generate subtotal of numeric field the record must be sorted
on ascending or descending.<o:p></o:p>Process: -<o:p></o:p>Ã¼ First sort
your data in ascending or descending order<o:p></o:p>Ã¼ Click on
data tab<o:p></o:p>Ã¼ Click on
subtotal<o:p></o:p>

Ã¼ Then a
dialog box open<o:p></o:p><img src="https://i.imgur.com/6u4FCyD.jpg" width="268"> Ã¼ Select as
your required field from at each change in drop down list<o:p></o:p>Ã¼ Select as
your required function<o:p></o:p>Ã¼ Check as
your required numeric field<o:p></o:p>

Click on ok</blockquote>

Your order is placed

James Lemire

Your item is shipped

Salena Layfield

Add New Topic

Short Key List