In cell J7, use a FILTER function to retrieve all records in the range A4:G28 that are in the D.C. area, with a rank of no higher than 50, and with an average check of less than $100.00. Use the cells in K1:K3 to reference the criteria