A Sociologist Wants to Know What Percent of a Town's

Multiple Choice

A sociologist wants to know what percent of a town's population earns between $50,000 and $100,000 annually.He obtains an Excel sheet with income information for the town's population from the U.S Census Bureau.If he uses the Custom Filter function,which of the following values and Boolean operators must he enter and select respectively to obtain the required information?

A) "Greater Than" $50,000 or "Lesser Than" $100,000
B) "Lesser Than" $50,000 or "Greater Than" $100,000
C) "Greater Than" $50,000 and "Lesser Than" $100,000
D) "Lesser Than" $50,000 and "Greater Than" $100,000