Question

2. The Highlight Cell Rules sub-menu of the Conditional Formatting drop-down
menu does not contain: *
○Between...
○Equal to...
○Among..
○Less Than...​

Answer 1

Answer:

Among is the correct answer

Answer 2

The correct answer is OPTION C: Among.

• Users can format cells that fulfill one or more criteria using Excel's Highlight Cells Rules.
• These conditions work with numeric values like greater than, between, dates like occurrence dates, and text values like contains the text.
• Highlighting cells with duplicate values can also be done with the Highlight Cells Rules.
• Highlight Cells is a conditional formatting option in the Excel Conditional Formatting menu, which can be found in the Styles category of the Home tab on the Excel ribbon.
• When one of the first six Highlight Cells Rules is selected, such as 'Greater Than, Less Than, Between, Equal To, Text That Contains, or A Date Occurring,' a dialogue box appears, allowing us to enter a value or a cell reference to compare each cell's value too.