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.

Logical operators (AND, OR, XOR, and NOT).

If the data that is required to be filtered requires complex criteria, you can click on the Advanced Filter dialog box in the Data tab in Excel. Under the advanced dialog box is where you can use logical operators to specify the combination of filter criteria. When these logical operators’ arguments are evaluated, they return either true or false. For instance, the OR operator returns TRUE if any arguments evaluate to TRUE

answer; i believe the correct answer is 50 pounds;

solution:

the right option is a

to adding   a new row to a table we   have to do process last table cell and pressing tab.

this is the process to add new row in the cell:

* to add a row below the cell, click insert below in the rows and columns group.

thus this is the required right answer.