Class 9 computer science under SEBA | chapter 3 Office Application

Class 9 computer science under SEBA | chapter 3 Office Application

Class 9 computer science under SEBA chapter 3 Office Application exercise questions answers are given below-

Exercise :

1. Fill in the blanks:

1. Alignment buttons are available on the __________ tab.

Ans: Home

2. ___________ is the rectangular area of the document window, where user can type his/ her content.

Ans: work space/ work area

3. Portrait format changes the page orientation ____________

Ans: vertically

4. ______________________ command is used to move the text to a new page.

Ans: Page Break

5. Each individual rectangle is a table is called _______________

Ans: Cell

6. ___________________ option is used to display a document before printing.

Ans: Print Preview

2. Multiple Choice Questions:

1. Which extension is given to a document by default in MS Word ?

Ans: .docx

(a) .odt (b) .com (c) . docx

2. The status of your document like current page and number of pages are given by _____________

(a) Formatting toolbar (b) Status bar (c) Standard toolbar

Ans: Status bar.

3. The general arrangement of the text in the document is _______________

(a) margin (b) text alignment (c) formatting

Ans: formatting

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

(a) left (b) right (c) center (d) justify

Ans: justify

5. Line spacing or paragraph spacing is measured in terms of lines or points which is known as ___________

(a) text wrapping (b) PDF (c) leading

Ans: leading

6. Header and Footer are inserted at the ___________________ of a document.

(a) top and bottom (b) left and right (c) center

Ans: top and bottom.

3. Answer the following-

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

Ans: We can locate MS Word 2007 on your computer system wth the following steps-

i. First we have to click on start button located on the task bar. A menu will be displayed.

ii. we have to click on ‘all programs’ option in the menu. again a sub menu will appear.

iii. we have to click on MS Office option

iv. finally we have to click on MS Word 2007 option.

2. What is formatted text ?

Ans: Formatted text is a text created by modifying the existing general text such as changing the color of the text, increasing/decreasing size of the text, changing font of the text, making it bold, italic, applying underline, applying shadow etc. to make the document more appealing and draw the reader’s attention.

3. What is Mail Merge ?

Ans: Mail Merge is a useful tool in a word processing software that allows us to easily produce multiple letters, labels, envelopes and more using information stored in a list, database or spreadsheet.

4. What is Data source ?

Ans: Data source is the repository of data such as document or spreadsheet . It consists of a mailing list which contains the contact details such as address, city, town, pin code etc. of all the recipients.

5. What are Table styles ?

Ans: Table styles are the predefined designs which are applied to existing tables to make it look attractive.

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

Ans: The name of alignments which are available in MS Word 2007 are left, right, center and justify.

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

Ans: The difference between the Save and Save As option are as follows-

The Save option is used to save the modifications done to an existing file/document whereas the Save As option is used to save a file for the first time or to save an existing file with another name.

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

Ans: The steps to insert WordArt text in a document are as follows-

i. Click on Insert tab

ii. Click WordArt option in the Text group

iii. Click any desired WordArt style

iv. Enter the text.

9. What is the need to modify the spacing of the lines or paragraph of your text ?

Ans: There is a need to modify the spacing of the lines or paragraph of our text to increase the readability of the document.

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

Ans: A table can be inserted in a document by 3 ways

i. By drawing in a document.

ii. By entering the no. of rows and columns in boxes.

iii. By dragging in a document.

3.5 INTRODUCTION TO SPREADSHEET

EXERCISE

1. Fill in the blanks :

1. Excel is a _________________________ software package.

Ans: MS Office

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

Ans: J30

3. The cell having bold boundary is the _______________________________

Ans: Active cell.

4. Any formula in Excel starts with an ____________________

Ans: =

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

Ans: Relative

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

Ans: $ (dollar)

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

Ans: 15 + 30

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

Ans: Arguments.

2. Multiple Choice Questions:

1. A worksheet is a ___________________

a. collection of workbooks

b. processing software

c. combination of rows and columns

d. None of the above.

Ans : combination of rows and columns.

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

a. 16

b. 3

c. 15

d. 256

Ans: 3

3. The Autofill can apply from

a. left to right

b. right to left

c. up to down

d. All of these.

Ans: All of these.

4. The default page orientation in Excel is

a. Landscape

b. Horizontal

c. Portrait

d. None of these.

Ans: Portrait.

5. The default alignment of text in a cell is

a. Left

b. Right

c. Centered

d. Justified

Ans: Left

6. Cell address $B$5 in a formula means-

a. It is a mixed reference

b. It is an absolute reference

c. It is a relative reference

d. None of the above.

And: It is an absolute reference.

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

a. [A1:E4]

b. [A0: E3]

c. [E4: A1]

d. [E3: A0]

Ans: a. [A1:E4]

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

a. 2

b. 3

c. 4

d. 5

Ans: 4

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

a. Bar chart

b. Area chart

c. Scatter chart

d. Line chart

Ans: Area chart.

10. For selecting a 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

Ans: Press Ctrl key.