Pre-built conditional formatting rules do NOT include:

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A	Sparklines
B	Icon Sets
C	Data Bars
D	Color Scales

Explanation:

Detailed explanation-1: -You cannot use Conditional Formatting when you are in Group Mode. To ungroup worksheets, click on the tab of a sheet that’s not in the group. This will immediately takes you out of group mode. If all the sheets in the workbook are grouped together, right-click on any of the grouped sheet tabs and click Ungroup Sheets.

Detailed explanation-2: -Solution(By Examveda Team) In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Detailed explanation-3: -So, if the rule is not working, go to Conditional Formatting > Manage Rules and check both the formula and the range it applies to. If you have copied the formula from the web or some other external source, make sure the straight quotes are used.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL