Question

Explain any three advantages of conditional formatting in Computerised Accounting System.

Hint:

Name three benefits of conditional formatting: quick data analysis, improved accuracy and better decision making. Explain each in two lines.

Answer 1

Step 1: Understand conditional formatting:
Conditional formatting is a spreadsheet feature in a Computerised Accounting System. It changes the look of a cell, such as its colour, font or border, when the value in the cell meets a condition set by the user.
The question asks for any three advantages, so we explain exactly three points, one mark each.

Step 2: Advantage 1: Quick data analysis:
The rule highlights unusual values, such as very high expenses or very low balances, in a different colour.
Data bars and colour scales make a long list of figures look like a picture. The accountant spots the important figures at a glance instead of reading every row.

Step 3: Advantage 2: Improves accuracy:
The format changes by itself when the condition is met, so the user does not colour cells by hand.
This cuts manual errors. For example, a debtor balance above the credit limit turns red and cannot be missed.

Step 4: Advantage 3: Helps in better decision making:
When the data is shown clearly and in detail, the management reads the position of the business faster.
So decisions on collection of dues, payment to creditors or control of costs are taken on time and on the right facts.

Final Answer:
Three advantages of conditional formatting are quick data analysis, improved accuracy and better decision making. Each carries one mark, so the answer earns 3 marks in all.