DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which conditional formatting feature can be used to identify duplicate values on a worksheet?
|
|
Data Bars
|
|
|
Highlight Cell Rules
|
|
|
Top / Bottom Rules
|
|
|
Color Scales
|
Explanation:
Detailed explanation-1: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Point to Highlight Cells Rules, and then click Duplicate Values. Next to values in the selected range, click unique or duplicate.
Detailed explanation-2: -Here, we are using conditional formatting to highlight the duplicate values. The function in use is COUNTIF. The COUNTIF function counts the occurrence of each value in the range. If a value exists more than once, COUNTIF returns TRUE and invokes the formatting rule. .
There is 1 question to complete.