DOEACC NIELIT O Level A1 R4 January 2010 Part Two Question Answer Sample Model Paper Solutions

Ans. 7 (b)

1. Ctrl + B
2. Ctrl + S

• Ctrl + U

1. Ctrl + I
2. Ctrl + V
3. F7

Ans. 7 (c)

Mail merge is a utility wizard provided by the MS – Word application and also by other MS – Office data source or manually and create a common document for all those recipients and then mergins the two documents to create a common document. This prevents from typing the common matter for individual recipients.

Steps:

1. Choose mainl merge from the tools menu.
2. Click the vcreate button. A list of drops downs offering you the choices.
3. Select from letters.
4. Click active window button to use main document
5. Click on get data button to drop down the list of options for data source
6. Select create data source and setup the fields of your data source.
7. The list box on the right displays commonly used field names. You can remove the unwanted fields and and new fields also.
8. Click OK to close the dialog box. Word displays a save data source dialog box
9. Click edit data source to display dialog box where you can begin entering records in the datra source.
10. After entering records, Click Ok, Word closes the dialog box and return you to the main document.
11. With the insertion point at the top of the blank document, click the insert merge field button on the mail merge toolbar to drop down a list of the available fields.
12. Click on the field name to insert and repeat this process to insert all the fields
13. Now type the main body of the document and Save it.
14. Go to tools menu > mail merge > merge.
15. The document is merged.

Ans. 7 (d): Adjust line or paragraph spacing: You can change the spacing between the lines or the spacing before or after each paragraph.

CHANGING LINE SPACING: (O Level IT Tools Business Systems Solutions)

1. Select the text you want to change.
2. On the Formatting toolbar, point to Line Spacing, and then do one of the following:

To apply a new setting, click the arrow, and then select the number that you want.

To apply the most recently used setting, click the button.

To set more precise measurements. Click the arrow, click More, band then select the options you want Under Line Spacing.

Note is you select Exactly or At least for line spacing, enter the amount of space you want in the A1 box. If you select Multiple, enter the number of lines in the A1 box.

CHANGING PARAGRAPH SPACING:

1. Select the paragraphs in which you want to change spacing.
2. On the Format menu, click Paragraph, and then click the Indents and Spacing
3. Under Spacing, enter the spacing you want in the Before or After

Ans. 8(a): Using the Freeze Panes Feature

Lock Columns and Rows in Excel with Freeze Panes

Using the Excel Freeze Panes Feature: It is sometimes difficult to read and understand very large spreadsheets. When you scroll too far to the right or down, you lose the headings that are located at column or row of data you are looking at.

To avoid this problem use the freeze pane feature in Microsoft Excel. It allows you to “freeze” certain areas or panes of the spreadsheet so that they remain visible at all times when scrolling to the right or down. Keeping heading on the screen makes it easier to read your data throughout the entier spreadsheet.

Freeze Pane Using the Active Cell

Freeze Panes Using the Active Cell: When you activate Freeze panes in Excel, all the rows above the active cell and all the columns to the left of the active cell become frozen. To freeze only those columns and rows you want to stay on screen, click on the cell to the right of the columns and just below the rows that you want to remain on screen. For example – to keep rows 1,2, and 3 on the screen and columns A and B, click in cell C4 with the mouse. Then choose Window > Freeze Panes from the menu, as shown in the image above.