FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following does Excel not provide features for importing data?
A
An active database
B
A Web page
C
A Web search
D
An EML file
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: -Detailed Solution. The correct answer is “ALT".

Detailed explanation-3: -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.

There is 1 question to complete.