Question description: Show
 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: Which of the following procedures is not a way to sort a table by the contents of one column *?You cannot sort a table in alphabetical or numerical order for one column, and by conditional formatting for another column, at the same time.
Which of the following procedures is not a way to delete one or more worksheets from a workbook *?Which of the following procedures is not a way to delete a worksheet from a workbook? Press Ctrl + A to select all cells in the worksheet and press Delete. Which of the following statements about hidden and unhidden worksheets is correct? A hidden worksheet cannot be inadvertently deleted.
Which of the following statements describes the difference between auto filtered range of records in a list and a table?Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table? There is no difference between an AutoFiltered range of records in a list and a table. A table maintains its sort order after you close and then open it again.
Which of the following is a valid reason for converting a table to a range?Which of the following are valid reasons for converting a table to a range? To prepare for importing new data from a non-Excel file.
|
Which of the following procedure is not a way to filter a table by the contents of one column?
Urheberrechte © © 2024 toptenid.com Inc.
