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 |
. 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?
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?
. 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
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
Three days and Three Nights Do Not Equal 72 Hours
What have you done to improve or develop your knowledge / professional qualifications in the last year?
different types of protocols.......?
How to work Air cooled and water cooled chiller?
why u r shifting from engineering to other field ?
which field is comparitively very best , today and in future while considering the following : ELECTRONICS [OR] NETWORKING
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?
Do you have any tips for using 3G phones?
Civil Engineering (5086)
Mechanical Engineering (4453)
Electrical Engineering (16638)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)