Q21 Museum photograph spreadsheet

Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet.

(B) Filter by photographer then year then sort by year

Filtering by photographer will remove any entries with unknown photographers. Filtering by year will remove any entries with unknown years. Sorting by year will sort the remaining entries in column C from least to greatest, putting the photograph with the lowest year value in the first row of the spreadsheet.

Q23 Radio Show Spreadsheet

A student wants to count the number of shows that meet both of the following criteria.

Is a talk show Is on Saturday or Sunday For a given row in the spreadsheet, suppose genre contains the genre as a string and day contains the day as a string. Which of the following expressions will evaluate to true if the show should be counted and evaluates to false otherwise?

(B) (genre = "talk") AND ((day = "Saturday") OR (day = "Sunday"))

Correct. For a show to be counted, the value of genre must be "talk" and the value of day must be "Saturday" or "Sunday".