Select the best answer for the question.

\begin{tabular}{|c|c|c|}
\hline City & State & Sales \\
\hline Jacksonville & Florida & [tex]$\$[/tex] 212,048[tex]$ \\
\hline Charlotte & North Carolina & $[/tex]\[tex]$ 109,341$[/tex] \\
\hline Memphis & Tennessee & [tex]$\$[/tex] 204,010[tex]$ \\
\hline Washington & District of Columbia & $[/tex]\[tex]$ 221,873$[/tex] \\
\hline Nashville & Tennessee & [tex]$\$[/tex] 138,453[tex]$ \\
\hline Baltimore & Maryland & $[/tex]\[tex]$ 82,742$[/tex] \\
\hline
\end{tabular}

If you wanted to only view the sales of more than [tex]$\$[/tex] 200,000$ in the table above, which number filter would you select?

A. Equal, and then 200,000
B. Greater Than, and then 200,000
C. Greater Than Or Equal To, and then 200,000
D. Does Not Equal, and then 200,000



Answer :

To solve the problem, we need to identify which number filter will allow us to view sales figures that are more than [tex]$200,000 from the given table. Let's break down each option provided: A. Equal, and then 200,000 - This filter would only display sales amounting exactly to $[/tex]200,000. Since we are interested in sales more than [tex]$200,000, this option is not suitable. B. Greater Than, and then 200,000 - This filter will display all sales that are strictly greater than $[/tex]200,000. This meets our requirement precisely since we're looking for sales above [tex]$200,000. C. Greater Than Or Equal To, and then 200,000 - This filter would display sales that are equal to or greater than $[/tex]200,000. While this partially meets our condition, it would also include sales figures of exactly [tex]$200,000, which we do not need. D. Does Not Equal, and then 200,000 - This filter will display all sales figures except for $[/tex]200,000. This filter does not meet our requirement as it will include sales less than [tex]$200,000 as well. Upon reviewing each option, the best filter to select for viewing sales more than $[/tex]200,000 is:

B. Greater Than, and then 200,000