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



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

Answer / 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

More Engineering AllOther Interview Questions

. There are two water tanks A and B, A is much smaller than B. While water fills at the rate of 1 liter every hour in A, it gets filled up like, 10, 20, 40,80, 160…..in tank B. (At the end of first hour, B has 10 liters, second hour it has 20 liters and so on). If tank B is 1/32 filled of the 21 hours, what is total duration of hours required to fill it completely?

3 Answers   TCS,


a tap can fill the empty tank in 12 hours , but due to a leak in the bottom it is filled in 15 hours. If the tank is full then tap A is closed then in how many hours the leak can empty it?

3 Answers   Mind Tree,


. Give the C language equivalents of the following a)Function returning an int pointer b)Function pointer returning an int pointer c)Function pointer returning an array of integers d)Array of function pointer returning an array of integers

1 Answers   Geometric Software,


I need to know the process to add 100 tapes in ATL. Ho to inicialize them to the system? How is all the process i need to follow> Thanks

1 Answers   EDS,


Three days and Three Nights Do Not Equal 72 Hours

6 Answers   Qiscet,


What have you done to improve or develop your knowledge / professional qualifications in the last year?

0 Answers  


different types of protocols.......?

1 Answers  


How to work Air cooled and water cooled chiller?

1 Answers  


why u r shifting from engineering to other field ?

0 Answers   HSBC,


which field is comparitively very best , today and in future while considering the following : ELECTRONICS [OR] NETWORKING

1 Answers   MTS,


I am having 17 months experience in development.I want to take testing as my career.I dont have experience in testing. Will get job anywhere?

1 Answers  


Do you have any tips for using 3G phones?

1 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4453)
  • Electrical Engineering Interview Questions Electrical Engineering (16638)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)