adspace


discuss the conditional formatting and advanced filtering features in MS-Excel with suitable example

Answer Posted / Baldau Lal Srivastava

Conditional Formatting is a feature in Microsoft Excel that allows you to highlight or modify cells based on their value, formula, or data bar. For example, you can set up a rule to color cells containing values above a specific threshold red. Advanced Filtering, on the other hand, enables you to filter and sort data quickly. A common example is using advanced filtering to display only records that meet certain criteria such as dates within a specific range or values from a selected dropdown list.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anybody send me the technical papers of hewitt associates pls...I cleared aps n GD n has only less time for technical round?

2287


Hi dost here Alok Kumar please send question pattern for NIC at godinall.kumar1@gmail.com or alok.iitb07@gmail.com

1950


why c is called middle level langauge?

2111


can u give me the information about the questions asked by the bally in campus

1957


i need NIC written test paper or give me any idea about written exam.Plz send me at smileever8@gmail.com

2352


Hi, I am appearing for the ISRO exam for the post of Scientist/ Engineer to be held on 26th April,09. Can anyone help me regarding the same? I want to know about the exam pattern and the syllabus. If anyone could share your experience or sample papers for the same at khadhar786@rediffmail.com? It would be very useful for me. Thanks.

2209


who is your role modal give in few sentances

2230


plz send me interview questions & answers of Data Structure

2117


Hi All... PLease send me if anyone have "Information Security Officer" Aptitude papers. Please Mail me at mannusanghi@gmail.com

1935


Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click.

2131


Please send me Sample papers National Informatics Centre (NIC) Programmer. I am giving this paper first time..so if any one have previous question papers send to manoj200.yadav@gmail.com. thnx in advance

2040


what is the different between view and materialized view in oracle DBA?

1752


What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.

2508


BEL old probationary engineering questions and answers

5318


hi, please send me "state bank of india", last 5 years question paper with answers to my mail id.

2147