DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Yes
|
|
|
No
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -An Excel spreadsheet works well as a data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. For more information, see Prepare your Excel data source for mail merge. You can retrieve contact information directly from your Outlook Contact List on to Word.
Detailed explanation-2: -Step 1: Set up your data source in Excel. If you’re using an Excel spreadsheet as your data source for a mail merge in Word, skip this step. If the data source is a .txt or a .csv file, use the Text Import Wizard to set up your data in Excel. After you successfully import a .txt or .csv file, go to Step 2.
Detailed explanation-3: -1. Open the spreadsheet in Excel and highlight each column of data, clicking on Insert, Name, Define until all columns have been defined. 3. From the Start menu choose Settings > Control Panel > Administrative Tools > Data Source (ODBC).
Detailed explanation-4: -The mail merge process involves taking information from one document, known as the data source, combining with another document known as the main document. The data source is a document, spreadsheet or database that contains personalized information such as names, addresses, and phone numbers.