DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following attributes is not a potential criterion for an AutoFilter sort?
|
|
Font color
|
|
|
Font style
|
|
|
Cell color
|
|
|
Cell icon
|
Explanation:
Detailed explanation-1: -You cannot sort a table in alphabetical or numerical order for one column, and by conditional formatting for another column, at the same time. When importing data from a text file, you can tell Excel to recognize a character other than a comma as a field delimiter.
Detailed explanation-2: -which of the following procedures is not a way to sort a table by the contents of one column? click an autofilter button in the total row.
Detailed explanation-3: -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. A table given a title enables its field names to be used in formulas in place of cell references.
There is 1 question to complete.