Question

Your next task is to sort and filter data in the Art worksheet.

Display the Art worksheet. In cell A17, insert a SORT function with a nested FILTER function. The nested FILTER function uses data in the range A2:H11 where the range H2:H11 is less than the value in cell H15 ($15,000). The results are then sorted in alphabetical order by last name.

Answer 1

The student is directed to insert a formula in cell A17 that uses the SORT function nested with the FILTER function to display data in the Art worksheet sorted alphabetically by last name where values are less than $15,000.

Step-by-step explanation:

The question involves using spreadsheet software to manipulate data, specifically using the SORT and FILTER functions within an Art worksheet. In order to achieve the task of sorting and filtering the data, the student should insert a formula in cell A17 that filters the data range A2:H11. The criteria for filtering is that the values in range H2:H11 must be less than the value in cell H15, which is $15,000. Then, the resulting filtered data should be sorted in alphabetical order by the last name, which is assumed to be one of the columns within the range A2:H11.

To implement this, the formula would resemble the following structure: =SORT(FILTER(A2:H11, H2:H11 < H15), [column_number_of_last_name], TRUE). In this formula, '[column_number_of_last_name]' should be replaced with the actual column number where the last names are located. The TRUE argument indicates that the sort order should be ascending, which corresponds to alphabetical order.