The Top$-$Indie worksheet contains a sample data set of the top $100$ independently owned restaurants, based on a recent analysis. In cell J$7,$ use a FILTER function to retrieve all records in the range A$4$:G$28$ that are in the D$.$C$.$ area, with a rank of no higher than $50,$ and with an average check of less than $$100\mathrm{.}00.$ Use the cells in $K1$:$K3$ to reference the criteria.

Hint:

Place each criterion in parentheses and use the $*$ to indicate that all three conditions must be met.