Question

Which of the following allows you to add duplicate entry in worksheets

Answer 1

Explanation:

Select the range of cells in the worksheet where you want duplicates formatted in a special way. Click the Conditional Formatting button in the Styles group of the Home tab of the Ribbon; then choose Highlight Cell Rules→Duplicate Values from the drop-down menu.