FUNDAMENTALS OF COMPUTER

USING MICROSOFT WORD

HOW TO USE MAIL MERGE IN MICROSOFT WORD

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you use an excel file for your data source you must make sure you ____ excel first.
A
Format
B
Resave
C
Close
D
Share
Explanation: 

Detailed explanation-1: -In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts.

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: -While you’ll use Save or press Ctrl+S to save an existing workbook in its current location, you need to use Save As to save your workbook for the first time, in a different location, or to create a copy of your workbook in the same or another location.

Detailed explanation-4: -The IF function is often used when you want to sort your data according to a given logic. The best part of the IF formula is that you can embed formulas and functions in it.

There is 1 question to complete.