OFFICE SUITE - Previous Questions

KERALA STATE RUTRONIX

OFFICE SUITE

(CTTC, CPPTTC, CWPDE, PODTP PDCFA, DCA, DCA-FT, DOA)

Question Code       : C1

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) Which key combination is used to insert a Line Break?
a) SHIFT Enter
b) CTRL + Enter
c) ALT Enter
d) Fn+Enter

2) Gutter Margin can be set to .....................
a) Leh and Right
b) Top and Bottom
c) Right and Bottom
d) Left and Top

3) In Open Office ....…........ is a spreadsheet program similar to Microsoft Excel.
a) Writer
b) Calc
c) Impress
d) Base

4) ...…...... is a set of tasks that we record in MS Word and run every time we want to perform
the same task.
a) Mail Merge
b) Macro
c) Repeater
d) All of these

5) A file which contains readymade styles that can be used for a presentation is called ............
a) Auto style
b) Wizard
c) Template
d) All of these

6) What type of chart will you use to compare performance of sales of two products?
a) Column
b) Bar
c) Line
d) Dot

7) Range A4 D6 will contain ............... number of cells.
a) 32
b) 12
c) 4
d) 20

8) ............... is a wild card character that can be used in Excel filter..
a) &
b) #
c) $
d)*

9) The cell reference for a range of cell that starts in cell L1 and goes over to column N and down to row 10 is .................

a) L1-N10
b) LI:N10
c) L1.N100
d) L1;N10

10) We can change the style of all slides in the presentation by changing ................ property
a) Header and Foofer
b) Slide master
c) Nudging
d) None of these

Part - II Fill in the Blanks
(10 X 1 Mark = 10 Marks)

11) ............. excel function checks whether a condition is true or not.

12) ............... is a collection of data that is stored electronically as a series of records in a table.

13) ................ view displays the slides on a presentation as miniature representation.

14) RDBMS stands for .............

15) ............... is the shortcut key for subscript.

16) ............... is the shortcut key to add a new slide in a presentation.

17) In MS Excel =PRODUCT(2,3,5) will return .............

18) ............... option is used to adjust the value in a specified cell until a formula that is dependent on that cell reaches a target value.

19) In MS Word, .............. is the large letter that begins a paragraph.

20) PDF stands for ................

Part - III State whether True or False

(10 X 1 Mark = 10 Marks)

21) In MS PowerPoint, slide number can be added anywhere on the slide.

22) PMTO function comes under statistical function category.

23) Images can be grouped together in MS PowerPoint.

24) Ctrl + C is the shortcut to center alignment in MS Word.

25) MS Office is not an application software.

26) OLE means Object Linking and Enable.
27) Data recorded in the database can be edited but cannot be deleted.

28) Slide show can show only a maximum of one slide at a time.

29) A PowerPoint cannot be inserted in a webpage.

30) Access is the database program of Microsoft Office Suite.

Part - IV Write the Excel formula for the following
(5 X 2 Marks = 10 Marks)

31) To find the sum of numbers 15,18,29,36.

32) To find the logarithm of a number 25.

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

34) To return the smallest value from a range of cells.

35) To return the absolute value of a number.

(താഴെ കൊടുത്തിരിക്കുന്ന ചോദ്യങ്ങൾക്ക് ഉത്തരങ്ങൾ മലയാളത്തിലും എഴുതാം)

Part - V Answer the following (Any Six)

(6 X 5 Marks 30 Marks)

36) Header and Footer in MS Word.

37) Bullets and Numbering in MS Word.

38) Any five mathematical functions in MS Excel.

39) Data Types in MS Access.

40) Different views in MS PowerPoint.

41) Conditional Formatting in MS Excel.

42) Types of Referencing in MS Excel with examples.

43) Footnote and Bookmark in MS Word.

Part - VI Essay Questions (Any Three)
(3 X 10 Marks = 30 Marks)

44) Mail merge in MS Word.

45) Charts and their types in MS Excel.

46) Explain about queries and query wizard in MS Access.

47) Macros in MS Word.

48) Slide effects, Slide animation and Slide transition in MS PowerPoint.