OFFICE SUITE 2019 December

KERALA STATE RUTRONIX

OFFICE SUITE

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

Time: 2 hours

Question Code C1
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) in Open Office, ............... is a spreadsheet program similar to Microsoft Excel
a) Writer
b) Calc
c) Impress
d) Base

2) ................ chart is used to compare the percentage sum of the data series.
a) Bar
b) Line
c) Pie
d) Column

3)In Excel, a ............... is used to rearrange the data in ascending or descending order.
a) Data, Sort
b) Data, Form
c) Data, Table
d) Data, Subtotals

4) Range A4: D8 will contain ............... number of cells
a) 32
b) 8
c) 4
d) 20

5) Which of the following store Command to retrieve data from database?
a) Forms
b) Reports
c) Queries
d) Tables

6) Which of the following shortcut key is used to spell check in?
a) F1
b) F2
c) F5
d) F7

7) name must be unique in a database.
a) Table
b) Field
c) Record
d) Character

8) Which of the following is not an essential component to perform a mail merge operation?

a) Main document
b) Data source
c) Merge fields
d) Word Field

9) In a document, the footnote is appeared in

a) End of the document
b) Bottom of a page
c) End of Heading
d) None of these

10) The shortcut key to make the selected text bold is .............
a) Ctrl + G
b) Ctrl + I
c) Ctrl + X
d ) Ctrl + B

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

11) .............. is the default page setup orientation for slides in MS PowerPoint

12) To select an entire column in MS Excel press ............ key.

13) By default, the text entered in MS Excel is ................... aligned within the cell

14) CEILING (15.2) will return ..............

15) The default number of lines to drop for drop cap is ...............

16) ............... key begins a slide show.
17) OLE stands for .................

18) The shortcut key combination for Thesaurus is .............

19) Excel function =POWER(8,2) will return ..............

20) The space left between the margin and the start of a paragraph is called .............

Part - III State whether True or False
(10 X 1 Mark = 10 Marks)

21) Shift+Ctrl+Space Bar is used to select the current cell in the MS Excel.

22) In MS Excel, to join two strings the operator available is &.

23) Ctrl + R is the shortcut key for replace in MS Word.

24) It is not possible to insert an Excel sheet in a word document

25) Power Point cannot be inserted in a webpage.

26) MS Office is not an application software.

27) Data recorded in the database can be edited but cannot be deleted

28) PowerPoint can be saved in HTML format.

29) Impress is a word processing software of OpenOffice org.

30) A keyboard shortcut can be assigned to a macro.

Part - IV Answer the following (Any Eight)
(8 X 5 Mark = 40 Marks)

31) Bullets and Numbering in MS Word.

32) Financial functions in MS Excel.

33) Auto correct in MS Word.

34) Relative, Mixed and Absolute referencing in MS Excel with examples.

35) Data Types in MS Access.

36) Conditional formatting in MS Excel.

37) Text alignment around image in MS Word.

38) Features of MS PowerPoint.

39) Grouping and Ordering in MS Office.

40) Autofill and Auto Format.

41) Dropcap feature in MS Word.

42) Logical functions in MS Excel.

Part - V Answer the following (Any Three)
(3 X 10 Mark = 30 Marks)

43) Pivot Table.

44) Types of Tabs in MS Word.

45) Mail merge in MS Word

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

47) Slide effects, Slide animation and Slide transition in MS PowerPoint

48) Macros in MS Word.

For MCQ Answers