Looking for accurate SEBA Class 9 Computer Science Chapter 3 (Office Automation Tools / Word Processing) textual solutions for the 2026–27 academic year? Access complete step-by-step solutions covering word processing features, document editing, formatting, table insertion, headers/footers, page setup, and mail merge concepts to score top marks in your annual exams.
Part I
FILL IN THE BLANKS
(a) Alignment buttons are available on the _ tab.
Ans. Home.
(b) __ is the rectangular area of the document windows, where user can type his/her content.
Ans. Work area or work space.
(c) Portrait format changes the page orientation __.
Ans. Vertically.
(d) _ command is used to move the text to a new page.
Ans. Page break.
(e) Each individual rectangle in a table is called _.
Ans. Cell.
(f) __ option is used to display a document before printing.
Ans. Print preview.
SEBA Class 9 Computer Science Chapter 3 Solutions
Choose the correct option.
(a) Which extension is given to a document by default in MS-Word
(1) .odt
(2) .com
(3) .docx
(4) .pdf
Ans. (3) .docx.
(b) The status of your document like current page and number of pages are given by _.
(1) Formatting toolbar
(2) Status bar
(3) Standard toolbar
(4) Formatting bar
Ans. (2) Status bar.
(c) The general arrangement of the text in the document is _.
(1) margin
(2) text alignment
(3) Justify
(4) formatting
Ans. (4) formatting.
(d) The __ alignment makes sure that none of the edges of text appear ragged.
(1) left
(2) right
(3) center
(4) justify
Ans. (4) justify.
(e) Line spacing or paragraph spacing is measured in terms of lines or points, which is know as __.
(1) text wrapping
(2) PDF
(3) leading
(4) indent
Ans. (3) Leading.
(f) Header and Footer are inserted at the __ of a document.
(1) top and bottom
(2) left and right
(3) center
(4) indent
Ans. (1) top and bottom.
Short answer questions.
1.How do you locate MS-Word 2007 on your computer system?
Ans: To open MS-Word on your computer:
i) Click Start.
ii) Go to All Programs.
iii)Find Microsoft Office.
iv) Select Microsoft Office Word 2007.
2.What is formatted text?
Ans: Text formatting means changing the style or appearance of text without altering the words.
3.What is Mail Merge?
Ans: Mail merge is a way to use data from a database or spreadsheet to create personalized documents like letters, labels, or name tags.
4.What is a Data Source?
Ans: A data source is a file like a document, spreadsheet, or database that holds personal details like names, addresses, and phone numbers.
5.What are Table Styles?
Ans: A table style is a set of formatting options for tables, like borders and lines between rows and columns, applied in one step. A cell style includes settings like spacing inside cells, text formatting, and colors or lines for the cells.
6.Write the name of alignments, which are available in MS-Word 2007.
Ans: The four main types of text alignment are:
i) Left – Text lines up on the left side.
ii) Right – Text lines up on the right side.
iii) Center – Text is placed in the middle.
iv) Justified – Text is evenly spread between the left and right margins.
7.What is the difference between the Save and Save As option?
Ans: Save lets you keep changes to a document in the same place with the same name. Save As lets you save the document with a new name or in a new location.
8.Write the steps to insert WordArt text in a document.
Ans: Steps to insert WordArt text in a document:
i) Go to the Insert tab and click on WordArt in the Text group.
ii) Choose a style you like from the WordArt Gallery.
iii) Type your text in the box that appears.
iv) To format, select the font or size you want from the drop-down lists.
9.What is the need to modify the spacing of the lines or paragraph of yours text?
Ans: Line spacing is the space between lines of text. Wider spacing makes text easier to read, while narrower spacing helps fit more text in a smaller area. To adjust line spacing, select the text you want to change.
10.How do you insert table in your document?
Ans: To insert a table in a document:
i) Click Insert > Table.
ii) Move your cursor over the grid to choose the number of columns and rows you need.
iv) For bigger or custom tables, click Insert > Table > Insert Table.
Tip: If you have text separated by tabs, you can convert it into a table easily.
Class 9 Computer Science Chapter 3 Question Answer SEBA 2026-27
Part II
FILL IN THE BLANKS
(a)Excel is a _ software package.
Ans. spreadsheet.
(b)Address of the cell at 10th column and 30th row is _.
Ans. J30.
(c)The cell having bold boundary is the _.
Ans. active cell.
(d)Any formula in Excel starts with an______.
Ans. equal (=) sign.
(e)In __ referencing, the relative address of the cell gets adjust with respect to the current cell.
Ans. relative.
(f)For absolute referencing, __ sign is used before the parts of formula.
Ans. $ .
(g)If you enter 15+30 in a cell, Excel will display __.
Ans. 15+30.
(h)__ are text , number cell references enclosed within parenthesis in a formula.
Ans. Arguments.
Choose the correct option.
(a)A worksheet is a __
(1)collection of workbooks
(2)processing software
(3)combination of rows and columns
(4)None of the above
Ans.(1) collection of workbooks.
(b)By default, a workbook in Excel contains how many worksheet?
(1)16
(2)3
(3)15
(4)256
Ans.(2) 3.
(c)The AutoFill can apply from.
(1)left to right
(2)right to left
(3)up to down
(4)All of these
Ans.(4) All of these.
(d)The default page orientation in Excel is.
(1)Landscape
(2)Horizontal
(3)Portrait
(4)None of these
Ans.(3) Portrait.
(e)The default alignment of text in a cell is
(1)Left
(2)Right
(3)Centred
(4)Justified
Ans.(1) Left.
(f)Cell address $B$5 in a formula means
(1)it is a mixed reference
(2)it is an absolute reference
(3)it is a relative reference
(4)None of the above
Ans.(2) it is an absolute reference.
(g)A cell range starting from first row, first column to fourth row and fifth column can be represented as
(1)[A1 : E4]
(2)[E3 : E3]
(3)[E4 : A1]
(4)[E3 : AO]
Ans.(1) [A1 : E4].
(h)COUNTA (4,78, False,18) will return_____
(1)2
(2)3
(3)4
(4)5
Ans.(3) 4.
(i)Which of the following charts is used for comparing the changes in data over a period of time?
(1)Bar chart
(2)Area chart
(3)Scatter chat
(4)Line chart
Ans.(4) Line chart.
(j)For selecting non-continuous range of Cells, you need to do what?
(1)Press Alt key
(2)Press Shift
(3)Press Esc key
(4)Press Ctrl key
Ans.(4) Press Ctrl key.
Office Automation Tools Class 9 SEBA Chapter 3 Solutions
DESCRIPTIVE TYPE QUESTIONS
1.Define the term workbook.
Ans: A workbook is a file that holds one or more sheets where you can organize your data.
2.Rohan is new to Excel. His instructor has asked her to open Excel on PC and questioned about active cell. Help Rohan in identifying the active cell on his screen.
Ans: The active cell in Excel is highlighted with a rectangular box around it, and its address (like A1, B2) is shown in the address box.
3.What is the default alignment of number, text and formula in a spreadsheet?
Ans: By default, text or labels are aligned to the left, and numbers and formulas are aligned to the right in a spreadsheet.
4.Sahil has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell?
5.How many cells would be there in the cell range [A1; B2]?
Ans: The address of the cell Sahil selected, which is at the intersection of the first row and the ninth column, is I1.
6.If = 6-52 is entered in a cell, than what will be the cell content?
Ans: – 4.
7.In a spreadsheet software, the formula = A1 + $A$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3?
Ans: B1 + $A$2.
8.Write down the formula for adding values of cells A1 to A5.
Ans: = SUM (A1 : A5).
9.State difference between COUNT () and COUNTA () function.
Ans: COUNT() is used to count only cells with numbers or dates.
COUNTA() counts all non-empty cells, including text, numbers, dates, and even errors. It counts every value, whether it’s a number, text, or Boolean (TRUE/FALSE).
10.Write down the importance of legend in charts.
Ans: A legend in charts explains what each part of the chart means, helping the reader understand the symbols, colors, or markings that are used. It provides clarity for elements that may be unfamiliar.
11.What is the difference between a workbook and a worksheet?
Ans: WORKBOOK is a file that holds multiple WORKSHEETS.
Adding one workbook to another is complicated, while adding new worksheets to a workbook is simple.
WORKBOOK helps in organizing and managing related data, while WORKSHEET stores and works with that data.
WORKBOOK is used for storing and organizing data, while WORKSHEET is where data is entered, calculated, and analyzed.
12.Define the meaning of formula
Ans: In Excel, a formula is a calculation that works with the values in one or more cells. For example, =A1+A2+A3 adds the values in cells A1, A2, and A3.
13.Suggest the appropriate function for the following situations :
Ans: = MAX (A1 : B20).
14.Selecting the maximum value out of a range
15.Calculating average of marks entered in cells E5, F5, G5, H5 and I5.
Ans: = AVERAGE (E5 : I5).
16.Akriti has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. Instead, 49+30 is
Ans: Akriti didn’t start the formula with an equal sign (=). To get the correct result, she should write the formula as =49+30.
17.For what purpose pie charts are useful?
Ans: Pie charts are useful for showing how parts make up a whole, representing percentages at a specific moment.
18.Explain the concept of cell referencing along with its various types.
Ans: In Excel, there are three types of cell references:
i) Relative Referencing: This type of reference changes automatically when you copy the formula to a new cell. For example, =B4-C4 in cell D4 will change to =B5-C5 when copied to D5.
ii) Absolute Referencing: The reference stays fixed when you copy the formula. For example, $D$9 will not change no matter where you copy the formula.
iii) Mixed Referencing: This type has one part fixed (either the column or the row) and the other part changes. For example, $A1 means the column A is fixed but the row 1 can change. The fixed part stays the same, but the other part adjusts when copied.
SEBA Class 9 Computer Science Ch 3 Textbook Answers
Part III
FILL IN THE BLANKS
(a)An electronic page in a presentation is called _.
Ans. slide.
(b)New Slide button for inserting a new slide can be found on __ tab.
Ans. Home.
(c)In __ view, you can see all the slides in a presentation concurrently.
Ans. slide sorter.
(d)_ is a special effect that allows to specify how to navigate from one slide to other.
Ans. Transition.
(e)The _ Animation enhance uses the flying effect on the text and character.
Ans. custom.
Choose the correct option.
(a)__ is the default file name for a Power point presentation.
(1)Untitled 1
(2)Book 1
(3)Presentation 1
(4)Document 1
Ans.(3) Presentation 1.
(b)File extension for a PowerPoint 2007 presentation is _
(1).Ptt
(2).pptx
(3).docx
(4).clsx
Ans.(2) .pptx.
(c)The custom animation can apply____
(1)Font work gallery
(2)Gallery
(3)Text
(4)All of these
Ans.(4) All of these.
(d)The entire presentation can be seen at a time in __
(1)Slide Show view
(2)Outline view
(3)Normal view
(4)Slide Sorter view
Ans.(4) Slide Sorter view.
(e)Special effect used to introduce slides in a presentation are __
(1)transitions
(2)effects
(3)custom animations
(4)annotations
Ans.(1) transitions.
Class 9 Computer Science Office Automation Word Processing Solutions
Short answer questions.
1.Write down the name of default view in a PowerPoint presentation.
Ans: Normal view.
2.Difference between a presentation and a slide.
Ans: Presentation is created using software like PowerPoint.
A slide is a single page in that presentation.
Presentation refers to the whole PowerPoint file. It doesn’t mean the display on the screen.
A slide refers to what is shown during the presentation, and the term “slide show” is used when presenting the slides on the screen.
3.Write use of layouts in PowerPoint.
Ans: Slide layouts define how the content is arranged and formatted on a slide. Placeholders are the dotted boxes on the slide layout that hold different types of content, such as titles, text, images, charts, videos, and sounds.
4.In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button?
Ans: In PowerPoint 2007, the Text Box button allows you to add text to a slide or slide master. You can type inside the text box and then format the text or the whole box.
5.Animation is a feature, which you can use in your presentation. What is the purpose of this feature?
Ans: The Animation feature in PowerPoint adds visual effects to your presentation. It helps draw attention to specific items. For example, you can animate a bulleted list or clip art so each item appears one at a time when you click the mouse.
6.Write three functions that can be performed in slide Sorter view of a presentation.
Ans: In Slide Sorter view, you can:
i) View all the slides in your presentation at once.
ii) Change the order of slides by dragging them.
iii) Remove or delete a slide by selecting it and pressing the Delete key.
7.How are Header and Footer useful?
Ans: Headers and footers show important information on each page, like the file name, author, date, and page numbers. This makes it easier for the reader to follow and navigate the document.
8.Differentiate between Slide Transition and custom Animation.
Ans: Slide Transitions are effects that happen when you move from one slide to the next in a presentation.
Custom Animations are effects applied to specific objects on a slide, like text, images, or shapes.
Slide Transitions affect the whole slide, while Custom Animations target individual objects on the slide.
9.Explain the various views of a slide available in PowerPoint 2007.
Ans: PowerPoint has five main views that help in creating and presenting slides:
i) Normal View: The main view for designing your presentation, where you create and edit slides.
ii) Slide Sorter View: Displays slides as small thumbnails, making it easy to organize and sort them in order.
iii) Notes Page View: Shows the slide and allows you to add notes that are related to the current slide.
iv) Slide Show View: Displays how your presentation will look during the actual show, including animations and transitions. You can exit by pressing the Esc key.
v) Master View: Includes different master views for slides, handouts, and notes, allowing you to set uniform design and style across all slides.
💻 Updated Solutions Notice: This page features complete, step-by-step SEBA Class 9 Computer Science Chapter 3 (Office Automation Tools) Textual Solutions updated for the 2026–27 academic session. All word processing exercises, shortcut keys, document formatting steps, and practical activity questions strictly follow the latest revised Assam Board curriculum.
💡 Master Class 9 Computer Science Concepts:
- Having difficulty understanding text formatting, table manipulation, or mail merge steps in Chapter 3? Drop your questions in the comments section below!
- Save and bookmark this solution guide for quick reference before your unit tests, mid-term, and annual computer practical and theory examinations.
- Share this link with your classmates and WhatsApp study groups to help them excel in computer science!