DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
filtered
|
|
|
conditional
|
|
|
calculated
|
|
|
None of the above
|
Detailed explanation-1: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
Detailed explanation-2: -Conditional format A format that changes the appearance of a cell-for example, by adding cell shading or font color-based on a condition; if the condition is true, the cell is formatted based on that condition; if the condition is false, the cell is not formatted.
Detailed explanation-3: -The Stop If True option in conditional formatting prevents Excel from processing other rules when a condition in the current rule is met. In other words, if two or more rules are set for the same cell and Stop if True is enabled for the first rule, the subsequent rules are disregarded after the first rule is activated.