Question

What is meant by 'conditional formatting'? State its any three advantages.

Accepted Answer

A conditional format changes the appearance of a cell range based on a condition. If the condition is true, the cell range is formatted based on that condition. If the condition is false, the cell range is not formatted based on that condition. The advantages of conditional formatting (any three). It is helpful: (i) –To find out exceptions for the given period. (ii) –To find Trend. (iii) –To fix the responsibility for the results. (iv) –To find age distribution of employees. (v) –To find peak performance. (vi) –To highlight unusual values and visualise data by using data bar, colour scale, icons, etc. Or Q. (b) State any four salient……………………………. Ans. Any four (i) CAS may be designed to automate and integrate all the business operations which inturn helps to simplify all the business processes easily. (ii) It provides sufficient time to plan, increases data accessibility and enhances user satisfaction which will lead to greater transparency and control over business operations. (iii) It provides user-definable templates for speedy and accurate data entry of the transactions. (iv) It enables business to be able to change the volume of data processing in tune with the change in the size of operation hence facilitates scalability. (v) It makes sure that the generalised critical financial information is accurate, controlled and secure which makes it reliable.

Marking-scheme solution

More from Spreadsheet