Filter the data in place so that only rows where the category value is meals and the cost value is greater than 20 are shown. the criteria range has been set up for you in cells a1:c2.

The following cost data pertain to the operations of montgomery department stores, inc., for the month of july. corporate legal office salaries $ 75,300apparel department cost of sales"evendale store $ 97,200corporate headquarters building lease $ 50,300store manager's salary"evendale store $ 12,900apparel department sales commission"evendale store $ 11,550store utilities"evendale store $ 12,800apparel department manager's salary"evendale store $ 10,450central warehouse lease cost $ 18,600janitorial costs"evendale store $ 11,800 the evendale store is just one of many stores owned and operated by the company. the apparel department is one of many departments at the evendale store. the central warehouse serves all of the company's stores. required: 1. what is the total amount of the costs listed above that are direct costs of the apparel department? 2. what is the total amount of the costs listed above that are direct costs of the evendale store? 3. what is the total amount of the apparel department's direct costs that are also variable costs with respect to total departmental sales?