InterviewSolution
Saved Bookmarks
| 1. |
What is meant by conditional formatting? Give its two uses and three benefits. |
|
Answer» Solution :A format CHANGE, such as background cell shading or font colour that is applied to a cell when a specified CONDITION for the data in the cell is true. Conditional formattingis often applied to worksheets to FIND: a. Data that is above or below a certain value. Duplicate data values. b. Cells containing specific text. Data that is above or below AVERAGE. c. Data that falls in the top ten or bottom ten values. Benefits of using conditionalformatting: i) Helps in answering questions which are important for taking decisions. ii) Guides with help of using visuals. iii) Helps in understanding DISTRIBUTION and variation of critical data. |
|