PGDCA Fundamentals of Computer, Operating System & Office Suite Set 2

KERALA STATE RUTRONIX

Fundamentals of Computer, Operating System & Office Suite

(PGDCA)

Question code           : A4
Time                           : 2 hours
Maximum Marks     : 100
(Note: Write the answers for Questions from 1 to 30 in the MCQ answer sheet)

Part - I Choose the most appropriate answer
(10 x 1 Mark 10 Marks)

1. .................... is a simultaneous bidirectional communication scheme.
a) Simplex
b)Full duplex
c) Half duplex
d) Four wired

2) Which of the following is not an example of Operating System?
a) Ubuntu
b) Red Hat Linux
c) Windows Me
d) Open Office

3) ............... device is used to boost the signal as it passes along a cable.
a) Bridge
b) Bus
c) Hub
d) Repeater

4) Identify the device needed to upgrade the Graphics Processing on a desktop computer.
a) Multimedia Speakers
b) Network Interface card
c) Video Graphics Card
d) Memory

5) Which of the following is the graphics solution for Word processors?
a) WordArt
b) DropCap
c) ClipArt
d) All of these

6) ............. topology combines the characteristics of Bus and Star topologies.
a) Tree
b) Mesh
c) Ring
d) Linear

7) in MS Excel, cannot be used in a conditional formula
a) DATE
b) OR
C) NOT
d) AND

8) What does rutronix represent in rutronix@gmail.com?
a) Domain
b) Host
c) User named
d) Address

9) Identify the given icon
a) Merge & Center
b) Cell Style
c) Wrap text
d) Bottom Align

10) Background color or effects applied on a document is not visible in .............
a) Print layout view
b) Web layout view
c) Reading view
d) Print Preview

Part - II Fill in the blanks
(10 x 1 Mark 10 Marks)

11) ..........….... feature is used to apply a ghosted text behind the content in MS Word.

12) In MS Excel, .............. helps you to fill rows or columns with a series of data.

13) In MS Word, font sizes are measured in ................

14) ............. option changes all the occurrences of a word in a document.

15) In MS Access ................ enables you to view data from a table based on a specific criterion.

16) In MS Access, ................ data type is appropriate to store large text and numbers.

17) ............... transmission mode is used in Police Wireless System.

18) A memory that requires refreshing of data is ....................

19) A portion of the secondary storage device that is reserved to store the minimum operating system is called ............... Sector.

20) .............. scans a set of vertical bars of different width for specific data.

Part - III State whether true or false
(10 x 1 Marks 10 Marks)

21) Each design template has its own slide master that can be altered.

22) Repeater connects a LAN to a WAN.

23) Anurag is a Super Computer produced by India.

24) Reveal formatting option reveals only font applied to a selected text.

25) in MS Excel, the formula given in one sheet of a workbook can be linked to other worksheet.

26) You can define many print areas at a time.

27) Unix is a Single User Operating System.

28) Address bus is bidirectional.

29) Digital fingerprinting is used for preventing users from uploading copyrighted videos.

30) An individual page in a Power Point presentation is known as slide.

Part - IV Name the following
(5 x 2 Marks 10 Marks)

31) Any two Communication Protocols.

32) Any two types of Plotters.

33) Any two Peripheral Devices.

34) Any two Web Browsers.

35) Any two Operating Systems.

Part - V Write the Excel formula for the following
(5 x 2 Marks 10 Marks)

36) To generate a random number between 25 and 98.

37) To round a number up to the nearest integer.

38) To find the average of numbers in the range D22:D244.

39) To convert a vertical range of cells to a horizontal range or vice versa.

40) To return the largest value from a set of values in the range D1 to D10.

Part - VI Expand the following
(5 x 1 Mark = 5 Marks)

41) ISP

42) STP

43) HTTP

44) BMP

45) VGA

Part - VII Write short notes on (Any Five)
(5 x 5 Marks 25 Marks)

46) Financial functions in MS Excel.

47) Conditional formatting in MS Excel.

48) Ethernet and FireWire.

49) Different views in MS PowerPoint.

50) Bullets and Numbering in MS Word.

51) Three options for creating a new PowerPoint presentation.

52) Difference between
a) SAVE and SAVE AS
b) CLOSE and EXIT in MS WORD.

53) Three types of Network.

Part - VIII Explain the following (Any Two)
(2 x 10 Marks 20 Marks)

54) Elements of Windows Screen.

55) Pivot Table.

56) Mail merge in MS Word.

57) Slide effects, Slide animation and Slide transition in MS Power Point.