(2) Click Data-Filter-Auto Filter in the menu bar.
(3)
Click the "Inverted Triangle" button in the lower right corner of the cell where TV A data is located, and select "Custom" in the pop-up list box.
The "Custom Automatic Filtering Method" dialog box pops up. In the text box under "TV A", select "less than", fill in "2780" in the text box next to it, and click OK.
(4) Click the "Inverted Triangle" button in the lower right corner of the cell where TV B data is located, and select "Custom" in the pop-up list box to pop up the "Custom Automatic Filtering Method" dialog box. Select "less than" in the text box under "TV B", fill in "3250" in the text box next to it, and click OK.
Ok, just screen out all the records that the price of TV A is less than 2780 yuan and the price of TV B is less than 3250 yuan.