USING MICROSOFT EXCEL
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: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.
Detailed explanation-3: -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.