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

Question

Quizplus · Accepted Answer

Selecting "Greater Than" $50,000 or "Lesser Than" $100,000,would give the sociologist the population of people whose income was between $50,000 and $100,000.

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