ISP Question paper of 3rd Sem (2019)

Question bank of ISP 

Sub Code: - 1618303

  2019 ( Odd )

Time : 3Hrs

Sem- III / CSE 

I.S.P. 

Full Marks : 70

Pass marks : 28

Group A 

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

(i) MS Excel is used for creating :
(a) Presentation
(b) Documents
(c) Sending Mails
(d) Spreadsheets

(ii) In Excel, Chart are creating using :
(a) Pie chart
(b) Pivot Chart
(c) Pivot Chart
(d) Chart wizard

(iii) All macro, keyboard shortcuts include the …………key
(a) Alt
(b) Ctrl
(c) F11
(d) Shift

(iv) MS-Excel is a …………..
(a) Language
(b) system software
(c) Package
(d) None

(v) A worksheet can have a maximum of…………..Number of rows in MS excel 2000
(a) 256
(b) 1024
(c) 32000
(d) 65535

(vi) Short cut key to save a spread sheet ?
(a) Ctrl+S
(b) Alt+S
(c) F11+S
(d) Shift+S

(vii) Which tool bar allows changing of fonts and their size in MS Word
(a) Standard
(b) Formatting
(c) Print Preview
(d) None of these

(viii) From which menu you can insert Header and footer ?
(a) Insert Menu
(b) View Menu
(c) Format Menu
(d) Tolls Menu

(ix) What is the shortcut key you can press to create a copyright symbol ?
(a) Alt+Ctrl+C
(b) Alt+C
(c) Ctrl+C
(d) Ctrl+Shift+C

(x) What is the smallest and largest font size available in Font size tool on formatting tool
bar?
(a) 8 and 72
(b) 8 and 62
(c) 12 and 72
(d) None of the above

(xi) Which of the following is not a valid data type in excel ?
(a) Number
(b) Character
(c) Label
(d) Date / Time

(xii) Which menu option can be used to split windows into two ?
(a) Format Window
(b) View Window Split
(c) Window Split
(d) View Split

(xiii) Which of the following formulas will Excel Not be able to calculate ?
(a) =Sum(Sales) – A3
(b) =Sum(A1:A5)* .5
(c) =Sum(A1:A5)/(10/10)
(d) =Sum(A1:A5)-10

(xiv) To drag a selected range of data to another worksheet in the same workbook, use the
……..
(a) Tab Key
(b) Alt key
(c) Shift key
(d) Ctrl key

(xv) In a worksheet you can select ……………..
(a) The entire worksheet
(b) Rows
(c) Columns
(d) All of the above

(xvi) An excel worksheet in a collection of -
(a) Workbooks
(b) Works sheets
(c) Charts
(d) Work Sheet and Chart

(xvii) Excel files have a default extension of ?
(a) xls
(b) xlw
(c) Wki
(d) 123

(xviii) Which of the following is not one of power point view
(a) Slide show view
(b) Slide view
(c) Presentation
(d) Outline

(xix) Which short cut key inserts a new slide in current presentation
(a) Ctrl+N
(b) Ctrl+M
(c) Ctrl+S
(d) All of above

(xx) From which menu you can access picture, Test Box, Chart etc
(a) File
(b) Edit
(c) Insert
(d) View

Group B 

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

2. What are the advantages of using open – office over MS -office. ?

Or

How is table inserted into the word document ? Describe the procedure .

3. What is absolute cell addressing in a worksheet ?

Or

What are major components of MS word 2000 ? Describe them .

4. Describe the use of the formula bar .

Or

How do you think that MS power point is useful ? Justify .

5. Write the steps to create a macro in MS- Word 2000 .

Or

How is picture inserted into the word document ? Describe the procedure .

6. Explain the use of auto sum feature in MS- Excel with suitable example .

Or

Write the steps for sorting and filtering in MS Excel .

Group C 

➥ Answer all five questions: - (5×6=30)
7. Explain various task we can able to perform on to Excel comparing with MS –
Word .

Or

What are two important aspects to perform the mail merge function ?

8. Write the steps of creating a power point presentation and also explain various
main elements of office button

Or

Describe in detail function of the vertical and horizontal scroll bars ?

9. Explain the available formatting tools of MS Office .

Or

Explain the steps for crating Header and Footer in MS- Word

10. Discuss the merit and limitation of word processing and spread – sheet software
of computer ?

Or

What are the different categories of Charts ? Write the steps to create a chart in
MS- Excel .

11. Write short Note on :
(i) Working and manipulating data with Excel
(ii) Use of Dragging and moving

Or

What is mail merge ? Write down its advantages and disadvantage and steps for
creating mail merge .

By – Md Altaf Raja (CSE)