Skip to main content

ads1

Class9th STGP Computer Chapter :- 9 Mail Merge

 CHAPTER 9 :- MAIL MERGE 



Question and Answer :- 

1.What do you mean by indent? Explain any two indent options available under the Page Layout tab.

Ans :- 

The distance between the text boundaries and the page margins is called Indent. 

(i) Left Indent: A positive value will leave the corresponding space from the left margin.

(ii)Right indent: A positive value will leave the corresponding space from the right margin. 


2.What do you mean by text alignment? What are the two categories of text alignment?

Ans :- Text alignment refers to the positioning of text between the margins of a page. There are two categories of text alignment: 

(i) Horizontal Text Alignment: Text aligned with respect to left and right margins.

(ii)Vertical Text Alignment: Text aligned with respect to top and bottom margins. 


3. Explain the concept of Horizontal text alignment and its types.

Ans :- 

When you align the text with respect to the left and right margins, it is called Horizontal text alignment. There are four types of Horizontal text alignments present in the Paragraph group of the Home tab. 

(i) Align Text Left: This is the default alignment of text in a document. The text is aligned along the left margin while leaving a little space towards the right margin.


(ii) Align Text Right: The text is aligned along the right margin while leaving space towards the left margin. This alignment is mostly used to put dates on the letterheads.


(iii)Center: The text is aligned centrally between the left and the right margin. It is mostly used for the

titles.


(iv) Justify: The text is aligned evenly between the left and the right margin.


4.What is a list? Explain the steps to create a bulleted list.

Ans :- 

A number of connected items or names written or printed consecutively , typically one below the other , is called a list.


Select the text that you want to format as a list.


Click either on Bullets or Numbering commands in the Paragraph group of the Home tab


Select the desired bullets or numbering style, you would like to use from the drop-down menu. It will appear in the document.


Position the cursor at the end of a list item and press the Enter key to add an item to the list.


5.What is margin? Explain the different types of margins

Ans :-  The distance between the written text and the edge of the paper is called margin. There are four types of margins present in Microsoft Word:

(i)Top Margin :- Distance between the text and the top edge of the page.

(ii) Bottom Margin :-Distance between the text and the bottom edge of the page.

(iii)Left Margin :-Distance between the text and the left edge of the page.

(iv) Right Margin :- Distance between the text and the right edge of the page.


6.What is Page break? How do you insert in a document?

Ans :- 

Page break is an important feature of MS Word. It allows you to insert a break in the page, and moves the cursor on the new page. 

To insert a page break, position the cursor where you want to insert a page break and then click on Insert > Page Break.


7. What are headers and footers? How do you insert them in your document?

Ans :- 

Header and Footer are the identifiers that respectively run across the top and bottom of a document. They include information, like page numbers, date, title of a book or chapters, author's name and slide show theme, etc. To insert header or footer, click on Insert> Header or Footer. Type required header or footer and click outside, once completed.


8.What are columns? How do you divide a page into 5 columns?

The Columns feature allows you to divide the page vertically into two or more columns. To divide a page into columns, click on Page Layout Columns> More Columns. The Columns dialog box opens. Enter 5 in the Number of columns box, and click on OK. 


9.Explain the Borders tab in Borders and Shading dialog box.

Ans :- 

The options present in the Borders tab in Borders and Shading dialog box are:

(i) Box :- It is used for a regular boxed appearance for the paragraph.

(ii)Shadow:-Shadow option is used for the drop-shadow box effect.

(iii)3-D box :- To give the 3-D effect to the border, 3-D box option is used.

(iv)Custom :- To apply the custom border, select the Custom option.


10. Define the term table. Explain the utility of a table in a document.

Ans :-

A table is an organised arrangement of text in the form of rows and columns. Table is a useful way and present large amount of information. For example:


Technical, Financial, or Statistical Reports.

Product Catalogues showing descriptions, prices, characteristics, and photographs of a products.

Bills or Invoices

Lists of names with addresses, age, professions, and other informations.

Tables can often be used as an alternative to spreadsheets to organise data.

A well-designed table conveys information in a more meaningful way rather than the written text.


11.How do you print a document?

Ans :- 

To print a document, click on the File tab and then select the Print option. A preview of the document automatically appears on the right side of the Word window. To take the printout click on the Print button.


12.What is data source? 

Ans :- Data source consists of a mailing list. The data is organised in a tabular form along with the field names. For example, name, address, city, PIN, telephone number, etc. The data source is associated with the main document, so that its field names can be used in the main document, it becomes easy to merge addresses with the main document.


Link to download Chapter-9 Mail Merge :-







How to create MAIL MERGE in MSWord :-



 








ads2

Popular posts from this blog

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 :-