USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is a valid reason for converting a table to a range?
|
|
To clear the sorting criteria and start over
|
|
|
To prepare for deleting a column
|
|
|
To prepare for importing new data from a non-Excel file.
|
|
|
To prepare to change its conditional formatting.
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -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.
There is 1 question to complete.