USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you are importing new data into an Excel file that is currently formatted as a table, you should
|
|
convert the table back to a range
|
|
|
Do nothing, just import
|
|
|
Sort the data first
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Click anywhere in the table and then go to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range. Right-click the table, then in the shortcut menu, click Table > Convert to Range.
Detailed explanation-2: -Switch to Excel and open the worksheet that has data that you want to import. Select the range of cells that contain the data that you want to import. Right-click within the selected range and then click Name a Range or Define Name. In the New Name dialog box, specify a name for the range in the Name box and click OK.
There is 1 question to complete.