CBSE 2025, Set 2

Question

List any six questions which are often asked when a user wants to be benefited by conditional formatting. Also state how colour scale is used to format cells.

Edvaya · Accepted Answer

The correct answer is Subjective. Following are the questions which are often asked by the users to get benefit of conditional formatting: 1. Where are the exceptions in a summary of data over the past five years. 2. What is the trend in data over the past two years. 3. Who is responsible for such results during this month. 4. What is the overall distribution of data. 5. If it is a product related table then which product or company performed best lately. 6. Highest and lowest performing product. Conditional formatting helps to answer these questions by making it easy to highlight interesting cells or ranges of cells, emphasize unusual values and visualize data by using data bars, color scales and icon sets. **Color scales** are visual guides that help in understanding data distribution and their variation. A color scale helps the user to compare a range of cells by using a gradation of different colours. The shades of the colour represent higher or lower values.

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Accountancy > Computerised Accounting > Accounting Application Of Electronic Spreadsheet

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy