3/1/20

Introduction to software package 2019 question


Sub Code: - 1600303


2019(ODD)
Time : 3Hrs                                                                          
Semester  III(New)  
     ISP               
Full Marks : 70
Pass marks : 28



Group A

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, Charts are creating using:

(a) Pie chart
(b) Pivot chart
(c) Bar 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) Tools menu

(ix) What is the short cut 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 workbook is a collection of

(a) Workbooks
(b) Works sheets
(c) Charts
(d) Work sheets

(xvii) Excel files have a default extension of?

(a) xls
(b) xlw
(c) Wki
(d) 123

(xviii) Which of the following in not one power points view?

(a) Slide show view 
(b) Slide view
(c) Presentation view
(d) Outline view

(xix) Which short cut key inserts a new slide in current presentation?

(a) Ctrl + N
(b) Ctrl + M
(c) Ctrl + S 
(d) All of the above

(xx) From which menu you can access picture, text 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 the 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. How picture is inserted into the word document? Describe the procedure.
OR
Write the steps to create a macro in MS- Word 2000

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 tasks we can able to perform on to Excel comparing with MS-Word.
OR
What are the 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 functions of the vertical and horizontal scroll bars?

9. Explain the available formatting tools of MS-Office.
OR
Explain the steps for creating header and footer in MS-word.

10. Discuss the merit and limitations of word processing and spread-sheet software of computer?
OR
What are different categories of charts? Write the steps to create a chart in MS-Excel

11. Write short notes on:
a.     Working and manipulating data with Excel
b.     Use of Dragging and moving
OR
What is mail merge? Write down its advantages and disadvantages and steps for creating mail merge.











No comments:

Post a Comment

Please do not enter any spam link in the comment box and use English and Hindi language for comment.

Latest Update

Key Components of XML

Popular Posts