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: -Change a conditional formatting rule On the Home tab, click Conditional Formatting. Click Manage Rules. Select the rule, and then click Edit Rule. Make the changes that you want, click OK, and then click OK again.
Detailed explanation-2: -To create the first rule: On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.
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.