DATABASE FUNDAMENTALS
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.
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.