Question

Sam is a data analyst at an advertising firm. He often uses a spreadsheet that contains media ratings details. He would like to filter the spreadsheet data based on different filter criteria. Which operators can he use to specify the combination of filter criteria?

Sam can use the ( blank ) operators to specify a combination of filter criteria.

Answer 1

Boolean

Step-by-step explanation:

Logical Operators are sometimes refered to as Boolean.

Answer 2

Answer: Logical Operators.

Logical Operators are a type of operator that compares the values of data.

Examples of these operators are:

AND

The AND operator would give the value if BOTH of the values are TRUE.

IF FirstName = John AND Age = 25.

This will return all the records that both have a first name of "JOHN" and are 25 years of age.

OR

The OR operator would give the value if any ONE of the values are TRUE.

IF FirstName = John OR Age = 25.

This will return all the records that have a first name of "JOHN" and also all records that are 25 years of age.

XOR

The XOR operator would give the value if ONE and only ONE of values is TRUE.

IF FirstName = JOHN XOR Age = 25.

This will return all the records that have the first name of "JOHN" and also all the records that have 25 years of age. But it will not return the record if JOHN and 25 years of age are both TRUE.

NOT

The NOT operator would give the value if it is NOT one of the values.

IF FirstName NOT JOHN.

This will return all the records with the name that is not "JOHN".