Excel - COLUMN Function Problem - Expert Solution

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
Excelchat Expert 07/05/2018 - 11:56
It appears you have a question on fllters - correct?
User 07/05/2018 - 11:56
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
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
Excelchat Expert 08/05/2018 - 12:09
need to just read the question it says NOT filter.
User 08/05/2018 - 12:10
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

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc