Chapter 11 :- Tables and Mail Merge

Chapter 11 :- Tables and Mail Merge

Summary

There are three different ways to insert a table in a document; using menu, using icon and using keyboard. You can choose Table → Insert → Table from the menu. The same can be done simply by pressing CTRL + F12 keys.

Name : Here you can enter a name of the table. Table1 is a default table name. You can modify the table name as per your needs.

Size : The required number of rows and columns can be set here. The size of the table, once set, can be changed later, if needed. The default Table size is 2 columns and 2 rows.

Heading : One or more rows can be specified as a heading of the table. The desired number of rows can be specified in ‘The first rows'. The default value is 1. The advantage of defining the row(s) as head row(s) is; when splitting a table into two tables, the Heading row(s) are copied in the second table automatically.

Repeat Heading : This option is little different from the 'Heading'. If you check "Repeat Heading' then the heading row(s) will be repeated on subsequent pages if the table spreads across more than one page.

Border : On selection of this option, Writer surrounds each cell of the table with a border. The border can be changed or can be deleted later.

Choose the most appropriate option from those given below :-

1. Before creating table, deciding on number of rows and columns

(a) is not a good idea

(b) is a good idea because planning saves time and efforts

(d) is really necessary because excess rows and columns cannot be deleted later.

2. Which short-cut key is used to insert table in a document ?

(a) TAB + F12

(b) ALT + F12

(d) CTRL + F12

3. The default table size is

(a) 1 column, 1 row

(b) 2 columns, 1 row

(c) 2 columns, 2 rows

(d) 1 column, 2 rows

4. Which of the following moves the insertion point to the previous cell ?

(a) TAB

(b) SHIFT + TAB

(d) CTRL + TAB

5. What is the shape of the mouse pointer when drawing a table ?

(a) Pencil

(b) White pointing arrow

(d) Black plus

6.Which short-cut key is used to insert row or column ?

(a) SHIFT + INSERT

(b) ALT + INSERT

(d) TAB + INSERT

7. Which short-cut key is used to delete row or column ?

(a) SHIFT + DELETE

(b) ALT + DELETE

(d) TAB + DELETE

8. How a table can be deleted ?

(a) Click anywhere in the table and choose Delete / Table from Table menu.

(b) Select table and press Delete key.

(d) All of the above.

9. Which of the following is valid type of data source in mail merge?

(a) Spreadsheet

(b) Text files

(d) All of the above

10. The default file name of data source in mail merge is

(a) ... \Datasource.odb

(b) ... \test-main-document.odb

(c) ... \Addresses.odb

(d) ..\Recipient.odb

11. What is the short-cut key to print a document ?

(a) CTRL + P

(b) ALT + P

(d) TAB + P

12. What are the five options that appear on print dialog box ?

(a) Printer, Page Set-up, Print Range, Copies, Options

(b) Printer, Page Set-up, Page Break, Size, Margins

(c) Printer, Properties, Print Range, Copies, Options

(d) Printer, Properties, Print Size, Color, Page Border

13. The default orientation of a page in Writer is

(a) Portrait

(b) Landscape

(d) None

14. The size of a letter page is

(a) Width - 8.50” and Height - 11.00"

(b) Width - 11.50” and Height - 8.00"

(d) Width – 8.50” and Height – 14.00”

15. Which four margins can be set from Margin section ?

(a) Top, Bottom, Header, Footer

(b) Top, Bottom, Left, Right

(d) Header, Footer, Row, Column

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