Q1. What do you mean by Mail Merge? Explain all the documents involved in Mail Merge.
Q2. Define the following:
a .Scenarios in spreadsheet
b. Goal Seek
Q3. What do you mean by network? Explain any two different types of Network.
Answers
Answer:
1) A mail merge is a method of taking data from a database, spreadsheet or other form of structured data, and inserting it into documents such as letters, mailing labels, and name tags.
. Mail merge requires 3 types of documents,they are:-
1) Main document: In a mail merge operation, the personalized document ( such as, a standard Letter, or envelope, or mailing label) is known as the main document.
2) Data source: Data source is a file that contains the names and addresses or any other information that vary with each version of a mail merge document.
3) Merge document: When you merge the main document with data source, a third document called merge document will be produced. The merge document can be merged to the screen to view letters along with addresses, or directly to the printer to print the letters along with addresses and print addresses on envelopes or labels, or save as some other file that can be used later for printing.
Microsoft Excel.