Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. Which of the following sequences of steps can be used to identify the desired entry? Select two answers.
– Filter by photographer, then filter by year, then sort by subject
– Filter by photographer, then filter by year, then sort by year
– Sort by subject, then sort by year, then filter by photographer
– Sort by year, then filter by year, then filter by photographer
To identify the desired entry while ensuring the steps maintain the order of the rows, the correct sequences would be:
1. Filter by photographer, then filter by year, then sort by subject
2. Filter by photographer, then filter by year, then sort by year
### Explanation:
– Filtering helps narrow down the dataset to only relevant entries based on chosen criteria without altering their order.
– Sorting can be performed after filtering to organize the remaining entries. Sorting after filtering keeps the context of the filtered data intact, allowing you to easily locate specific entries based on the new arrangement.
Choose these sequences to maintain an organized and logical approach to finding the desired entry! If you have more questions or need further assistance, feel free to ask!