Question description:
This user has given permission to use the problem statement for this
blog.
Which of the following procedures does not filter a table by the contents of a single column?
a. Click on the criterion button on the segment.
b. Right-click the cell whose content you want to choose as a criterion and click Filter on the menu.
c. Click the Filter button in the Sort and Filter group on the Data tab.
d. Click on the Automatic Filter button in the row of totals at the bottom.
Solved by V. E. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/05/2018 - 11:55
Hi welcome !
User
07/05/2018 - 11:55
Hey!
Excelchat Expert
07/05/2018 - 11:56
It appears you have a question on fllters - correct?
User
07/05/2018 - 11:56
Yes!
Excelchat Expert
07/05/2018 - 11:57
Is this an assignment question or do you have a sheet we need to look at along with your questions?
User
07/05/2018 - 11:57
Just an assignment question.
Excelchat Expert
07/05/2018 - 11:58
Ok. I will set up a table of line and go thru each possible answer-is that how you would like to proceed?
User
07/05/2018 - 11:59
Yeah sure
Excelchat Expert
08/05/2018 - 12:02
Ok, in looking at the possible answers, like most of this type we can toss out a couple out right.
User
08/05/2018 - 12:02
Which ones?
Excelchat Expert
08/05/2018 - 12:03
I will try to illustrate in the viewer, but bear with me
User
08/05/2018 - 12:03
Yeah no problem
Excelchat Expert
08/05/2018 - 12:04
Never mind , this viewer does not have all the functions and will waste your time
User
08/05/2018 - 12:04
No problem, wjatever's best
User
08/05/2018 - 12:04
*whatever's\
Excelchat Expert
08/05/2018 - 12:05
Lets toss out a: because merely right cllicking on the column wont sort; just brings up the options.
User
08/05/2018 - 12:05
sounds right
Excelchat Expert
08/05/2018 - 12:06
Let's toss out D; since a standard table has no row of totals at the bottom
Excelchat Expert
08/05/2018 - 12:06
Not sure how that would work it it did.
Excelchat Expert
08/05/2018 - 12:07
C: c. Click the Filter button in the Sort and Filter group on the Data tab i possible
User
08/05/2018 - 12:07
is C right or wrong?
Excelchat Expert
08/05/2018 - 12:08
The question says by the contents of a single column; so need to think about it.
User
08/05/2018 - 12:09
yeah
Excelchat Expert
08/05/2018 - 12:09
need to just read the question it says NOT filter.
User
08/05/2018 - 12:10
true
User
08/05/2018 - 12:10
wtf is Amelia doing right now
Excelchat Expert
08/05/2018 - 12:10
So instead of debating which is better B or C;
Excelchat Expert
08/05/2018 - 12:11
We need to find the worst answer, which is D:
Excelchat Expert
08/05/2018 - 12:11
No way will that start or finish a sort.
Excelchat Expert
08/05/2018 - 12:11
The others either do the job or start the job.
Excelchat Expert
08/05/2018 - 12:11
Make sense ; sorry the print is a bit small and I missed the NOT.
Excelchat Expert
08/05/2018 - 12:12
Ok, anything else
User
08/05/2018 - 12:12
no thanks
Excelchat Expert
08/05/2018 - 12:12
Do we need to find out who Amelia may be??
User
08/05/2018 - 12:13
yeah we do
Excelchat Expert
08/05/2018 - 12:13
Ok, thanks for bearing with me and please stop by with any questions.
User
08/05/2018 - 12:13
aight peace\
Excelchat Expert
08/05/2018 - 12:13
later...
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.