4.

Formatting in Word Processor Unit 3: Digital Documentation

Unsolved Exercise
Section A
A. 1. iii 2. i 3. i 4. iv 5. iii
B. 1. Portrait 2. Ctrl + I 3. F5 4. File 5. beginning, end
Section B
A. 1. Merging Cells: Combining two or more adjacent cells in the same row or column is known
as merging of cells.
Splitting Cells: Division of cells into two or more sub-cells is known as splitting of cells.
2. Paragraph spacing is the space or the gap between two paragraphs. Space can be specified
in lines or in points.
The ‘Above paragraph’ is used to increase or decrease the space between the selected
paragraph and the paragraph before the selected one whereas the ‘Below paragraph’ is
used to increase or decrease the space between the selected paragraph and the paragraph
next to selected one.
3. 0.5”.
4. Find and Replace, Ctrl + H.
5. Tools → Word Count.
6. Steps to insert a mathematical expression in a document:
Step 1: Select ‘Object’ from the ‘Insert’ menu and choose the option ‘Formula’ from the
submenu. Formula window appears on the screen.
Step 2: Right click on the ‘Edit Window’.
Step 3: Select the desired formula type.
Step 4: ‘Elements’ dialog box appears with several options. Select the desired expression
say ‘a>b’. The expression will appear as ‘<q> > <q>’ in the document and appears
as ‘<?> > <?>’ in the ‘Edit’ window. Edit the given expression as per the need in
edit & Element window.
Step 5: After inserting the expression erase the right and left angular bracket & click
anywhere in the document window to close the Edit window.
7. Header and Footer is the mark of identification or reference of the text which is displayed on
every page of a document. Header or Footer contains information such as page numbers,
date, logo of a company, title or file name of the document, etc.
Header is the repetitive text that is printed at the top of every page where as footer is the
repetitive text that is printed at the bottom of every page in a document. By default, header
or footer is printed at 0.5” gap from the edge of the page. One can apply the same header
or footer in the document or in some pages of a document.

Touchpad Information Technology-IX (Answer Key) 9

 8. Different options of Line spacing are:
Single: It provides single line spacing, according to the point size of the font. It is the
• 
default line spacing that exists in a normal document.
1.5 lines: It provides one and a half line size spacing, according to the point size of the
• 
font.
• Double: It provides double line spacing, according to the point size of the font.

At least: It sets minimum spacing between the lines. This option is useful if there are fonts
• 
and lines of different sizes in the paragraph.
• Proportional: It allows to enter a percentage value in the box for line spacing, where

100% corresponds to a single line spacing.
• Leading: It sets the height of the vertical space that is inserted between two lines.

• Fixed: It sets the line spacing to exactly match the value that is entered in the box. This

can result in cropped characters.
9. Steps to save the document in OpenOffice Writer:
Step 1: Select ‘Save As’ option from the ‘File’ menu. ‘Save As’ dialog box opens as:
Step 2: Browse the location to save the document.
Step 3: Type the ‘File name’ in the File name box.
Step 4: Click on ‘Save’ button.
10. Advantages of using Table are:
i. Visual grouping of information.
ii. Easy to find information.
iii. Efficient summarisation of information.
iv. Make data more understandable.
v. Reduce complexity of information.
B. 1. Tables
2. Footer

5. Mail Merge Unit 3: Digital Documentation

Unsolved Exercise
Section A
A. 1. ii 2. iv 3. ___ 4. ii 5. ii
B. 1. OpenOffice.org 2. Main Document 3. Data source
4. Salutation 5. Letter

10 Touchpad Information Technology-IX (Answer Key)

 Section B
A. 1. Mail Merge is a feature of Word processor like ‘Writer’, in which name and address of different
recipients are merged in one file and each address is merged with a copy of particular letter
by itself, so that the same letter is addressed to different recipients.
2. Steps to edit document in Mail Merge:
Step 1: Click on ‘Edit Document ...’ button.
‘Writer’ window appears on the screen. Here the user can modify the document.
Step 2: After editing work, click to open the previous window.
Step 3: Click on ‘Next’.
3. The main document contains the contents of the letter that remains the same for each of the
merged document, it may contain text, letter, graphics, etc. It also contains the field names
and address that retrieves names from the data source file of address.
4. WordStar, Word, Writer, Word Perfect.
5. To insert a comment to be associated with a recorded change:
Step 1: Place the cursor at the text and click on Insert Comment .
Step 2: It will display a yellow rectangular box towards the text for which comment is to
be inserted. Type the notes in the box.
B. Track changes

6. Working with Spreadsheet Unit 4: Electronic Spreadsheet

Unsolved Exercise
Section A
A. 1. i 2. iii 3. ii 4. i 5. i
B. 1. 1024 2. Format Character 3. .ods 4. three
5. Cell Pointer
Section B
A. 1. User can hide worksheet(s) of a workbook which can be displayed later. To hide a worksheet:
Step 1: Select the sheet(s) to be hidden.
Step 2: Select the option ‘Sheet’ from the ‘Format’ menu. Click on the ‘Hide’ option.
Step 3: Click on ‘OK’ Button.
2. A user can add more sheets, if required. To add new sheets in the workbook:
Step 1: Right click on ‘Sheet’ tab and select ‘Insert Sheet’ option. ‘Insert Sheet’ dialog box
appears.
Step 2: Set the position where the new sheet is to be added in the workbook.

Touchpad Information Technology-IX (Answer Key) 11

 Step 3: Specify the number and the name of sheet to be created.
Step 4: Click on the ‘OK’ button.
3. Each cell has a unique address which identifies its location. A cell address is identified with
its column position followed by its row number, for example: ‘A5’ is the cell address that is
a combination of column ‘A’ and row ‘5’.
4. The “Shrink to fit cell size” feature automatically reduces the font size in a cell so that the
text fits inside the cell without wrapping.
5. Two operations performed on the data in a spreadsheet are:
i. Use of formulae for calculations.
ii. Use of charts for pictorial display of information.
6. Formulae are entered to perform mathematical operations such as addition, subtraction,
multiplication, division, etc. Formula entry in a cell is logical entry. It shows the relationship
between different cells. In Calc or Excel, a formula always starts with an euqal (=) sign.
7. OR:  roduces true if any condition enclosed in bracket is true, otherwise it produces
P
false. Eg. =OR(5>3; 4<5;4>15) will display true.
=OR(3>6; 2<1) will display false.
AND: Produces true if all the conditions enclosed in bracket is true otherwise displays
false.
Eg.=AND (5>3; 4<5; 4>15) will display false. (As one of the condition is false)
=AND(5>3; 4<5) will display true. (As all of the conditions are true)
IF: If the condition in the statement is true, it will display the true part otherwise it will

display the false part.
Eg. =IF(4>5;4;5) will display 5 since the condition is false.
8. Given below is the list of errors which commonly occurs in ‘Calc’.

Errors Reasons

Occurs when the cell contains a number, data or time that is wider than
#### the Cell width or when the cell contains a date and/or time formula that
produces a negative result.
#VALUE Occurs when the wrong type of argument or operand is used.

#NAME Occurs when ‘Calc’ does not recognize text in a formula.

#NUM Occurs when there is a problem with a number in a formula or function.

#REF! Occurs when a cell reference is not valid.

#DIV/0! Occurs when a formula is divided by zero.

12 Touchpad Information Technology-IX (Answer Key)

 9. i. MAX( ): Produces the largest value from the given range of cells.
Eg. =MAX(10;20;15;25) Displays output:25
= MAX(A1:A5) Displays the largest value from cell A1 to A5.
= MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and
C4.
ii. AVERAGE( ): Produces the average (mean) of the given arguments.
Eg.=AVERAGE(10;20;30) Displays output: 20
=AVERAGE(A1;A2;A3) Displays the average of the cells A1, A2 and A3
=AVERAGE(A1:A10) Displays the average of the cells from the range A1
to A10
iii. COUNT(): Produces the number of arguments enclosed in small brackets.
Eg. = COUNT(1;2;15;25;3;6) Displays output :6
= COUNT(A1:A20) Displays output: 20 (If all cells i.e., A1 to A20 contains
values).
10. A group of cells is known as a cell range. A range comprises of two or more selected cells
and those selected cells need not be adjacent to each other.
Vertical/Column Range: Column range is the number of selected cells spread across the
• 
column.
Horizontal/Row Range: Row range is the number of selected cells spread across the
• 
row.
Mixed Range: Mixed range is the number of selected cells spread across the row and
• 
column.
B. 1. Spreadsheet
2. E9

7. Formatting Cells in Spreadsheet

Unit 4: Electronic Spreadsheet

Unsolved Exercise
Section A
A. 1. i 2. iv 3. i 4. iii 5. i
B. 1. Format Cells 2. Formatting tool 3. Formatting
4. Auto Fill 5. Chart

Touchpad Information Technology-IX (Answer Key) 13

 Section B
A. 1. Steps to insert a chart in calc are:
Step 1: Select the data.
Step 2: Select the ‘Chart’ option from the ‘Insert’ menu.
Step 3: Select any type of chart from the list.
Step 4: Click on ‘Next’.
Step 5: Enter appropriate range of cells. (To alter the range click on the ‘Data Range’
option.)
Step 6: Select the range of cells to display chart.
Step 7: Click on ‘Next’ button.
Step 8: Select the data range from the list for Name and Y-Values.
Step 9: Edit data series from other cells.
Step 10: Click on ‘Next’.
Step 11: Mention the title and subtitle of the chart.
Step 12: Click on the check box.
Step 13: Click on ‘Display Legend’ checkbox and set the position.
Step 14: Click on ‘Finish’.
2. The two operations that can be performed on data in a spreadsheet are:
i. Use of formulae for calculations.
ii. Use of charts for pictorial display of information.
3. Formulae are entered to perform mathematical operations such as addition, subtraction,
multiplication, division, etc. Formula entry in a cell is logical entry. It shows the relationship
between different cells. In Calc or Excel, a formula always starts with an euqal (=) sign.
4. Default, Left, Right, Center, Filled, Justified.
5. Cell can be formatted to hold different version of time. To do so:
Step 1: Select the range of cells.
Step 2: Click on the ‘Format’ menu and then select ‘Cells’ option. ‘Format Cells’ window
appears on the screen.
6. Steps to format font of a cell content in a worksheet are:
Step 1: Select the contents of cell or range of cells.
Step 2: Select the option ‘Cells’ from the ‘Format’ menu. ‘Format Cells’ dialog box opens.
Step 3: Click on the ‘Font’ tab.
Step 4: Select the appropriate Font, Typeface, Size.
Step 5: Click on ‘Font Effects’ tab to select the appropriate option of Font color, Overlining,
Strikethrough, etc.

14 Touchpad Information Technology-IX (Answer Key)

 Step 6: Click on the ‘OK’ button to implement the changes.
7. It is an additional feature in spreadsheet package like ‘Calc’ in which a certain kind of
predefined series of data such as name of months of a year, serial numbers, etc. are
automatically generated once the user feeds the initial data.
8. Data Series is the range of cells selected to create a chart in Calc.
9. To create a Custom list:
Step 1: Select ‘Options’ from the ‘Tools’ menu. ‘Options’ dialog box appears on the screen.
Step 2: Click on the ‘+’ beside OpenOffice Calc.
Step 3: Click to display predefined series of list.
Step 4: To generate own list, click on the ‘New’ button.
Step 5: Fill the series in entries section and then click on ‘Add’ button to insert the user
defined entries in the list, then click on ‘OK’ button.
10. The contents will be displayed within the column width only. The data which does not get
accommodated in the cell width will be hidden in the cell.
B. 1. Formulae
2. Column/Bar Chart

8. Working with Presentation Unit 5: Digital Presentation

Unsolved Exercise
Section A
A. 1. i 2. iii 3. iv 4. i 5. iv
B. 1. Presentation 2. Slide Pane 3. Workspace 4. Alt + I + E
5. Home, End
Section B
A. 1. i. Spelling and Grammar ii. Zoom iii. Slide Show iv. Font Size
2. Presentation package can be used for different purposes like:
On-Screen Presentation: Presentation packages can be used to create exciting and
• 
effective on-screen presentations that can be displayed through LCD projectors or LED
TVs. They include movies, sounds, animations, etc.
Web Presentation: Presentation package can be used for displaying presentation on
• 
web. Thus, presentation can be made accessible to people staying in remote places of
the world.
35 mm Slides: The electronic slides or pages can be used to make 35mm slides for
• 
different purposes.

Touchpad Information Technology-IX (Answer Key) 15