Chapter - 5 Using Mail Merge

Q.1 Select the correct option.

1. The ___________ is the letter that you wish to send to multiple recipients.

(a) Main document

(b) Address label

2. A merged document is created by merging the main document with the a ________ feilds.

(a) Address book

(b) Data Source

3. You can print multiple address ___________ on a single sheet by using the Mail Merge feature.

(a) Books

(b) List

(c) Labels

Q.2 Write T for True and F for False.

1. The process of mail merge involves only two steps. False

2. You cannot edit any address label in a merged document. False

3. The data source is associated with the main document. True

4. You can find the Start Mail Merge option in the Mailings tab. True

Q.3 Answer the following questions.

1 What do you understand by the term Mail Merge?

Ans 1 :-

Mail Merge involves three basic steps- creating a main document, specifying a data source, and merging the data source with the main documentation

2. Name the documents that are combined while using the Mail Merge feature.

Ans :-

A merged document is created by merging the main document with the data source fields.

3. Define the term data source.

Ans :-

Data source consists of a mailing list. The data is organized in a tabular form along with the field names.

4. What is a main document?
Ans :-

The main document is the letter that you wish to send to multiple recipients.

Link to Download Chapter :-

Link to Download Video :-

11. Write a Java program to input basic salary of an employee and calculate its Gross salary according to following:

11. Write a Java program to input basic salary of an employee and calculate its Gross salary according to following: Basic Salary <= 10000 : HRA = 20%, DA = 80% Basic Salary <= 20000 : HRA = 25%, DA = 90% Basic Salary > 20000 : HRA = 30%, DA = 95% Static Solution :- class salary { public static void main(String args[]) { double basic=20000.50,gross,da,hra; if(basic <=10000) { da = basic * 0.8; hra = basic *0.2; } else if(basic <=20000) { da = basic * 0.9; hra = basic *0.25; } else { da = basic * 0.95; hra = basic * 0.3; } gross = basic + da + hra; System.out.println("The Gross Salary is :-"+gross); } } Output :- Dynamic Solution :- class salary { public static void main(String args[]) { double basic=20000.50,gross,da,hra; Scanner in = new Scanner(System.in); System.out.println("Enter the Basic Salary

1. Given the school result data, analyses the performance of the students on #different parameters, e.g subject wise or class wise.

1. Given the school result data, analyses the performance of the students on #different parameters, e.g subject wise or class wise. Solution :- # x-axis is shows the subject and y -axis # shows the markers in each subject # import pandas and matplotlib import pandas as pd import matplotlib.pyplot as plt # Simple Line Chart with setting of Label of X and Y axis, # title for chart line and color of line subject = ['Physic','Chemistry','Mathematics', 'Biology','Computer'] marks =[80,75,70,78,82] # To draw line in red colour plt.plot(subject,marks,'r',marker ='*') # To Write Title of the Line Chart plt.title('Marks Scored') # To Put Label At Y Axis plt.xlabel('SUBJECT') # To Put Label At X Axis plt.ylabel('MARKS') plt.show() Output :-

24.Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.

24.Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category. import pandas as pd # initialize list of lists data = [['CAR','Maruti',1000000],['AC','Hitachi',55000],['AIRCOLLER','Bajaj',12000], ['WASHING MACHINE','LG',15000],['CAR','Ford',7000000],['AC','SAMSUNG',45000],['AIRCOLLER','Symphony',20000],['WASHING MACHINE','Wirlpool',25000]] Col=['itemcat','itemname','expenditure'] # Create the pandas DataFrame qrtsales = pd.DataFrame(data,columns=Col) # print dataframe. print (qrtsales) qs=qrtsales.groupby('itemcat') print('Result after Filtering Dataframe') print(qs['itemcat','expenditure'].sum()) Output :-

TechOnespot

Search This Blog

ads1