Sandra has created a report in Excel 2010. Her manager needs that report in tab delimited text
format. Sandra has to export the report in the required format. Which option will she use to
accomplish the task?
A.
Use the Export To option in the Data tab.
B.
Use the Export to Text option in the Backstage view.
C.
Use the Get External Data in the Data tab.
D.
Use the Save As option in the Backstage view.
Explanation:
According to the question, Sandra is required to export the report in the tab delimited text format.
In order to accomplish the task, she will have to use the Save As option in the Backstage view.Note: A user can import or export up to 1,048,576 rows and 16,384 columns.
The Save As option can be used to export data in various formats including tab delimited text file in
Excel 2010.
Answer B and A are incorrect. No such options are available in Excel 2010.
Answer C is incorrect. This option is used to import text data to Excel.
