question of introduction to software package

 Introduction to Software Package(Asked question for LE)

Sub Code: - 1618303

2019(Even)

Time : 3Hrs

  Semester  III(New)/CSE  

ISP             

Full Marks : 70

Pass marks : 28

---

Group A 

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

(i) To insert a chart to excel, we choose _____ tab

(a) Insert

(b) Home

(c)  Formulas

(d) View

(ii) The numeric data entered in the worksheet is ______ aligned by default

(a) Left

(b) Right

(c) Center

(d) Top

(iii) Which menu is selected to cut, copy and paste.

(a) File

(b) Tools

(c) Edit

(d) Special

(iv) What is portrait and landscape

(a) Page orientation

(b)Paper

(c) Page layout

(d) Page margin

(v) Which function is used to calculate remainder in MS- EXCEL?

(a) INT()

(b) FACT()

(c) MOD()

(d)DIV()

(vi) Macro operation is present in which menu of M.S Excel.

(a) Insert

(b) Format

(c) Tools

(d) Data

(vii) What is the smallest and largest front size available in font size tool in formatting toolbar?

(a) 8 and 72

(b) 8 and 68

(c) 6 and 72

(d)6 and 68

(viii) A character that is raised and smaller above the baseline is known as:

(a) Raised 

(b) Outline

(c) Capscript

(d) Superscript

(ix) If you press ______ the cell accepts your typing as its contents?

(a) Tab

(b) Enter

(c) Alt + Enter

(d) Ctrl + Enter

 
(x) A value used in formula that does not change is called a?

(a) Constant

(b) Variable

(c) Cell- address

(d) Static

 
(xi) What function displays row data in a column or column data in a row?

(a) Hyperlinks

(b) Rows

(c) Index

(d) Transpose

 
(xii) You can active cell by? 

(a) Pressing the tab key

(b) Clicking the cell

(c) Pressing an arrow key

(d) All of above

(xiii) A file which contains readymade styles that can be used for a presentation is called

(a) Autostyle

(b) Template

(c) Wizard

(d) Pre-formatting

(xiv) Which of the following is not a type of page margin?

(a)Right

(b) Center

(c) Left

(d) Top

 
(xv) Ellipse motion is a predefined___________

(a) Design Template

(b) Color scheme

(c)  Animation scheme

(d) None of these

(xvi) Which of these options is used to make a similar type of formatting on every slide in a power point.

(a)  Slide Transition

(b) Slide Design

(c)  Slide master

(d) All of these

(xvii) 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

(xviii) What feature will we use to apply motion effects in between a slide exits and another enters?

(a)  Slide Transition

(b) Slide design

(c)  Animation objects

(d) Animation scheme

(xix) What is the virus that spread in computer?

(a)  It is hardware

(b) It is system software

(c)  It is a computer program

(d) It is a windows tool

(xx) What kind of attempts is made by individuals to obtain confidential information from a person by falsifying their identity?

(a)  Computer viruses

(b) Spyware Scams

(c)  Phishing scams

(d) None of the above

 Answer Click here

Group:-"B"

 

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

 

2.  What are templates? How are they created?

OR

Explain the header and footer section MS-word.

 

3.  Explain aligning paragraphs and indenting paragraphs.

OR

Explain font dialog box.

 

4. Explain the following:

1.     Autosum

2.    Auto Text

OR

How to design formula in MS-Excel? Explain with example.

 

5.  Explain various type of chart in MS-Excel.

OR

Explain mixed mode referencing with example.

 

6. How we can prevent virus in our computer system.

OR

Explain the role of Antivirus.

 

Group:- "C"

 

➥ Answer all Five Questions: -                         (5*6=30) 

 

7. Explain the use of mail merge option in detail and write steps for creating it.

OR

Explain different dialog boxes used in MS-word.

 

8. What is the use of page setup in MS-word? Explain with the help of page setup commands. 

OR

How macros multiple worksheets are created in MS-Excel? Explain.

 

9.  Explain Mathematical functions with examples.

OR

What is the use of what-if analysis in MS-Excel? Explain with example.

 

10. Describe custom Animation and slide transition in power point.  

OR

What are the features of MS power point? Explain.

 

11.  Explain the types of viruses.

OR

Explain various symptoms of viruses. Explain virus protection, deletion and removal utilities in antivirus.