Answer key New Revised Excel In Information Technology – 10

Chapter
Unit :1 :1 Digital Documentation Advanced

Session 1
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (d) 2. (d) 3. (c) 4. (c)
B. Answer the following
Ans-1 : Styles are predefined combination of font style, colour, size of text, indentation and alignment of text that can be
applied to the selected text, character and paragraph to change the appearance of the document.
Ans-2 : Character styles change the appearance of selected text, for example, font name, font size, bold, italics, etc.
Ans-3 : Step 1. Click on Format → Styles and Formatting from the menu bar. The Styles and Formatting window
appears.
OR
 Click on the Styles and Formatting icon from the Formatting toolbar or simply press F11.
Note: Styles and Formatting window is a floating window, you can move it to a convenient position on the
 
screen or dock it to the edge.
Step 2. Click on the required styles icon to display the list of styles in a selected category.
To apply a style, place the cursor in the paragraph , frame or page that needs to be modified and double-
Step 3. 
click on the name of the style.
To apply a style to the text, select the text first and then double click the style from the Character Styles
 
list.
Ans-4 : A new Style can be created by dragging and dropping a text selection into the Styles and Formatting window. To do
so, follow these steps:
Open the Styles and Formatting window.
Step 1.
Step 2. Select the text whose formatting you want to save as a new style.
Step 3. Now, drag the text to the Styles and Formatting window. The Create Style dialog box appears.
Step 4. Type a name for the new style and click OK.
Ans-5 : Aman can customise a style from a selection by following these steps :
Click on Format → Styles and Formatting to open Styles and Formatting window.
Step 1.
Step 2. In the document, select the object or text whose format you want to use to update the existing Style. For
example, click a paragraph to which you applied some manual formatting that you want to copy now.
In the Styles and Formatting window, select the Style you want to update and click on New Style from
Step 3. 
Selection icon.
Step 4. From the drop-down list that appears, select Update Style option. The selected Style gets updated.
C. Practical Work
To be done by students.

Session 2
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (d) 2. (c) 3. (b) 4. (c)

Computers-10 1
B. Answer the following
Ans-1 : Pictures or images lend a visual appeal to any document. Also, it makes the document more understanble for the
reader.
Ans-2 : To insert image from file, follow these steps:
Click on Insert → Picture → From File from the menu bar. The Insert picture dialog box appears.
Step 1.
Step 2. Select the picture you want and click on Open button.
The picture gets inserted in the document.
Ans-3 : To insert an image using gallery, follow these steps:
Click Gallery icon on the Standard toolbar or click Tools menu → Gallery. The Gallery appears above
Step 1. 
the document area.
Step 2. Select the desired category from the right side of the Gallery and navigate through the Gallery to find the
desired picture.
Step 3. To insert the picture, click and drag it from the Gallery into the document. Alternatively, you can right click
and select Insert → Copy option.
Ans-4 : Rakhi can insert the required shape and arrows using Gallery and Drawing toolbar.
C. Practical Work
To be done by students.

Session 3
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (a) 2. (c) 3. (c) 4. (c)
B. Answer the following
Ans-1 : When an image is selected, the Picture toolbar automatically appears.
Following are the components of the Picture toolbar:
Filter → It provides many options to add filter effect to the image.
(a)
Graphics Mode → This option allows to change the colour images to grayscale, Black/ White or Watermark.
(b)
Color → It is used to modify the individual RGB (Red, Green, Blue) components of the image.
(c)
Transparency → It is used to increase or decrease the transparency of an object.
(d)
Ans-2 : Filter is used to modify the pictures in many ways. It is used to invert the colour values of the colour image or the
brighteners values of a grayscale image, give sunlight effect on a picture, makes the picture appears like a painting,
creates the shadow effect, transform he image as charcool sketch, etc.
Ans-3 : Following the names and effect of graphic filter, options.
Name Effect

Invert Inverts the color values of a color image or the brightness values of a grayscale image.

Smooth Softens the contrast of an image.

Sharpen Increases the contrast of an image.

Remove noise Removes single pixels from an image.

Gives the effect of too much of sunlight on a picture. A dialog box opens up to set the
Solarization
percentage value of parameters.
Aging Mimics the effects of time on an image. A dialog box appears to adjust the aging level.

Posterize Makes the picture appear like a painting by reducing the number of colours used.

2 Computers-10
 Pop Art Modifies the image dramatically.

Charcoal Sketch Transforms the image as charcoal sketch.

Relief Creates the shadow effect. A dialog box appears to adjust the light source.

Gives the mosaic effect to the image. A dialog box appears to adjust the height and width in
Mosaic
pixel.
Ans-4 : Steps to Crop a Picture
Step 1. Right-click on the image and select Picture. A Picture dialog box appears.
Click on Crop tab on the Picture dialog box.
Step 2.
Step 3. Following are the parameters, which you can adjust to crop an image:

Keep scale/ Keep image size: When you do not want the scale of the image to be changed after
cropping, then click on Keep Scale radio button (selected by default). When Keep image size is selected,
cropping enlarges, shrinks or distorts the image to keep the image size constant.

Left, Right, Top and Bottom: If you want to crop the image from the left side of the image then enter the
value in Left box. Similarly, to the to crop the image from the right side, enter the value in Right box and so
on.
When Keep scale is selected, the size of the image also changes.
When Keep image size is selected, the remaining part of the image gets enlarged by positive values of

cropping and shrunk by negative values of cropping. This does not effect the size of the image.

Width and Height: Entering the value of width and height helps to adjust the width and height of an
image.
Click OK after selecting.
Step 4.
Ans-5 : Cropping means to cut off some part of the picture. This is done when an user do not wish to use the entire picture
and are interested only in some part of it.
Ans-6 : He can find Transparency command in the Picture toolbar.
C. Practical Work
To be done by students.

Session 4
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (c) 2. (d) 3. (b) 4. (b)
B. Answer the following
Ans-1 : To create a drawing object, follow these steps:

Step 1. Go to Drawing toolbar and select the desired drawing tool. The mouse pointer changes to .
Step 2. Move the cross-hair pointer to the place in the document where you want the graphic to appear and drag
and draw in the document. The object is created.
To cancel the selected drawing function, press the Esc key or click on the Select
 icon in the Drawing
toolbar.
Ans-2 : To change the properties of a drawing object, follow these steps:
Step 1. Select the object.
Step 2. On the Drawing Object Properties toolbar, click on the icon for each property and select the desired value
for that property.

Computers-10 3
Ans-3 : Text wrapping refers to the method of alignment of text with respect to the objects around them.
Ans-4 : To wrap text around drawing objects, follow the given steps:
Step 1: Select the object.
Click on Format menu → Object → Position and Size. This opens the Position and Size dialog box.
Step 2:
Click on Position and Size tab to open the respective page.
Step 3:
Step 4: Select the desired options to wrap the text and click on OK button.
Ans-5 : Nitya can use Text wrapping feature to accomplish the task.
C. Practical Work
To be done by students.
Session 5
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (b) 2. (a 3. (d) 4. (a)
B. Answer the following
Ans-1 : Template refers to a sample document which is not completely blank. It already has some data filled in it, which can
be used to save time.
Ans-2 : Yes, it is possible to create our own template in Writer. To create a template using a wizard, follow these steps:
Step 1: On the menu bar, click File → Wizards and choose the type of template required (like letter, fax, agenda,
etc).
Step 2: Follow the instructions on the pages of the Wizard.
Step 3: In the last section of the Wizard, enter the name and location for your new template and click on
Finish button.
Ans-3 : Step 1: Click on File → Templates → Organize. The Template Management dialog box appears.
Step 2: Double click the folder (at the left side of the dialog box) that contains the template you want to set as the
default.
Step 3: Select the desired template.
Click the Commands button and select Set As Default Template from the drop-down menu.
Step 4: 
Ans-4 : Writer provides the facility to edit a template, styles and content. To do so, follow these steps:
Click File → Templates → Organize. The Template Management dialog box appears
Step 1: 
Step 2: 
Double click the folder that contains the template that you want to edit. All the templates contained in that
folder appears below the folder name.
Step 3: 
Select the desired template
Click the Commands button and select Edit from the drop-down menu. The selected template opens
Step 4: 
up.
Step 5: Edit the template and click File → Save option to save the changes. The template gets updated.
Ans-5 : Raman can create a template using any of the following ways:
To create a template from a document, follow these steps:
Step 1: Open a new or existing document of your choice you want to make into a template.
Step 2: Add the content and styles that you want. You can edit the page layout as per your need like setting Page
Margins, orientation, Style, Header and Footer, etc. You can also add table of contents or some predefined
text.
Step 3: In the last step of the wizard (step 6) specify the Template name and location for saving the template. On the
menu bar, click File → Templates → Save. The Templates dialog box opens.

4 Computers-10
 In the New template field, type a name for the new template.
Step 4: 
In the Categories field, choose the category to which you want to assign the template. The Searching of
Step 5: 
template becomes easier when saved in relevant category.
Creating a Template Using a Wizard
To create a template using a Wizard, follow these steps:
Step 1: On the menu bar, click File → Wizards and choose the type of template required (like letter, fax, agenda,
etc).
Step 2: Follow the instructions on the pages of the Wizard.
Step 3: In the last section of the Wizard, enter the name and location for your new template and click on Finish
button.
C. Practical Work
To be done by students.
Session 6
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (b) 2. (d) 3. (d) 4. (a)
B. Answer the following
Ans-1 : Hyperlink is used to link one part of the document to the other part of the same document or different document.
Ans-2 : Following are the attributes of table of contents.
(a) Changing The Title : To assign title to your table of contents, type it is the Title field. If you want to delete
the title just clear the Title field.
(b) Protecting Against Manual Changes : If you do not want your table of contents to be changed directly
from the document page, then select Protected against manual changes checkbox. Doing this will prevent
any accidental change in the document and will allow changes only by using right-click menu or the insert
Table/Index dialog box.
(c) Choosing the Scope of the Table of Contents : The for drop-down list in Create index / table section
allows to choose the scope of the table of contents between the Entire document and Chapter. It means it
allows you to select whether the table of contents will cover all the document headings or just the headings of
the chapter where it is inserted.
(d) Changing the Number of Levels : You can change the number of levels in the table of contents by entering
the required number in the Evaluate up to level box. By default, Writer uses 10 levels of heading.
(e) Assigning Custom Styles : Additional Styles option on the Index / Table page allows to assign custom
paragraph styles to the table of contents.
Ans-3 : Enteries page is used to define and format the entries in the table of contents. If you want to format or
apply Character styles to each outline level independently from the other levels, then it can be done using
Entries page. You can also add and delete elements of each outline level from here.
Ans-4 : To insert a hyperlink, user needs to specify both the beginning and end of the link. To change the default Structure
line, so that Chapter Number and Entry Text form a hyperlink, follow these steps:
Step 1: Click on the white field to the left of button representing the Chapter Number.
Click the Hyperlink button. A
Step 2: button representing the start of a hyperlink appears on the Structure line.

Step 3:
Click on the white field to the right of the button representing the Entry text.
Click the Hyperlink button again. A
Step 4:  button representing the end of a hyperlink appears on the structure
line.
Click on OK button to save the changes.
Step 5:

Computers-10 5
Ans-5 : To apply a character style to an element, follow these steps :
Step 1: Click the button representing the element to which you want to apply a Style to.
Step 2: Select the desired Style from the Character Style drop-down list and click on OK button.
To edit the attributes of a Character Style, select the Style from the Character Style drop-down list and then click
the Edit button.
Now, make the necessary changes in the Character Style dialog box and click OK button.
Ans-6 : Yes, a ta ble of contents can be edited.
To apply and edit the styles, follow these steps:
On the Entries page of Insert Index / Table dialog box, click the button representing the element to which
Step 1: 
A style needs to be applied.
Step 2: Select the desired Style from the Character Style drop-down list.
Step 3: Now click the Edit button.
Step 4: Make the necessary changes in the Character Style dialog box and click OK button.
The Entries can be edited in the following ways:
To add elements to the structure line of a level, follow these steps:
Step 1: Select a level number in the Level column whose elements you want to format.
Step 2: Click on the white field, where you want to insert the element.
Step 3: Click one of the five buttons that are just below the Structure line. In the given example, we have clicked on
Tab Stop button to insert a tab stop.
A button representing the new element appears on the structure line.
Click the OK button to save the changes.
Step 4:
Note : You can preview the changes happening in the Preview box.

To change an element in the structure line, just click the button representing the element to be
changed and then click the element button of the element that you want to substitute from the row just
below the Structure line.

To delete an element from the Structure line, click the button representing the element to be deleted and press
the Delete key from the keyboard.
To add colour to the background of the table of contents, follow these steps:
Select Color from the As drop-down list on the Background page.
Step 1:
Step 2: Choose the desired colour from the colour palette that appears and click on OK button.
To add graphics to the background of the table to contents select Graphic from the As drop-down list and click on
Browse button to add a graphic.
Ans-7 : She can follow the below given steps to add table of contents.
Step 1: Place the cursor where you want to insert the table of contents.
Click on Insert → Indexes and Tables → Indexes and Tables. The Insert Index/Table dialog box opens.
Step 2:
The Preview box located on the left side shows the preview of your table of contents.
Note: If Preview box is not displayed, then click on Preview check box in the lower right side corner.
Step 3: To insert a quick table of content, just click on OK button. The default Table of Contents gets inserted.
C. Practical Work
To be done by students.

6 Computers-10
 Session 7
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (d) 2. (c) 3. (c) 4. (c)
B. Answer the following
Ans-1 : To print tables for mailing list, follow these steps:
Click File → Print. A dialog box appears, click on Yes. The Mail Merge window opens up.
Step 1: 
Step 2: To print all records, click on All radio button or to print selected records, click on From radio button and
enter the range.
Click on Printer option under the Output section and click OK. The Print dialog box appears.
Step 3: 
Step 4: Do the required Print settings and click on Print button to print the labels.
Ans-2 : Calc or Excel can be used for creating the data source.
Ans-3 : To link the data source in Mail Merge, follow these steps :
Step 1: Start OpenOffice Writer and click File menu → Wizards → Address Data Source. The Address Book
Data Source Wizard opens.
Choose Other external data source option and click Next button.
Step 1: 
Click Settings button in step 2 of the wizard. The Create Address Data Source dialog box appears.
Step 2: 
From the Database type drop-down list, choose Spreadsheet and click Next button.
Step 3: 
Specify the path to the spreadsheet documents by clicking Browse button. The Open dialog box appears.
Step 4: 
Step 5: Select the spreadsheet file and click Open button.
Step 6: The path of the file is displayed. Click Finish button.
Step 7: You returned to step 4 of Address Book Data Source Wizard. Click on Next button.
Step 8: Give any name for the address book and click Finish button.
Ans-4 : Follow these steps to print a file for previewing or customising before printing :
On the Mail Merge window, click on File option under Output section and then select Save as single
Step 1: 
document. Now, click OK. This generates a Writer document with the merged result.
On the Save As window, give a file name and click Save.
Step 2: 
Click on File → Open and open the file you just named.
Step 3: 
Note: You may get a window asking to update all links. Click on No.
Step 4: Writer document opens up with merged labels.
Step 5: At this stage, you can make any modifications or changes you want and print it using File → Print.
C. Practical Work
To be done by students.
EXERCISE
SECTION–A
Multiple Choice Questions
Ans : 1. (d) 2. (c) 3. (a) 4. (b) 5. (d) 6. (c)
7. (c) 8. (c) 9. (c) 10.
(c) 11.
(a) 12.
(b) 13.
(c) 14.
(a)
SECTION–B
Very Short Answers
Ans-1 : Styles are predefined combination of font style, colour, size of text, indentation and alignment of text that can be
applied to the selected text, character and paragraph to change the appearance of the document.
Ans-2 : Frame Styles are used to format graphics and frames. It consists of options for wrapping, alignment, borders,
background colour, etc.

Computers-10 7
Ans-3 : Styles in OpenOffice Writer can be applied using Styles and Formatting window, Fill Format mode and Style list.
Ans-4 : Yes, Styles can be modified in OpenOffice Writer. Two common ways to modify Styles are-
(a) Updating a Styles from a selection
(b) Load or copy Styles from another document or template.
Ans-5 : Pictures or images lend a visual appeal to any document. Also, it makes the document more understanble for the
reader.
Ans-6 : Pop Art graphic filters modifies the image dramatically by changing the colour of a picture to a Pop Art format.
Ans-7 : Yes, we can insert already saved pictures.
Ans-8 : Filter options provide many option to add filter effect to the image.
Ans-9 : Following are the steps to group drawing objects :
Step 1: Select all the objects while holding the Shift key. The bounding box expands to include all the selected
objects.
Click on Format menu → Group → Group.
Step 2: 
OR
Right-click → Group → Group
Ans-10 : Table of contents feature in Writer allows us to build an automated table of contents from the headings in a documnets.
Ans-11 : To change an element in the structure line, just click the button representing the element to be changed and then click
the element button of the element that you want to substitute from the row just below the Structure line.
Ans-12 : To save a table of contents and to insert them in the documents, click on the OK button on the Insert Index/
table dialog box. This closes the Insert Index/Table dialog box and the table of contents gets inserted as per your
requirement.
Ans-13 : When the same letter has to be sent to multiple recipients and the matter is the same, only the address and the
greeting line differs, the mail merge facility is used.
Ans-14 : Format features used in the given text are :
(a) Font formatting like Bold, Italic, font face, font size.
(b)
Text wrapping
(c) Text formatting like alignment
(d)
Column formatting
(e)
Bullets
SECTION–C
Short Answers
Ans-1 : OpenOffice Writer supports the following types of Styles :

XX Paragraph Styles: They are used to change paragraph’s appearance, such as alignment, line spacing, borders,
tab stops and character formatting.

XX Character Styles: Character styles change the appearance of selected text, for example, font name, font size,
bold, italics, etc.

XX Frame Styles: They are used to format graphics and frames. It consists of options for wrapping, alignment,
borders, background colour, etc.

XX Page Styles: Page styles affect page formatting such as page size, margin, headers and footers, borders and
background.

XX List Styles: List styles are used to format numbered or bulleted lists.
Ans-2 : To apply Styles in OpenOffice using Styles and Formatting window, follow these steps :
Step 1: Click on Format → Styles and Formatting from the menu bar. The Styles and Formatting window
appears.

8 Computers-10
 OR
Click on the Styles and Formatting
 icon from the Formatting toolbar or simply press F11.
Step 2: Click on the required Styles icon to display the list of styles in a selected category.
Step 3: To apply a Style, place the cursor in the paragraph , frame or page that needs to be modified and double-
click on the name of the style.
To apply a Style to the text, select the text first and then double click the style from the Character

Styles list.
Ans-3 : A new Style can be created by dragging and dropping a text selection into the Styles and Formatting window. To do
so, follow these steps:
Open the Styles and Formatting window.
Step 1.
Step 2. Select the text whose formatting you want to save as a new style.
Step 3. Now, drag the text to the Styles and Formatting window. The Create Style dialog box appears.
Step 4. Type a name for the new style and click OK.
Ans-4 : One can add pictures from stored files in his/her hand disk or CDs. To insert image from file, follow these steps :
To insert image from file, follow these steps:
1. Click on Insert → Picture → From File from the menu bar. The Insert picture dialog box appears.
2. Select the picture you want and click on Open button.
The picture gets inserted in the document.
Ans-5 : Following are the various graphic filters in OpenOffice.
Name Effect

Invert Inverts the color values of a color image or the brightness values of a grayscale image.

Smooth Softens the contrast of an image.

Sharpen Increases the contrast of an image.

Remove noise Removes single pixels from an image.

Gives the effect of too much of sunlight on a picture. A dialog box opens up to set the
Solarization
percentage value of parameters.
Aging Mimics the effects of time on an image. A dialog box appears to adjust the aging level.

Posterize Makes the picture appear like a painting by reducing the number of colours used.

Pop Art Modifies the image dramatically.

Charcoal Sketch Transforms the image as charcoal sketch.

Relief Creates the shadow effect. A dialog box appears to adjust the light source.

Gives the mosaic effect to the image. A dialog box appears to adjust the height and width in
Mosaic
pixel.
Ans-6 : To rotate a picture in a Writer document, follow these steps:
Step 1: Open a new Draw or Impress document.
Step 2: Insert the picture you want to rotate.
Step 3: Select the image and select the Rotate icon from the drawing toolbar.
Step 4: Rotate the image as desired using the rotation handles.
Step 5: Select the image and press Ctrl+C to copy.
Step 6:
Now, paste the image at the desired location in the Writer document.

Computers-10 9
Ans-7 : You can also resize the image to suit your need. To resize the image, follow these steps:
Step 1: Click on the image. The green colour resizing handles appear at the border.
To resize the image proportionally, position the mouse pointer at any of the corner resizing handles.
Step 2: 
The mouse pointer changes to .
 
To resize the image horizontally, position the mouse pointer at the center of the top or bottom border.
The mouse pointer changes to .
To resize the image vertically, position the mouse pointer at the resizing handle present at the center of
the left or right side border. The mouse pointer changes to .
Step 3: Drag to resize the picture and release the mouse when the desired size is achieved.
Ans-8 : Writer provides the facility to edit a template, styles and content. To do so, follow these steps:
Click File → Templates → Organize. The Template Management dialog box appears
Step 1:
Step 2: 
Double click the folder that contains the template that you want to edit. All the templates contained in that
folder appears below the folder name.
Step 3:
Select the desired template.
Click the Commands button and select Edit from the drop-down menu. The selected template opens
Step 4: 
up.
Step 5: Edit the template and click File → Save option to save the changes. The template gets updated.
Ans-9 : Hyperlink is used to create link one part of the document to the other part of the same document or different
document.
Ans-11 : To update a Table of contents, follow these steps:
Step 1: Right-click anywhere on the table of contents.
Click on Update Index/Table option from the context menu. The Table of Contents gets updated.
Step 2:
To delete a table of contents, follow these steps:
Step 1: Right-click anywhere in the table of contents.
Select Delete Index/Table option from the context menu. The table of contents gets deleted.
Step 2: 
Ans-12 : The mail merge process involves taking information from one document known as the data source, combining with
another document known as the main document The data source is a document, spreadsheet or database that
contains personalised information such as names, addresses and phone numbers.
To create a data source in Calc, just type the required data in a Calc worksheet and save it.
Ans-13 : Following are the steps required for preparing mailing labels for printing:
Click on File → New→ Labels. The Labels window appears.
Step 1: 
On the Options tab, make sure that Synchronize contents checkbox is clicked.
Step 2: 
Step 3: On the Labels page:
v select the Database from the Database drop-down list.
v select the Table from the Table drop-down list.
v select the Brand of labels to be used.
v select the Type of label.
v clear the default Label text that appears in Label text textbox.
Now, click the Database field drop-down list in the Labels page/tab and select the first field to be used in
Step 4: 
the label.
Step 5: Click on the Left arrow button to move this field to the Label text area.
Step 6: Similarly, add other fields from the Database field list to the Label text. Ensure to insert desired
punctuation, spaces, and line breaks until the label is composed.
Click on New Document button. You will see a page displaying a series of frames, one for each label of
Step 7: 
the selected type and each label filled with the data source address fields that you selected.

10 Computers-10
 Step 8: In case you want to make some common corrections in all the labels, then you can just make the corrections
just once, in upper left label and then click Synchronize Labels button. The changes are made in all labels.
Ans-14 : Following are the steps to customise the document before printing.
On the Mail Merge window, click on File option under Output section and then select Save as single
Step 1: 
document. Now, click OK. This generates a Writer document with the merged result.
On the Save As window, give a file name and click Save.
Step 2:
Click on File → Open and open the file you just named.
Step 3:
Note: You may get a window asking to update all links. Click on No.
Step 4: Writer document opens up with merged labels.
Step 5: At this stage, you can make any modifications or changes you want and print it using File → Print.
Ans-15 : She can set that template as a default template.
Ans-16 : He can add a hyperlink, by following these steps:
Step 1: Click on the white field to the left of button representing the Chapter Number.
Click the Hyperlink button. A
Step 2: button representing the start of a hyperlink appears on the Structure line.

Step 3: Click on the white field to the right of the button representing the Entry text.
Click the Hyperlink button again. A
Step 4:  button representing the end of a hyperlink appears on the structure
line.
Click on OK button to save the changes.
Step 5:
Ans-17 : He can use mail merge feature.
SECTION–D
Long Answers
Ans-1 : To apply Styles using Fill Format mode, follow these steps:
Click on Styles and Formatting
Step 1:  icon to open the Styles and Formatting window.
Step 2: Select the Style of your choice in a particular category (such as Page, Character, Paragraph).
Click on Fill Format Mode
Step 3:  icon at the top right side of the Styles and Formatting window. The mouse
pointer changes to .
Step 4: To apply a Style on paragraph or page, drag the mouse over the paragraph or page and click. Similarly, to
apply style on a word, select the character style and click on the word.
To quit Fill Format mode, click the Fill Format Mode
Step 5:  icon again or press Esc key.
Ans-2 : Following are the ways to insert an image in Writer.
To insert image from file, follow these steps:
Click on Insert → Picture → From File from the menu bar. The Insert picture dialog box appears.
Step 1:
Step 2: Select the picture you want and click on Open button.
The picture gets inserted in the document.
Inserting image from the clipboard
To insert an image from the clipboard, follow the given steps:
Step 1: Open the document from where the image has to be copied and select the image.
Press Ctrl+C and copy the image to the clipboard.
Step 2:
Step 3: Now, switch to the document in which graphic needs to be inserted.
Step 4: Click at the place where graphic is to be inserted.
Press Ctrl+V to paste/insert the image.
Step 5:

Computers-10 11
 Inserting an image using Scanner
To insert an image using scanner, click on Insert :
Picture → Scan → Select Source.
Step 1:
Inserting an image from the Gallery
To insert an image using gallery, follow these steps:
Click Gallery
Step 1:  icon on the Standard toolbar or click Tools menu → Gallery. The Gallery appears
above the document area.
Step 2: Select the desired category from the right side of the Gallery and navigate through the Gallery to find the
desired picture.
Step 3: To insert the picture, click and drag it from the Gallery into the document. Alternatively, you can right click
and select Insert → Copy option.
(Any Two)

Ans-3 : Steps to Crop a Picture

Step 1: Right-click on the image and select Picture. A Picture dialog box appears.
Click on Crop tab on the Picture dialog box.
Step 2:
Step 3: Following are the parameters, which you can adjust to crop an image:

Keep scale/ Keep image size: When you do not want the scale of the image to be changed after
cropping, then click on Keep Scale radio button (selected by default). When Keep image size is selected,
cropping enlarges, shrinks or distorts the image to keep the image size constant.

Left, Right, Top and Bottom: If you want to crop the image from the left side of the image then enter the
value in Left box. Similarly, to the to crop the image from the right side, enter the value in Right box and so
on.
When Keep scale is selected, the size of the image also changes.
When Keep image size is selected, the remaining part of the image gets enlarged by positive values of

cropping and shrunk by negative values of cropping. This does not effect the size of the image.

Width and Height: Entering the value of width and height helps to adjust the width and height of an
image.
Click OK after selecting.
Step 4:
Ans-4 : To create a drawing object, follow these steps:

Step 1: Go to Drawing toolbar and select the desired drawing tool. The mouse pointer changes to .
Step 2: Move the cross-hair pointer to the place in the document where you want the graphic to appear and drag
and draw in the document. The object is created.
To cancel the selected drawing function, press the Esc key or click on the Select
 icon in the Drawing
toolbar.
To change the properties of a drawing object, follow these steps:
Step 1: Select the object.
Step 2: On the Drawing Object Properties toolbar, click on the icon for each property and select the desired value
for that property.
Ans-5 : Text Wrapping refers to the method of alignment of text with respect to the objects around them.
To wrap text around drawing objects, follow the given steps:
Step 1: Select the object.
Click on Format menu → Object → Position and Size. This opens the Position and Size dialog box.
Step 2:
Step 3: Click on Position and Size tab to open the respective page.
Step 4: Select the desired options to wrap the text and click on OK button.

12 Computers-10
Ans-6 : Setting a default template means, when you create a document by choosing File → New → Text Document, then
the new file is created from the template you have set as default. A custom template can be set as a default template
and again the default template can be reset. Resetting the default template means, when a default template is reset,
the document will be created from OpenOffice Writers default template. A default template in Writer can also be
edited to change its template styles and content.
Ans-7 : Following are the attributes of table of contents :
Changing The Title
(a)
To assign title to your table of contents, type it is the Title field. If you want to delete the title just clear the Title
field.
Protecting Against Manual Changes
(b)
If you do not want your table of contents to be changed directly from the document page, then select Protected
against manual changes checkbox. Doing this will prevent any accidental change in the document and will
allow changes only by using right-click menu or the insert Table/Index dialog box.
Choosing the Scope of the Table of Contents
(c)
The for drop-down list in Create index/table section allows to choose the scope of the table of contents

between the Entire document and Chapter. It means it allows you to select whether the table of contents will
cover all the document headings or just the headings of the chapter where it is inserted.
Changing the Number of Levels
(d)
You can change the number of levels in the table of contents by entering the required number in the Evaluate
up to level box. By default, Writer uses 10 levels of heading.
Assigning Custom Styles
(e)
Additional Styles option on the Index / Table page allows to assign custom paragraph styles to the table of
contents.
Ans-8 : By default, the table of contents has one column. You can also change the number of columns using Column Tab to
suit your need.
To do so, follow these steps:
Step 1: Enter the desired number of columns in the Columns box.
OR
Select the icon representing the number of columns.
Step 2: Click on the AutoWidth checkbox to give equal width to each column.
To specify different width and spacing between each of the columns, uncheck the AutoWidth box and enter
the desired value for width and spacing.
Step 3: You can specify the separator Line’s width, height and position using the Line, Height and Position options
present in Separator line section.
Click on OK button.
Step 4:
Using Background Page Tab
Background page is used to add colour or a graphic to the background of the table of contents.
To add colour to the background of the table of contents, follow these steps:
Select Color from the As drop-down list on the Background page.
Step 1:
Step 2: Choose the desired colour from the colour palette that appears and click on OK button.
To add graphic as the background of the table of contents, follow these steps:
Select Graphic from the As drop-down list.
Step 1:
Click on Browse button under File section The Find graphics dialog box appears.
Step 2:
Step 3: Select the desired graphic and click on Open button. The selected graphic appears in the Preview box.
Step 4: Select how you want the background graphic to appear (Position, Area, Tile) from the Type section.
Click on OK button to save the changes.
Step 5:

Computers-10 13
Ans-9 : Data source in mail merge is linked to the main document to fetch the data from the data source file to the main
document To link the data source, follow these steps:
Step 1: Start OpenOffice Writer and click File menu → Wizards → Address Data Source. The Address Book
Data Source Wizard opens.
Choose Other external data source option and click Next button.
Step 2: 
Click Settings button in step 2 of the wizard. The Create Address Data Source dialog box appears.
Step 3: 
Step 4: From the Database type drop-down list, choose Spreadsheet and click Next button.
Specify the path to the spreadsheet documents by clicking Browse button. The Open dialog box appears.
Step 5: 
Step 6: Select the spreadsheet file, and click Open button.
Step 7: The path of the file is displayed. Click Finish button.
Step 8: You returned to step 4 of Address Book Data Source Wizard. Click on Next button.
Step 9: Give any name for the address book and click Finish button. Here, the name is Address Book 2.
Ans-10 : He can use the Text wrapping feature.

14 Computers-10