USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
X
|
|
|
X
|
Detailed explanation-1: -While applying the formatting, excel checks the precedence order and then it applies the rules accordingly. To check the precedence order, go to conditional formatting and select the option of Manage Rules.
Detailed explanation-2: -Each cell has several conditional formatting rules. The order is critical since the format stops at the first rule that’s true. For example is less than 0, red, if cell A <>B, bold, etc. When copy/paste the group of cells with cond’format, the rule order changes and therefore the result changes.
Detailed explanation-3: -we can apply Font, border, and pattern formats that meet the specified conditions. we can delete any condition from the Conditional Formatting dialog box if it is not required. The correct answer is option B i.e. You can set conditions to look for Bold and apply Italics on them.
Detailed explanation-4: -Solution(By Examveda Team) In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.