In an Excel worksheet, the sales statistics of commodities are stored. I want to use the "filtering" function to select all commodities with a sales volume of not less than 5000 and a sales volume of less than 2000. The filtering conditions should be_______
A. "greater than 5000" and "less than 2000"
B. "greater than or equal to 5000" and "less than 2000 "
C. "greater than or equal to 5000" or "less than 2000"
D. "greater than 5000" or "less than or equal to 2000"
Answer:C
In an Excel worksheet, the sales statistics of commodities are stored. I want to use the "filtering" function to select all commodities with a sales volume of not less than 5000 and a sales volume of less than 2000. The filtering conditions should be_______
A. "greater than 5000" and "less than 2000" B. "greater than or equal to 5000" and "less than 2000 " C. "greater than or equal to 5000" or "less than 2000" D. "greater than 5000" or "less than or equal to 2000"