Multiple Choice
Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below.
-If Robert wanted to find all records with the value IL in the State field, he would click State in the Column to filter list box, click the State list arrow, and then click ____. Click the list arrow for the second list box, and then select IL.
A) equals
B) find
C) IL
D) search
Correct Answer:

Verified
Correct Answer:
Verified
Q101: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Julie is
Q102: When data is in a comma-delimited form,
Q103: The START function returns the starting position
Q104: The SEARCH function finds one text string
Q105: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Julie is
Q107: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Robert has
Q108: If you want to sort by more
Q109: The Subtotal command works with _ calculation(s)
Q110: When working with an Excel table, you
Q111: A PivotChart report represents source data as