USING MICROSOFT EXCEL
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: -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-3: -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.
Detailed explanation-4: -Insert an Excel chart in a Word document In Excel, select the chart, and then press Ctrl+C or go to Home > Copy. In your Word document, click or tap where you want the chart to appear, and press Ctrl+V or go to Home > Paste. Note: The chart is linked to the original Excel spreadsheet.