ISP Question paper of 3rd Sem (2018)

Question bank of ISP 

Sub Code: - 1618303

2018 (Odd)

Time : 3Hrs

Sem. - III / CSE 

ISP

Full Marks : 70

 Pass marks : 28

Group A 

1. Choose the most suitable answer from the following options: - (1*20=20)

(i) Which enables us to send the same letter to different persons?
(a) macros
(b) templates
(c) mail merge
(d) none

(ii) What is the function of ctrl+B in MS-word.
(a) Font size larger
(b) Adds a line break
(c) Selected text bold
(d) Italic formatting

(iii) Shortcut for undo is-
(a) Ctrl+z
(b) Ctrl+y
(c) Ctrl+u
(d) Ctrl+x

(iv) _______ is used to convert from upper case to lower case and vice versa
(a) Toggle case
(b) Sentence case
(c) Lower case
(d) Upper Case

(v) _____ is a table consisting or rows and columns
(a) Worksheet
(b) Cell
(c) Workbook
(d) Range

(vi) two main operations are, portrait and
(a) Landscape
(b) Photo
(c) Lying
(d) None of the above

(vii) Shortcut top find command
(a) Ctrl+C
(b) Ctrl+F
(c) Ctrl+Z
(d) None of the above

(viii) Most of the editing tools available under _________ menu.
(a) File
(b) Format
(c) Edit
(d) None of these

(ix) Header appears at the _____ of the page
(a) Top
(b) Bottom
(c) Center
(d) none of the above

(x) Excel worksheets are given _____ extension
(a) .xls
(b) .doc
(c) .bmp
(d) none of the above

(xi) Cell address B&6 in a formula means it is a
(a) Relative cell reference
(b) Absolute cell reference
(c) Mixed cell reference
(d) None of the above

(xii) What are numbered from A to Z etc?
(a) Rows
(b) Cells
(c) Columns
(d) None of the above

(xiii) The key on the keyboard to view slide show is
(a) F1
(b) F2
(c) F5
(d) F10

(xiv) Line spacing refers to-
(a) The space between the lines to text
(b) The height of the line
(c) The length of the line
(d) both (a) and (b)

(xv) In which menu can you find features like slide design slide layout etc?
(a) Insert menu
(b) Format menu
(c) Tools menu
(d) Slide show menu

(xvi) MS power point is a
(a) Data base program
(b) Spreadsheet program
(c) Presentation program
(d) Word processing program

(xvii) Which of the following provides a printed copy of your presentation
(a) outline
(b) speaker notes
(c) audience handouts
(d) all of the above

(xviii) Which command brings you to first slide in your presentation
(a) next slide button
(b) page up
(c) Ctrl + home
(d) Ctrl+ end

(xix) What power point feature will you use to apply motion effects different objects of a slide?
(a) Slide transition
(b) Slide design
(c) objects effects
(d) Animation scheme

(xx) What is anti-virus
(a) It is a computer
(b) It is a program code
(c) It is a company name
(d) It is an application

Group B 

➥ Answer all Five Questions: - (5×4=20)

2. Explain various advantages of using MS-Excel .

Or

Give the name of some popularly used word processing packages

3. Explain how to create a table in MS-Word.

Or

Define borders and shading features of MS-Word. How you will apply
borders and shading to paragraphs

4. Explain different functions is MS-Excel.

Or

Write method of entering formula in MS-Excel

5. How we can apply transition to a slide? Explain

Or

Explain adding pictures and graphs in a slide

6. Explain the concept of CELL and CELL addressing in MS-Excel.

Or

Write short notes on the following:-
(a) Bad effect if virus in computer
(b) Role of anti-virus

Group C 

➥ Answer all five question: - (5*6=30)

7. Explain various features of MS-Word

Or

Write various application of MS-office in detail

8. Explain the following:-
(a) Notes
(b) Handouts
(c) Masters in presentation

Or

Write the steps of creating and modifying it in MS-Excel

9. Explain any four statistical formula in MS-Excel

Or

Describe the process of creating a Pivot table

10. Write short notes on the following:-
(a) Animation Effects
(b) Adding Background in a slide

Or

Explain following:-
(a) Slide layout
(b) Slide shorter view

11. How views of slide is beneficial for power point? Explain various views of a slide

Or

What is anti-virus package? Explain how it is useful to prevent and detect
viruses.

∎ By- Md Altaf Raja (CSE)