Class: 9, Subject: Computer Science, Board: SEBA, Chapter: 3 – Office Application, Topics: MS-Word, MS-Excel and MS-PowerPoint

Class 9 Computer Science Chapter 3 SEBA, Class 9 Computer Science Chapter 3 question answers, Office Application Class 9 SEBA, MS Word MS Excel MS PowerPoint Class 9, Class 9 Computer Science Office Application

Class 9 Computer Science Chapter 3 SEBA : Office Application

This chapter covers three important office applications: MS-Word, MS-Excel and MS-PowerPoint. These applications are commonly used for creating documents, performing calculations, analysing data and preparing presentations.

Below are the important Class 9 Computer Science Chapter 3 question answers for SEBA, including fill in the blanks, multiple-choice questions, short-answer questions and long-answer questions.

Part 1 : MS-Word

1. Fill in the Blanks:

1. Alignment buttons are available on the ______ tab.

Answer: Home

2. ______ is the rectangular area of the document window where you type your text.

Answer: Work Area

3. Portrait format changes the page orientation ________.

Answer: vertically

4. ______ command is used to move text to a new page.

Answer: Page Break

5. Each individual rectangle in a table is called a ______.

Answer: Cell

6. ______ option is used to see how a document will look before printing.

Answer: Print Preview

2. Multiple Choice Questions:

1. Which extension is given to a document in MS-Word 2007?

a) .xls
b) .pptx
c) .docx
d) .txt

Answer: c) .docx

2. The status of your document, such as the current page and total number of pages, is shown on the:

a) Title Bar
b) Status Bar
c) Ribbon
d) Menu Bar

Answer: b) Status Bar

3. The general arrangement and design of text in a document is called:

a) Editing
b) Alignment
c) Formatting
d) Printing

Answer: c) Formatting

4. The ______ alignment makes sure that none of the edges of text appear ragged.

a) Left
b) Centre
c) Right
d) Justify

Answer: d) Justify

5. Line spacing or paragraph spacing may be measured in terms of lines or points, which is known as ________.

a) Margin
b) Indent
c) Leading
d) Alignment

Answer: c) Leading

6. Header and Footer are inserted at the ______ of the document.

a) Top and bottom
b) Left and right
c) Centre and bottom
d) Left and top

Answer: a) Top and bottom

3. Answer the following:

Q1. How do you locate MS-Word 2007 on your computer system?

Answer: The steps to locate MS-Word 2007 are:-

Click the Start button on the Taskbar.
Click All Programs.
Click the Microsoft Office folder.
Click Microsoft Office Word 2007.

Q2. What is formatted text?

Answer: Formatted text is text whose appearance has been changed to make it clear, attractive and easy to read. Formatting may include changing the font style, font size, text colour, bold, italic, underline and text alignment.

Q3. What is Mail Merge?

Answer: Mail Merge is a feature of MS-Word that allows us to create multiple personalised documents at once by combining a main document with a data source containing information such as names and addresses.

It can be used to create letters, envelopes, labels and other personalised documents.

Q4. What is a Data Source?

Answer: A Data Source is a file or list containing information such as names, addresses, phone numbers and other details that are used in Mail Merge.

For example, a spreadsheet or database can be used as a data source for a Mail Merge.

Q5. What are Table Styles?

Answer: Table Styles are ready-made designs that can be applied to a table. They may include different borders, colours, shading and formatting to make a table neat and attractive.

Q6. Write the name of alignments, which are available in MS-Word 2007.

Answer: The name of alignments in MS-Word 2007 are:-

Left Alignment
Centre Alignment
Right Alignment
Justified Alignment

In justified alignment, text is aligned with both the left and right margins.

Q7. What is the difference between the Save and Save As option?

Answer: The difference between the Save and Save As option:-

Save: Used to save changes made to the current document.
Save As: Used to save a document with a different file name, location or file format.

Q8. Write the steps to insert WordArt text in a document.

Answer: The steps to insert WordArt text in a document:-

Click the Insert tab.
Click WordArt in the Text group.
Select a WordArt style from the gallery.
Type the required text.
Format the WordArt as required.

Q9. What is the need to modify the spacing of the lines or paragraph of yours text?

Answer: Line or paragraph spacing can be adjusted to make a document clearer, neater and easier to read. Proper spacing also improves the overall appearance of the document.

Q10. How do you insert a table in your document?

Answer: The steps to insert a table in MS-Word 2007:-

By using the Table Grid

Place the cursor where you want to insert the table.
Click the Insert tab.
Click Table.
Select the required number of rows and columns from the grid.
Click to insert the table.

Or,

By using the Insert Table option

Click Insert → Table → Insert Table.
Enter the required number of columns and rows.
Click OK.

Class 9 Computer Science Chapter 3 SEBA, Class 9 Computer Science Chapter 3 question answers, Office Application Class 9 SEBA, MS Word MS Excel MS PowerPoint Class 9, Class 9 Computer Science Office Application

Part 2 : MS-Excel

1. Fill in the Blanks:

1. Excel is a ______ software package.

Answer: Spreadsheet

2. Address of the cell at 10th column and 30th row is _____.

Answer: J30

3. The cell having bold boundary is the _____.

Answer: Active cell

4. Any formula in Excel starts with an______.

Answer: Equals (=)

5. In ______ referencing, the relative address of the cell gets adjust with respect to the current cell.

Answer: Relative

6. For absolute referencing, ____ sign is used before the parts of formula.

Answer: $

7. If you enter 15+30 in a cell, Excel will display ______.

Answer: 15+30

8. ____ are text , number cell references enclosed within parenthesis in a formula.

Answer: Arguments

2. Multiple Choice Questions:

1. A worksheet is a …………

a) Combination of columns only
b) Combination of rows only
c) Combination of rows and columns
d) Collection of charts

Answer: c) Combination of rows and columns

2. By default, a workbook in Excel contains how many worksheet?

a) 1
b) 3
c) 5
d) 10

Answer: b) 3

3. The AutoFill can apply from:

a) Left to right
b) Right to left
c) Top to bottom
d) All of these

Answer: d) All of these

4. The default page orientation in Excel is:

a) Landscape
b) Square
c) Portrait
d) Horizontal

Answer: c) Portrait

5. The default page orientation in Excel is:

a) Left
b) Right
c) Centre
d) Justified

Answer: a) Left

6. Cell address $B$2 in a formula means:

a) Relative reference
b) Absolute reference
c) Mixed reference
d) Invalid reference

Answer: b) Absolute reference

7. A cell range starting from first row, first column to fourth row and fifth column can be represented as

a) [A1 : E4]
b) [A0 : E3]
c) [E4 : A1]
d) [E3 : A0]

Answer: a) [A1 : E4]

8. COUNTA(4, 78, False, 18) will return ………

a) 3
b) 0
c) 4
d) 78

Answer: c) 4

9. Which of the following charts is used for comparing the changes in data over a period of time?

a) Pie Chart
b) Bar Chart
c) Column Chart
d) Line Chart

Answer: d) Line Chart

A line chart is commonly used to show trends and changes over time.

10. For selecting non-continuous range of Cells, you need to do what?

a) Press Alt key
b) Press Shift key
c) Press Esc key
d) Press Ctrl key

Answer: d) Press Ctrl key

3. Answer the following :

Q1. Define the term Workbook.

Answer: A Workbook is an Excel file that contains one or more worksheets. It can be compared to a notebook containing several individual pages.

Q2. 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.

Answer: An Active Cell is the currently selected cell in a worksheet. It can be identified by the thick border around the cell.

Q3. What is the default alignment of number, text and formula in a spreadsheet?

Answer: The default alignment is generally:

Text: Left-aligned
Numbers: Right-aligned
Formula results: Usually aligned according to the type of result. A numerical result is generally right-aligned, while a text result is generally left-aligned.

Q4. 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?

Answer: The cell address is I1. The first row is 1 and ninth column is I.

Q5. How many cells would be there in the cell range [A1 : B2]?

Answer: There are 4 cells (A1, A2, B1, B2).

Q6. If = 6-5*2 is entered in a cell, than what will be the cell content?

Answer: The result will be – 4.

Q7. 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?

Answer: The formula copied into B3 is =B1 + $A$2.

Q8. Write down the formula for adding values of cells A1 to A5.

Answer: =SUM ( A1 : A5 ).

Q9. State difference between COUNT( ) and COUNTA( ) function.

Answer:

COUNT( ): Counts cells containing numbers.
COUNTA( ): Counts all non-empty cells, including numbers, text and logical values.

Q10. Write down the importance of legend in charts.

Answer: A Legend explains the colours, patterns or symbols used for different data series in a chart. It helps the reader understand what each data series represents.

Q11. What is the difference between a workbook and a worksheet?

Answer: The difference between a workbook and a worksheet:-

Worksheet: A worksheet is a single spreadsheet containing rows and columns where data can be entered, edited and processed.
Workbook: A workbook is an Excel file that contains one or more worksheets.

Q12. Define the meaning of formula.

Answer: A formula is used to perform calculations in Excel. It usually starts with an equals sign (=).

Q13: Suggest the appropriate function for the following situations (Write answers of Q14 and Q15):

Q14. Write the formula to find the maximum value in the range A1 to B20.

Answer: =MAX ( A1 : B20 )

Q14. Calculating average of marks entered in cells E5, F5, G5, H5 and I5.

Answer: =AVERAGE ( E5 : I5 )

Q15. Akriti has entered 49+30 in a cell, The worksheet is not displaying 79 in the cell, Instead Excel 49+30 is getting displayed. Help, Akriti in rectifying the problem?

Answer: She should enter an equals sign (=) before the calculation.

For example: =49+30.

Q16. For what purpose pie charts are useful?

Answer: A Pie Chart shows the size of different items in a data series in proportion to the total value of all the items.

Q17. Explain the concept of cell referencing along with its various types.

Answer: Cell referencing means using the address of a cell in a formula.

There are three types of cell referencing:–

Mixed Reference: Either the row or the column remains fixed, while the other part can change.
Example: $A1 or A$1

Relative Reference: The cell reference changes when the formula is copied to another cell.
Example: A1

Absolute Reference: The cell reference does not change when the formula is copied to another cell.
Example: $A$1

Class 9 Computer Science Chapter 3 SEBA, Class 9 Computer Science Chapter 3 question answers, Office Application Class 9 SEBA, MS Word MS Excel MS PowerPoint Class 9, Class 9 Computer Science Office Application

Part 3: MS-PowerPoint 2007

1. Fill in the Blanks

1. An electronic page in a presentation is called a ______.

Answer: Slide

2. New Slide button for inserting a new slide can be found on ______ tab.

Answer: Home

3. In ________ view, you can see all the slides in a presentation concurrently.

Answer: Slide Sorter

4. _____ is a special effect that allows to specify how to navigate from one slide to other.

Answer: Transition

5. The _____ Animation enhance uses the flying effect on the text and character.

Answer: Custom Animation

2. Multiple Choice Questions :

1. ____ is the default file name for a Power point presentation.

a) Untitled 1
b) Book 1
c) Presentation1
d) Document 1

Answer: c) Presentation1

2. File extension for a PowerPoint 2007 presentation is _____.

a) .Ptt
b) .pptx
c) .docx
d) .clsx

Answer: b) .pptx

3. The custom animation can apply____.

a) Font work gallery
b) Gallery
c) Text
d) All of these

Answer: d) All of these

4. The entire presentation can be seen at a time in ______.

a) Slide Show view
b) Outline view
c) Normal view
d) Slide Sorter View

Answer: d) Slide Sorter View

5. Special effect used to introduce slides in a presentation are ____.

a) Transitions
b) effects
c) custom animations
d) annotations

Answer: a) Transitions

3. Answer the following :

Q1. Write down the name of default view in a PowerPoint presentation.

Answer: Normal View is the default view in a PowerPoint presentation.

Q2. Difference between a presentation and a slide.

Answer:

Slide: A slide is a single page or screen of a PowerPoint presentation. It can contain text, pictures, charts, tables, and other information.
Presentation: A presentation is a complete PowerPoint file that consists of one or more slides arranged to present information on a topic.

Q3. Write use of layouts in PowerPoint.

Answer:

Slide Layouts: Slide layouts are pre-designed arrangements of placeholders for content such as titles, text, tables, charts, pictures, and other objects. They help to organise the content of a slide neatly and clearly.

Q4. In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button?

Answer: A Text Box is used to add text anywhere on a slide. It is useful for placing text outside the standard placeholders of the slide layout.

Q5. Animation is a feature, which you can use in your presentation. What is the purpose of this feature?

Answer: Animation is used to add visual effects to individual objects on a slide, such as text, pictures, and shapes. It helps present information step by step and makes the presentation more attractive.

Q6. Write three functions that can be performed in slide Sorter view of a presentation.

Answer: Three useful features of Slide Sorter View are:

The entire presentation can be seen at a time.
It makes it easy to review, delete, or duplicate slides.
It allows slides to be easily rearranged using drag and drop.

Q7. How are Header and Footer useful?

Answer: Headers and footers are useful for adding information such as the date, slide number, presentation title, or other details to slides. They help keep the presentation organised and informative.

Q8. What is the difference between Slide Transition and Custom Animation?

Answer: The difference between Slide Transition and Custom Animation :-

Slide Transition: A visual effect that occurs when moving from one slide to another.
Custom Animation: A visual effect applied to individual objects on a slide, such as text, pictures, or shapes.

Q9. Explain the four main slide views in PowerPoint 2007.

Answer: The four important views in PowerPoint 2007 are :–

Normal View: Normal View is the default view used to create and edit slides. It also displays thumbnails of the slides.
Slide Sorter View: Slide Sorter View displays thumbnails of all the slides. It is useful for rearranging, deleting, and reviewing slides.
Slide Show View: Slide Show View displays the presentation in full-screen mode as it will appear to the audience.
Notes Page View: Notes Page View displays a slide along with an area where the presenter can add speaker notes.

Related to Class 9 Computer Science Chapters of SEBA:

Important Points to Remember :

For Class 9 Computer Science Chapter 3 – Office Application SEBA, students should remember the following important terms and concepts for examination preparation:

MS Word: A word-processing application used to create, edit and format documents.
Formatting: Changing the appearance of text or a document, such as font, size, style and alignment.
Mail Merge: A feature used to create multiple personalised documents from a common document and data source.
Data Source: Contains the information, such as names and addresses, used in Mail Merge.
Table: A structure made up of rows, columns and cells used to organise information.
MS Excel: A spreadsheet application used for calculations, data organisation and analysis.
Workbook: An Excel file that contains one or more worksheets.
Worksheet: A spreadsheet containing rows and columns in which data is entered.
Active Cell: The currently selected cell in a worksheet.
Relative Reference: A cell reference that changes when a formula is copied to another cell.
Absolute Reference: A cell reference that remains fixed when a formula is copied.
Mixed Reference: A cell reference in which either the row or the column remains fixed while the other part changes.
Formula: An expression used to perform calculations in Excel. It normally begins with the = (equal) sign.
Pie Chart: A chart used to show how different parts contribute to a whole.
Line Chart: A chart used to show trends or changes in data.
MS PowerPoint: An application used to create and display presentations.
Slide: A single page or screen of a PowerPoint presentation.
Slide Transition: A visual effect that occurs when moving from one slide to another.
Animation: A visual effect applied to individual objects such as text, pictures or shapes on a slide.
Slide Sorter View: A view that displays multiple slides as thumbnails and helps in arranging and reviewing slides.
Normal View: The default view used to create and edit PowerPoint slides.

Class 9 Computer Science Chapter 3 SEBA, Class 9 Computer Science Chapter 3 question answers, Office Application Class 9 SEBA, MS Word MS Excel MS PowerPoint Class 9, Class 9 Computer Science Office Application

Quick Revision for Class 9 Computer Science Chapter 3

Students preparing for Class 9 Computer Science Chapter 3 question answers SEBA should understand the basic features and uses of MS Word, MS Excel and MS PowerPoint. Special attention should be given to Mail Merge, tables, Excel formulas and cell references, charts, PowerPoint views, slide transitions and animations.

These important points can help students revise Class 9 Computer Science Chapter 3 – Office Application quickly before examinations.