USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell Value
|
|
|
Formula
|
|
|
Both of the above
|
|
|
None of the above
|
Detailed explanation-1: -Option-C is correct that is You can check the conditions against both cell value and formula when applying conditional formatting.
Detailed explanation-2: -You can check the conditions against when applying conditional formatting.
Detailed explanation-3: -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-4: -To see which cells of a worksheet have conditional formatting rules, possibly to investigate why they aren’t working as you expect, click the Find & Select button on the HOME tab, and then click Conditional Formatting. The cells that have conditional formatting rules are selected.