CIC ASSIGNMENTS FOR JANUARY , 2009 session. Submit the response sheets of CMA’s to Registrar (SED), IGNOU, Maidangarhi , New Delhi-110068

Course Code:CIC-05

Course Title:Microsoft Office

Assignment Number:CIC-05

Last Date of Submission:30th April, 2009 (For January Session)

This is a Computer Marked Assignment. There are thirty objective type questions in this assignment. Each question has four alternatives. Choose the best-suited answer and mark in the response sheet according to the instructions given in the guidelines regarding the assignments. In case you find none of the given alternatives correct, then mark 0, in your response sheet. A question with more than one alternative chosen shall be treated as invalid. All questions carry equal weightage

1.DOS stands for

1)Disk operating system

2)Data operating system

3)Dynamic operating system

4)None of the above.

2.The program which automatically run and continues to run as long as Windows is running is

1)Program manager

2)File manager

3)Note pad

4)Setup

3.The background on which the WINDOWS appear is

1)Desktop

2)Briefcase

3)Start

4)None of the above view.

4.The window that contains the running application is

1)File Manager

2)Program Manager

3)Application Window

4)Document Window

5.To close an application or to quit from an application press,

1)CTRL+F4

2)SHIFT+F4

3)ALT+F5

4)None of the above.

6.The control that presents non-exclusive options and the user can select more than one option at a time is

1)Option Button

2)List Box

3)Check Box

4)Dropdown List Box

7.In WINDOWS, the application which performs the tasks including managing the drives, The Registraries and files is

1)File manager

2)Group Window

3)Application Window

4)None of the above.

8.Print Manager can be used to

1)Set up a printer

2)To check the print status

3)Cancel the printing

4)All of the above

9.In WRITE, to go to the beginning of the document, press

1)CTRL+PAGEUP

2)CTRL+INSERT

3)UP ARROW

4)None of the above.

10.The accessory which organizes and manages information such as names, addresses and phone numbers is

1)Cardfile

2)Character Map

3)Write

4)Notepad

11.To Open an existing powerpoint presentation, press

1)CTRL+N

2)CTRL+E

3)CTRL+M

4)None of the above.

12.We can create a new Power point presentation using

1)Autocontent wizard

2)Template

3)Pick a look wizard

4)Any of the above.

13.In MSEXCEL, using keyboard to select the entire Row, press

1)CTRL+SPACEBAR

2)SHIFT+SPACEBAR

3)CTRL+END

4)None of the above.

14.To move to cell A1,press

1)CTRL+ENTER

2)CTRL+PAGEUP

3)CTRL+HOME

4)CTRL+TAB

15.To customize setting of toolbars menus etc., choose the command

1)tools -> options ...

2)tools-> customize ...

3)tools -> object ...

4)None of the above.

16.The program manager displays

1)Icons

2)Applications

3)Buttons

4)None of the above.

17.To exit from MS-Excel

1)Choose File -> close

2)Choose File-> Exit

3)Choose Edit->select all

4)Both 1) and 2)

18.You can change wall paper settings from the

1)Control panel dialog box

2)Main group

3)Accessories group

4)Setting dialog box.

19.The show command is there to

1)Mark the end of every sentence or character

2)Display the non-printing characters

3)To mark the end of each paragraph in the document

4)None of the above.

20.To create a new group, select menu from the file menu in

1)Program manager

2)File managers

3)Control group manager

4)Any of the above.

21.Paragraph spacing can be done in terms of

1)Points

2)Meters

3)Both 1) & 2)

4)None of the above.

22.You can change screen saver settings from

1)Control panel dialog box

2)Print manager dialog box

3)Desktop dialog box

4)Setting dialog box.

23. For indentation one can use

1)Format menu

2)File menu

3)View menu

4)Tools menu.

24.The formula in Excel start with

1)-

2)=

3);

4)None of the above.

25.If you type MAR-94, MS Excel uses this format

1)MM-DD-YY

2)MMM-YY

3)DD-MM-YY

4)MM-DD-YY

26.One can execute an application from

1)File manager

2)Program manager

3)Print manager

4)Both 1) & 2).

27.DLL stands for

1)Database Link Library

2)Dynamic Link Library

3)Data Link Library

4)None of the above.

28.DDE stands for

1)Dynamic Data Exchange

2)Dynamic Database Engine

3)Dynamic Data Extension

4)None of the above.

29.A pivot table is a worksheet that quickly

1)Creates a database table

2)Summarize the data

3)Creates a report

4)None of the above.

30.Workspace file extension is

1).XLS

2).XLW

3).XLC

4)None of the above.

Response sheet for cic assignments


School of Computer and Information Sciences

INDIRAGANDHINATIONALOPENUNIVERSITY

RESPONSE SHEET FOR COMPUTER MARKED ASSIGNMENTS

Enrolment No. Programme:

Course Code:

Name & ...... Assignment Code:

Address

(Block...... Study Centre Code:

Letters)

...... Regional Centre Code:

Signature: ………………..

Pin Code

Date: ………..

Question No. / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10
Answers
Question No. / 11 / 12 / 13 / 14 / 15 / 16 / 17 / 18 / 19 / 20
Answers
Question No. / 21 / 22 / 23 / 24 / 25 / 26 / 27 / 28 / 29 / 30
Answers
Question No. / 31 / 32 / 33 / 34 / 35 / 36 / 37 / 38 / 39 / 40
Answers
Question No. / 41 / 42 / 43 / 44 / 45 / 46 / 47 / 48 / 49 / 50
Answers

For Office Use Only

Entered by______Total Questions Attempted ______

Verified by______Wrong Answers______

______Total Marks______

______Grade Obtained______