`

Question Code

[Established by Govt. of Kerala]

F1

Fundamentals of Computer, Operating System & Office Suite PDDTP [Old Scheme] Time: 2 hours

Maximum Marks: 100

Note: Write the answers for Questions from 1 to 35 in the MCQ answer sheet Part - I Choose the most appropriate answer 1)

(10 x 1 Mark = 10 Marks)

……………… Excel function calculates the square root of a specified number. a) SQUARE ROOT()

b) SQRT()

c) ROOT()

d) POW()

2) …………… is not a valid function in MS Excel. a) SUM( )

b) AVERAGE( )

c) MIDDLE( )

d) LEFT( )

3) In Windows, ……………… is an information window, which gives an idea about the various application in the form of small buttons or icons. a) Tool bar

b) Task bar

c) Menu bar

d) Option bar

4) ………………scans a set of vertical bars of different width for specific data. a) OMR

b) MICR

c) Bar-Code Reader

d) OCR

5) In MS Word, grammatical errors are noted in the document by a underline. a) red

b) purple

c) green

………………colored

d) blue

6) …………………… is an optical storage device. a) RAM

b) ROM

c) Flash memory

d) Blue Ray Disk

7) What is the smallest and largest font size available in Font Size Tool on formatting tool bar? a) 8 and 64

b) 8 and 72

c) 12 and 72

d) None of These

8) ………………… generation of computers are expected to have Artificial Intelligence. a) Fifth

b) Second

c) Third

d) Fourth

9) In Excel, the operator used to join two strings is ……………… a) &

b) #

c) *

d) /

10) ………………….. is a single user operating system. a) Linux

b) Windows XP

c) Unix

Part - II Fill in the blanks

d) MS-DOS (10 x 1 Mark = 10 Marks)

11) …………… error can be trapped by the compiler. 12) In MS Word, ……………… is the shortcut key for page break. 13) ………………… is a radio standard and communication protocol that exchanges information between devices such as mobile phones, laptops etc. 14) In a flowchart, the symbol used to represent calculation is ……………… 15) In Excel,……… feature allows to quickly fill cells with repetitive or sequential data.. 16) The wild card characters used in LINUX are ……………… and ……………… 17) …………. option is used to align the paragraph at both right and left indent in MS Word. 18) In Excel, the cell in the fourth row and fifth column is referenced as ……………. 19) In MS Word, ……………… option displays the number of words used in the document. 20) 1’s complement of 10101101 is ……………… Part - III State true or false

(10 x 1 Mark = 10 Marks)

21) Linux is case-sensitive. 22) In Excel, charts can be resized and moved in the work sheet.

F1-10-January 2012-Page 1 of 2

23) FireWire is a virus protection software. 24) Wi-Fi is a Wireless Personal Area Network. 25) In Excel, F2 is the shortcut for editing the active cell. 26) Static RAM does not require ‘data refreshing’. 27) Windows XP runs independent of DOS. 28) OLE stands for Object Linking and Enabling. 29) In MS Word, F12 is the shortcut for closing a file. 30) A nibble is the smallest element of information used by a computer. Part - IV Write shortcut key strokes for

(5 x 1 Mark = 5 Marks)

31) Replace 32) Spell check 33) Select All 34) Redo 35) Align Center Part - V Expand the following

(5 x 1 Mark = 5 Marks)

36) OCR 37) HTML 38) TCP 39) BCD 40) VLSI Part - VI Write the Excel formula for the following

(5 x 2 Marks = 10 Marks)

41) To count the number of empty cells in a specified range. 42) To find the lowest value in the range D6 to E135. 43) To round the number 3.1456278 to the nearest 2 decimals. 44) To calculate the monthly constant payment of a loan of Rs. 80,000/- with a constant interest rate of 10% per year and duration of payment in 5 years. 45) To return the remainder of a division.

(XmsgsImSp¯n«pÅ tNmZy§Ä¡v D¯c§Ä aebmf¯nepw FgpXmw) Part - VII Explain the following (Any Ten) 46) Secondary storage devices. 47) Types of Cell Referencing. 48) Five communication protocols. 49) Five mathematical functions in MS Excel. 50) Computer Viruses. 51) Mail Merge in MS Word. 52) Five Pointing Devices. 53) Header and Footer in MS Word. 54) Grouping and Ordering in Draw Menu of MS Word. 55) Computer Network. 56) Gateway and Hub. 57) Conditional Formatting in MS Excel.

F1-10-January 2012-Page 2 of 2

(10 x 5 Marks = 50 Marks)