USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Code
|
|
Process
|
|
Export
|
|
Save
|
Detailed explanation-1: -Data export is the extraction and conversion of raw data from their existing format into a format required by another application. Exporting data is also a way of backing up data or moving it between two different versions of programs.
Detailed explanation-2: -You can export data from Access in a variety of formats, including Excel, Word, and SharePoint lists.
Detailed explanation-3: -On the Data tab, in the Get & Transform Data group, click From Text/CSV. In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import. In the preview dialog box, you have several options: Select Load if you want to load the data directly to a new worksheet.
Detailed explanation-4: -Exporting data to Word: the basics When you export an object by using the Export-RTF File Wizard, Access creates a copy of the object’s data in a Microsoft Word Rich Text Format file (*. rtf). For tables, queries, and forms, the visible fields and records appear as a table in the Word document.