DATABASE FUNDAMENTALS
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?
|
|
An active database
|
|
|
A Web page
|
|
|
A Web search
|
|
|
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: -File encryption: When you choose this option, you specify a password and lock the Excel file. This prevents other users from opening the file. For more information, see Protect an Excel file.
There is 1 question to complete.