MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION

D. TRUE OR FALSE (10x1=10) Diploma Course Examination, January, 2014

(Write ‘T’ against the right ones and ‘F’ against the wrong ones) Semester-I, Diploma in Computer Application
1. The default location of drawing toolbar is at the top of a Subject: Office Automation Software (DCA103)
document. F
Full Mark : 40 Time : 1 hours
2. Status bar shows the page number on which you are working at. T A. Identify the following tools from the diagram given below by
giving the number in the box provided. (10x1=10)
3. To undo the last action, Ctrl+Z is use. T
1. Insert excel worksheet 6. E-mail
4. Pie chart has no grid lines. F 2. Drawing 7. Table & border
3. Numbering 8. Title bar
5. Pictures cannot be inserted in presentation slides. F
4. Paste 9. Short descending
6. Power point presentation is use for accounting. F 5. Open 10. Columns
7. Excel and power point presentation have no status bar. F
8. MS office zoom range is 10 to 500. T
9. Picture can be imported from scanner in MS power point. T
10. Ctrl+M in power point open new slide. T

5 8 4 10 2

6 9 7 1 3

B. MULTIPLE CHOICE QUESTIONS (10x1=10)

(Choose the right answer and tick ( ) from the following)
1. Combination of rows and columns form:
a. Table c. Autoshape
b. Graph d. none
Ans : Table

2. Which key change the text cases?

a. F5 c. Ctrl+F2
b. Shift+F3 d. Ctrl+F6
Ans : Shift+F3

MSCTE/CCA, Jan, 2014 Page 2 MSCTE/CCA, Jan, 2014 Page 4

 3. Sum ( ) function has how many argument(s)? 10. The spelling and grammar is found in
a. only one c. more than one a. format menu c. Review menu
b. only two d. none b. insert menu d. view menu
Ans : more than one Ans : Review Menu

4. Ctrl+N open new blank document in: C. FILL IN THE BLANKS (10x1=10)
a. MS excel c. MS power point (Choose appropriate correct word from the given words)
b. MS word d. All of the above a. File extension of MS word is …………………….. (doc/txt)
Ans : All of the above
b. …………………….. Is the key to increase font size point
by point (Ctrl+}/Ctrl+P)
5. To change the indentation, which key is use?
a. Ctrl+M c. Alt+M c. Pictorial representation of numeric data is called
b. Ctrl+N d. Shift+M …………….. (Graph/ Template)
Ans : Ctrl+M d. Vertical page orientation is called ……………………..
(Landscape/portrait)
6. Formulae must be preceded by:
a. = c. & e. Combining of two or more rows or columns is
b. + d. > ……………..(cropping/merging)
Ans : = f. Picture can be inserted from clip art as well as from
…………….. (file/folder)
7. Mail merge is use to send or print
a. multiple letters c. one application letter g. Short cut key for align justify is ………………..
b. one contemporary letter d. none (Shift+F/Ctrl+J)
Ans : multiple letter h. To show the slide presentation ……………….. is use.
(F3/F5)
8. The cell where B column and 7th row intersect is
a. A1 c. A7 i. Symbols and special characters can retrieve from
b. B1 d. B7 ………………….. menu (Tools/Insert)
Ans : B7 j. Multiple drawing objects are ……………….. to form one
object (Merge/ Group)
9. Portrait and landscape are
a. paper size c. page orientation
b. page layout d. page margin
Ans : page orientation

MSCTE/CCA, Jan, 2014 Page 2 MSCTE/CCA, Jan, 2014 Page 4

 MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
Diploma Course Examination, June, 2014
D. Write T and F against the right ones and wrong ones respectively : Semester-I, Diploma in Computer Application
(10X1=10) Subject : Office Automation Software (DCA103)

1. Ctrl+N open new document/slide/sheet. T

Full Mark : 40 Time : 1 hour
2. Ctrl+V copy item to clipboard. F
3. F10 activate menu bar. T A. Identify the following tools from the diagram given below by giving the
4. Save as box points to the location where you save the number in the box provided. (10X1=10)
1. Indentation 6. paragraph
document/sheet. T 2. Left tab 7. table and border
5. Formula must be preceded by + sign in spreadsheet. F 3. Text highlight color 8. format painter
4. excel work sheet 9. hyperlink
6. Picture other than a graph cannot be inserted in spreadsheet. F 5. drawing 10. spelling and grammar
7. A readymade sample slide is called template. T
8. Slide show can be done using mouse only. F
9. Summing of numbers from more than one sheet is not allow in MS
Excel. F
10. Formula cannot be used in MS Word. F 2 8 9 5 6

1 10 7 4 3

B. Tick ( ) the correct answer : (1X10=10)

1. Which of the following keys change the font size?
a) F5 c) CTRL+}
b) SHIFT+M d) CTRL+U
Ans : CTRL+}

2. To replace cell in MS Excel, we use

a) CTRL+H c) CTRL+F
b) CTRL+I d) CTRL+U
Ans : CTRL+H

MSCTE/CCA/103/June 2014 Page 2 of 4 MSCTE/CCA/103/June 2014 Page 3of 4

 3. Underlined letters in the menu bar is activated by: 10. The valid minimum and maximum size in MS Office is:
a) Shift key c) Alt key a) 10,500 c) 20,500
b) F10 d) B and C b) 10,300 d) 50,800
Ans : B and C Ans : 10,500

4. Conditional formatting is found in the ……………… menu: C. Fill in the blanks by choosing the correct answer from the given
a) Tools c) Insert words : (10X1=10)
b) Format d) view
Ans : Format 1. Intersection of row and column of a particular place is called
_________ (cell/box)
5. Page orientation is of
a) 2 types c) 4 types 2. Clipboards store data _______________ (permanently/temporarily)
b) One type d) No limit 3. Pictures can be deform/resize by _________________ tool
Ans : 2 types
(cropping/merging)
6. To slide show which key is pressed? 4. To save your work, press _____________________(ctrl+S/shift+S)
a) F2 c) F10
b) F5 d) F3 5. To reduce indentation you press ___________________
Ans : F5 (ctrl+shift+M/ctrl+M)

7. MS Word 2003 file extension is: 6. If a = 5; b = 6, Then =if (a)b;a," ") will print _________________
a) xls c) docx (a/blank)
b) pds d) doc 7. Horizontal page orientation is called ____________________
Ans : doc
(portrait/landscape)
8. Merge cell joins the 8. Pie chart is one of many pictorial representation of
a) Rows c) Both a & b __________________________ (numeric data/presentation slide)
b) Columns d) None of the above
Ans : Both a&b 9. Font size are measures in ______________________ (picas/points)
10. Powerpoint presentation have file extention
9. Graphs can be drawn from:
a) Excel only c) Power point only _____________________(ppt/pts)
b) Word only d) All of the above
Ans : All of the above ****************

MSCTE/CCA/103/June 2014 Page 2 of 4 MSCTE/CCA/103/June 2014 Page 3of 4

IV. FILL IN THE BLANKS (10x1=10) MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
Diploma Course Examination, December, 2014
1. Table is formed by a combination of …………………….. (row Semester-I, Diploma in Computer Application
and column/cell and lines) Subject: Office Automation Software (DCA103)

2. Cell is the intersection of…………………….. (left and Full Mark : 40 Time : 1 hours
right/column and row) I. Identify the following tools from the diagram given below by
giving the number in the box provided.
3. Clipboard stored data …………….. (Permanently/
(10x1=10)
Temporarily) 1. Insert excel worksheet 6. E-mail
4. CTRL+O is used to …………………….. existing file. 2. Drawing 7. Table & border
3. Numbering 8. Title bar
(order/open)
4. Paste 9. Short descending
5. Undo command is……………..(Ctrl+U/Ctrl+Z) 5. Open 10. Columns
6. Horizontal page orientation is also called ……………..
(Portrait/Landscape)
7. ……… is the extension for Powerpoint presentation, (ppt/pts)
8. Font size are measured in ………………. (picas/points)
9. Footer appear at the bottom of ………………….. pages onces 10
5 8 4 2
inserted. (all/First)
10. ……………….. shows margin and tab setting. (Ruler/ Format) 6 9 7 1 3

II. MULTIPLE CHOICE QUESTIONS (10x1=10)

1. Which of these toolbar allows changing font and their size?

a. Standard c. Status
b. Formatting d. Drawing
Ans : Formatting

2. Which of the following shortcut keys changes the font size?

a. F4 c. Ctrl+}
b. Shift+F3 d. Ctrl+F
Ans : Ctrl+}

MSCTE/CCA, Dec, 2014 Page 2 MSCTE/CCA,Dec, 2014 Page 4

3. To insert new slide; which of the following key is used? 10. The valid Minimum and maximum zoom size in MS Office is
a. Ctrl+N c. Ctrl+O a. 10,500 c. 50,800
b. Ctrl+M d. Ctrl+F3 b. 10,200 d. 20,500
Ans : Ctrl+M Ans : 10,500

4. Underlined letter in the menu bar is activated by which key? III. TRUE OR FALSE (10x1=10)
a. F10 c. Shift key
b. Alt key d. Ctrl key 1. Page Number appears on all pages once inserted. T
Ans : F10
2. Insert menu is used to insert objects. T
5. Status bar is a bar at the ……………….. of the screen. 3. Format menu change the character and paragraph settings. T
a. Top c. Bottom
4. Existing files can be retrieve form edit menu. F
b. Centre d. Below menu bar
Ans : Bottom 5. A chart is a visual representation of numeric data. T
6. IBM develop MS Office. F
6. Page orientation is of ………… types
a. No limit c. Four 7. The sum ( ) function has more than one argument. T
b. One d. Two
8. Formulae must be preceded by - sign in excel. F
Ans : Two
9. Address of cell where row2 and column3 meets is B2. F
7. Which of these keys allows changing of indentation?
10. F5 is used to slide show. T
a. Ctrl+N c. Ctrl+M
b. Ctrl+I d. Ctrl+P
Ans : Ctrl+M

8. What is the file extensions of word 2003?

a. doc c. pdf
b. docx d. xls
Ans : doc

9. Merge cells join the

a. Column c. only row
b. row d. both a&b
Ans : both a&b

MSCTE/CCA, Dec, 2014 Page 2 MSCTE/CCA,Dec, 2014 Page 4

D. DIAGRAM MATCHING (10X1=10) MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
Diploma Course Examination, June, 2015
1. - Clipart (6) Semester-I, Diploma in Computer Application
Subject: Office Automation Software (DCA103)

Full Mark : 40 Time : 1 hours

2. - Pie chart (8)
A. Fill in the blanks (10x1=10)

3. - WordArt (10) 1. Conditional formatting can be pull down from …………….

a. Tool menu b. Format menu
Ans : Format Menu
2. To change the file name and or location of the file of saved filed
4. - Slide Shorter (9)
after editing we use …………….
a. Save b. Save as
Ans : Save as
5. - AutoSum (7) 3. Cursor position is the ……………..
a. Type head b. Mouse pointer
Ans : Type head
4. ……………. Show margin and tab setting
6. - Radio Button (1)
a. Ruler b. Format
Ans : Ruler
5. Record can be sorted using …………. ways
7. - Combo box (5) a. 2 b. 3
Ans : 2
6. page number can be placed in the ……….. in MS Word 2003
a. Footer only b. Header and Footer
8. - Change Font Style (2)
Ans : header and Footer
7. Alignment can also be made using …………….
a. tab position tool b. indentation
9. - Format Painter (4) Ans : tab position tool
8. =IF(A1>B1,”A is greater than B”,””) give ………. as output
a. A is greater than B b. print nothing
Ans : print nothing
10. - Print Preview (3)
9. Moving sheet from and to other sheet is done using ……… key
a. Shift c. Alt
Ans : Alt

MSCTE/CCA, Jun, 2015 Page 2 MSCTE/CCA, Jun, 2015 Page 4

 10. Underline letter in the menu bar is activated by………. key 8. The default extension of word 2003 file is
a. F10 c. Alt a. docx c. docs
Ans : F10 b. doc d. dox
Ans : doc
B. Choose the correct (10x1=10)
1. Microsoft word is 9. To select multiple lines vertically in MS word what key
a. Calculating Machine c. Image processor combination with mouse is use
b. Word Processor d. Presentation Program a. Alt c. Ctrl
Ans : Word Processor b. Shift d. F3
Ans : Shift
2. Microsoft Powerpoint is
a. Calculating Machine c. Image Processor 10. What key combination increses the indentation?
b. Word Processor d. Presentation Program a. Ctrl+F3 c. Ctrl+D
Ans : Presentation Program b. Ctrl+M d. Ctrl+K
Ans : Ctrl+M
3. To select all text in MS Word, we use
a. Ctrl+V c. Ctrl+A D. TRUE OR FALSE (10x1=10)
b. Ctrl+S d. Ctrl+P
Ans : Ctrl+A 1. Powerpoint presentation is not equippes with Autosum
command. T
4. To replace cell in MS Excel, we use 2. Shift+F5 slide show the presentation. T
a. Ctrl+H c. Ctrl+I 3. Powerpoint presentation uses different Clipart which the word
b. Ctrl+F d. Ctrl+Q
Ans : Ctrl+H and Excel does not have. F
4. Format painter can be used in MS Excel also. T
5. The row number of cell G3 is 5. Ms Word is more powerful in table making anf for calculation
a. 1 c. 2 than that of MS Excel. F
b. 3 d. 4 6. Summation of values from multiple sheet is not possible in
Ans : 3 MS Excel. F
6. In which pull down menu ‘Close’ command is present?
7. To make a table in MS Powerpoint Presentation Row is more
a. File c. Edit
b. Exit d. Window important than that of column. F
Ans : File 8. Shift+F3 (Change case) do not function in MS Excel. T
7. In MS Office, enter key is used to go to 9. To draw a chart in MS Powerpoint Presentation MS Excel
a. New line c. Confirm Confirm worksheet is link. T
b. Start new paragraph d. all of the above 10. Page orientation is of two types. T
Ans : start new paragraph

MSCTE/CCA, Jun, 2015 Page 2 MSCTE/CCA, Jun, 2015 Page 4

 7. Excel has no standard tool bar like word. F MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
8. Blank PPT will create a new blank presentation using the default Diploma Course Examination, December, 2015
setting for text and colour. T Semester-I, Diploma in Computer Application
Subject: Office Automation Software (DCA103)
9. To change all occurrence of particular word; The replace all option
is used. T Full Mark : 40 Time : 1 hours
10. Slide once created can not be rearranged. F
A. Choose the correct (20x1=20)
D. DIAGRAM MATCHING (10X1=10) 1. A data source is a document that has the _______ information
a. more than one c. variable
b. One d. constant
1. Orientation (E) A. Ans : variable
2. The insert table button is use to insert ______ table in a word
2. Subscript and Superscript (C) B. document
a. Blank c. Auto-format
b. Existing d. None of the above
3. Clear Formatting (B) C. Ans : Blank
3. Using word you can add _______ into your document
4. Decrease and increase decimal (F) D. a. Graphic c. Wordart
b. Picture d. All of these
Ans : All of these
5. Bullets, Numbering and multi-level list (A) E. 4. Copying a format applied to one section of a document to
another portion of the document is
6. New slide (I) F. a. Copy c. Merge
b. Cut d. format painter
Ans : format painter
7. Shaped (H) G. 5. The grammar checker mostly suggests ways to correct the ____
a. Paragraph construction c. Words
8. Insert Function (G) H. b. Sentence construction d. All of the above
Ans : All of the above
6. ____ has a table of common typing errors, which are
9. Indentation Decrease and increase (D) I. automatically corrected by word
a. Spelling and grammar c. Format painter
10. Slide show from beginning (J) J. b. Find and replace d. Auto correct
Ans : Auto correct

MSCTE/CCA, Dec, 2015 Page 2 MSCTE/CCA, Dec, 2015 Page 4

7. Standard toolbar has _____ for the most frequently used commands in 15. After creating the slide that wake up the ppt, it can be save in a
words _____ file format
a. Icon c. Text lists a. PTP c. RTF
b. Special symbol d. Only separator b. PSG d. PPT
Ans : Icon Ans : PPT
8. Excel comprises a total of ______ columns 16. Which one allows you to work on individual slides
a. 255 c. 128 a. Slide view c. Slide sorter view
b. 256 d. 512 b. Outline view d. Slick show view
Ans : 256 Ans : Slide view
9. Excel recognizes and entry as formula if it is preceded by a ___ 17. Adding special effect to a ppt enhance the ___ of the presentation
a. + c. = a. clarity c. File size
b. - d. + or = b. Effectiveness d. All of the above
Ans : = Ans : Effectiveness
10. Function key for editing cell to alter its content we press 18. Transitions that are applied to the element of the slide is also called
a. F2 c. F4 a. Animation c. Grouping
b. F3 d. F5 b. Special effect d. Clipart
Ans : F2 Ans : Animation
11. Word has four alignment where as excel has ____ 19. Slide timing can be set for
a. 2 c. 3 a. One slide c. a & b
b. 4 d. 5 b. Group of slide d. None
Ans : 3 Ans : a&b
12. The function executes if and only if the condition/ statement is true 20. Slide show is activated by ____ key
a. MAX ( ) c. IF ( ) a. F3 c. F5
b. COUNT ( ) d. AVERAGE ( ) b. F4 d. F6
Ans : IF ( ) Ans : F5
13. ____ permits the user to change a set of data and view the
corresponding changes to a relative set of data E. TRUE OR FALSE (10x1=10)
a. What-If analysis c. Concatenation function
b. IF ( ) function d. None of the above 1. In mail merge, a master document is one which is one which
Ans : IF ( ) function contains the recipient of the letter with place holder for the
14. PowerPoint offer ____ different types of slide layouts called Auto variable information. F
Layouts
2. A sheet cannot be moved within worksheet. F
a. 20 c. 23
b. 21 d. 24 3. MS Word table cell can be split or merge. T
Ans : 24 4. Excel follows relative reference. T
5. Notes page view allow you to create speakers note. T
6. There are two type of page orientation. T

MSCTE/CCA, Dec, 2015 Page 2 MSCTE/CCA, Dec, 2015 Page 4

D. DIAGRAM MATCHING (10X1=10) MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
Diploma Course Examination, June, 2016
Semester-I, Diploma in Computer Application
1. Change Font Style (B) A. Subject: Office Automation Software (DCA103)

Full Mark : 40 Time : 1 hours

2. Slide shorter (A) B.
A. Choose the correct (20x1=20)
3. Function (G) C. 1. Sound can be add to a presentation to make it more _______
a. Effective c. Beautiful
b. Attractive d. User Friendly
4. Format Painter (F) D.
Ans : effective
2. Given: cell A1=10; then IF(A1<10,”1 digit”,”2 or more digits”),
5. Indentation (H) E. what is the output?
a. 1 digit c. No Output
b. 2 or more digit d. Both a & b
6. New slide (I) F.
Ans : 2 or more digit
3. Given cell A1=10; b1=5. Then, FX=B1/A1*100 give the
7. Chart (J) G. a. Max value c. Percentage
b. Min value d. Average value
Ans : Percentage
8. Redo (E) H.
4. Shortcut key for spell and grammar is
a. F5 c. F7
9. Decrease and Increase Precision (D) I. b. F6 d. F8
Ans : F7
5. Shortcut key to increase indentation in MS Word is
10. Print Preview (C) J.
a. Ctrl+M c. Ctrl+D
b. Ctrl+N d. Ctrl+E
Ans : Ctrl+M
6. A1 to J1 contains mark obtained by CCA student June 2016
Exam. What is the average mark obtained?
a. Fx=average(A1 to J1) c. Fx=Average(A1;J1)
b. Fx=average(A1,J1) d. Fx=Average(A1:J1)
Ans : Fx=Average(A1:J1)
7. In Ms Word, = rand(6,2) gives:
a. 6 paragraphs and 2 columns of text
b. 6 paragraphs and 2 sentences of text
c. 6 columns and 2 paragraphs of text
 d. 6 sentences and 2 paragraphs of text 17. Which one of this is an example of ‘Absolute referencing’
Ans : 6 paragraphs and 2 sentences of text a. E$1 c. $E1
8. To select all, which key is used? b. $E$1 d. Both a & c
a. Ctrl+A c. Shift+A Ans : $E$1
b. Ctrl+Alt+A d. Ctrl+Shift+A 18. In Ms Excel F2 function key is used to
Ans : Ctrl+A a. Edit cell value c. View cell
9. Replace command shortcut key is b. Format text d. None of the above
a. Ctrl+H c. Ctrl+R Ans : Edit cell value
b. Ctrl+G d. Shift+R 19. MS Excel chart sheet is also used in
Ans : Ctrl+H a. Ms Word c. Only in MS Word
10. Spreadsheet is also known as b. MS powerpoint d. Both a & b
a. MS Word c. Ms PowerPoint Ans : Both a & b
b. Ms Excel d. All of these 20. Print shortcut key is
Ans : Ms Excel a. Ctrl+P c. Shift+P
11. ____ has icons for the most frequently used command b. Alt+P d. Both a&b
a. Menu bar c. Standard toolbar Ans : Ctrl+P
b. Formatting toolbar d. Drawing tool bar
Ans : Standard toolbar
12. Combination of rows and columns form B. TRUE OR FALSE (10x1=10)
a. Cell value c. Graph
b. Table d. None of the above 1. Autocorrect is in the Tool Menu. T
Ans : Cell Value
13. Animation is also known as 2. Row is also known as vertical bar. F
a. Transition c. Editing 3. Replace all option change all the occurrence of a particular word. T
b. Special Effect d. Formatting
Ans : Transition 4. Graph can only be used in MS Excel. F
14. Slide is nothing, but a presentation _____
5. PowerPoint offer 25 different types of Auto Layout. F
a. view c. effect
b. animation d. page 6. Collection of worksheet is called workbook. T
Ans : page
15. Print what: combo box is present in _____ print dialog box 7. You can change a chart type to any other type and embed that
a. MS Word c. Ms PowerPoint into your workbook. T
b. Ms Excel d. All of the above
8. Slide shorter is a miniature view of slide. T
Ans : All of the above
16. Slide timing can be set for 9. Clipart pictures can be group but ungrouping. F
a. Each slide c. only one slide
b. Slide with special effects d. All slide collectively 10. MS Excel use relative reference. T
Ans : All slide collectively
37. What is the file extension of word 2003? MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
1) doc 3) pdf Diploma Course Examination, December, 2016
2) docx 4) xls Semester-I, Diploma in Computer Application
38. Merge cell join the _____ Subject : Office Automation Software (DCA-103)
1) Columns 3) Only row
2) Rows 4) Both 1) and 2) Full Mark : 40 Time : 1 hour
39. The valid minimum and maximum zoom size in MS Office is
1) 10,500 3) 50,800 A. Choose the correct answer (1X40=40)
2) 10,200 4) 20,500 1. Pictures, Table, Shapes, etc. are inserted from
40. Name this sign 1) Add-in menu 3) Mailings menu
1) Omega 3) Equation 2) Insert menu 4) Drawing toolbar
2) Symbol 4) Object 2. The character and paragraph settings are manipulated from _____
1) Format menu 3) Standard toolbar
2) View menu 4) Edit menu
3. Existing file can be retrieved from __________
1) View menu 3) File menu
2) Edit menu 4) Format menu
4. Name this sign
1) Eraser 3) Font style
2) Clear character 4) Clear Formatting
5. A __________ is a visual representation of numeric data
1) Shapes 3) Chart
2) Text box 4) Table
6. MS Office developed by
1) IBM 3) Dell
2) Microsoft 4) Apple
7. The sum ( ) function has
1) One argument 3) Two argument
2) Three argument 4) More than one argument
8. Name this sign
1) Make paragraph 3) Decrease and increase decimal
2) Indentation decrease and increase 4) Both 1) and 3)
9. Formulae must be preceded by
1) + 3) –
2) = 4) ∞
10. Address of cell where row 12 and column AG meets is
1) A12G 3) AG12 3) 12 AG 4) Both 2) and 3)
11. In PowerPoint presentation F5 is used to
1) Slide show 3) Open new slide
2) Change the slide transition 4) Slide sorter
12. Name this sign 25. Undo command is _______
1) To the base 2 and X square 3) Subscript and Superscript 1) Ctrl+U 3) Ctrl+Y
2) Increase by two 4) None of the above 2) Ctrl+Z 4) Shift+U
13. In a ________ master document is the one which contain the recipients 26. Horizontal page orientation is called ______
of the letter with place holders for the variable information 1) Landscape 3) Portrait
1) Reference 3) Data Sheet 2) Oriental 4) Both 1) and 2)
2) Mail Merge 4) Both 2) and 3) 27. ________ is the extension of PowerPoint presentation
14. Which of these toolbar allow changing of font and their sizes? 1) .ppt 3) .pts
1) Standard 3) Status 2) .ptp 4) .pptx
2) Formatting 4) Drawing 28. Name this sign
15. Which of the following shortcut key changes the font size? 1) Chane font size 3) Change styles
1) F4 3) Ctrl+} 2) Word art 4) Sort
2) Shift+F3 4) Ctrl+F 29. Font size are measured in
16. Name this sign 1) Picas 3) Character
1) Play media 3) Test run 2) Points 4) Bytes
2) Slide show from beginning 4) Play slide 30. Footer appear at the bottom of _______ page(s) once inserted.
17. To insert new slide; which of the following key is used 1) First but the rest 3) First
1) Ctrl+N 3) Ctrl+O 2) All the rest but the first 4) All
2) Ctrl+M 4) Ctrl+F3 31. ________ shows margin and tab settings
18. Underlined letter in the menu bar is activated by which key? 1) View menu 3) Format
1) F10 3) Shift key 2) Ruler 4) Page layout menu
2) Alt key 4) Ctrl key 32. Name this sign
19. Table is formed by a combination of __________ 1) Search 3) Replace
1) Rows and Columns 3) Cell and lines 3) Find 4) Go to
2) Only rows 4) Only columns 33. Status bar is a bar at the ________ of the screen
20. Name this sign 1) Top 3) Bottom
1) Insert function 3) Insert formula 2) Centre 4) Below menu bar
2) Insert value 4) Both 1) and 3) 34. Page orientation is of _______ types.
21. Cell is the intersection of ______ 1) No limit 3) Four
1) Left and right 3) Column and row 2) One 4) Two
2) Four lines 4) None of the above 35. Which of these keys allow changing of indentation?
22. Clipboard stored data _______ 1) Ctrl+N 3) Ctrl+M
1) Permanently 3) Temporarily 2) Ctrl+I 4) Ctrl+P
2) Semi-permanent 4) All of the above 36. Name this sign
23. Ctrl+O is used to ________ existing file 1) Change font size 3) Change styles
1) Order 3) Open 2) Word art 4) Sort
2) Operate on 4) options of
24. Name this sign
1) Change font size 3) Change style
2) Word Art 4) Short
 MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
Diploma Course Examination, June, 2017
38. represent Semester-I, Diploma in Computer Application
1) Zoom 2) Magnifier 3) Print Preview 4) Search Subject : Office Automation Software (DCA-103)
39. When you want to copy formatting from one item to another we use:
1) Paint brush 3) Format Painter Full Mark : 40 Time : 1 hour
2) Brush eraser 4) Brush filter
A. Choose the correct answer (1X40=40)
1. ……… is a picture or graphic that can be inserted into a word
40. represents processed document.
1) Combo box 3) Check box 1) Insert picture 3) Slide Templates
2) List box 4) Drop down box 2) Clipart 4) None of the above
2. A series if number can easily be added up using
1) Sigma 2) Formulation 3) Autosum 4) Equation
3. Circular representation of graph in MS Office is called
1) Set timer 2) Bar graph 3) Pie Chart 4) Pie graph

4. represent
1) Slide sorter 3) Slide selector
2) Slide preview 4) Documentation
5. The decorative text that you can add to a document
1) ClipArt 2) WordArt 3) DropCap 4) SmartArt
6. Summation of values possible in MS Excel from
1) Different cell value 3) Values from column
2) Values from row 4) All of the above
7. To make a table in MS PowerPoint Presentation
1) Row Is more important than column
2) Column is more important than row
3) Row and Column have equal importance
4) Power point Presentation do not support Table
8. Shift+F3 (Change case) do not function in
1) MS Excel 3) MS Word
2) PowerPoint Presentation 4) None of the above
9. To draw a chart in MS PowerPoint Presentation
1) MS Excel worksheet is link 3) It has its own chart
2) Table from word is link 4) Both 1) and 2) is possible
10. Unlike Word and Excel Power point presentation has
1) One Orientation 3) No paper orientation
2) Three orientation 4) None of the above
11. In which pull down menu „Close‟ command is present 25. Records can be sorted using ………. ways.
1) File 2) Edit 3) Exit 4) Window 1) 1 2) 2 3) 3 4) 4
12. In MS Office, enter key is used to go to 26. Microsoft word is
1) New line 3) Start new paragraph 1) Calculating machine 3) Word Processor
2) Confirm confirmed 4) All of the above 2) Image Processor 4) Presentation Program
13. The default extension of word 2003 file as 27. Microsoft Power Point is
1) docx 2) docs 3) doc 4) dox 1) Calculating Machine 3) Word Processor
14. To select multiple line vertically in MS Word what key combination with 2) Image Processor 4) Presentation Program
mouse is use? 28. To select text in MS Word, we use
1) Alt 2) Ctrl 3) Shift 4) F3 1) Ctrl+V 2) Ctrl+A 3) Ctrl+S 4) Ctrl+P
15. What key combination increases the indentation? 29. To replace cell in MS Excel, we use
1) Ctrl+F3 2) Ctrl+D 3) Ctrl+M 4) Ctrl+K 1) Ctrl+H 2) Ctrl+I 3) Ctrl+F 4) Ctrl+Q
16. Page number can be place in the ………….. in MS Word 2003. 30. The row number of cell G3 is
1) Footer 3) Header and Footer 1) 1 2) 2 3) 3 4) 4
2) Header 4) All of the above 31. PowerPoint presentation is equipped with ……… command
17. Alignment can also be made using ………….. 1) AutoSum 2) Shape 3) WordArt 4) All of the above
1) Tab position tools 3) Alignment tools 32. To slide show the presentation, which key is use?
2) Indentation 4) All of the above 1) F3 2) F4 3) F5 4) F11
18. =IF(A1<B1,“A1 is greater than B1”.””) give …… as output. (Given that 33. PowerPoint presentation uses ClipArt,
Cell A1=5 and B1=7) 1) Which are different from other Office application
1) A is greater than B 3) A and B are equal 2) Which are different from word and Excel
2) B is greater than A 4) Print nothing 3) Which are same with that of other Office application
19. Moving sheet to another sheet location is done using ………….. key. 4) It has different clipart library
1) Shift+Mouse drag 3) Ctrl+Mouse drag 34. Mail merge recipients is limited to
2) Alt+Mouse drag 4) Ctrl+Shift+Mouse drag 1) 30 2) 40 3) 50 4) None of the above
20. Underlined letter in the menu bar is activated by …………….. key. 35. For tabulation and for calculation
1) F10 2) Alt 3) Both 1) and 2) 4) 1) only 1) MS Excel is more useful than MS Word
21. Conditional formatting can be pull down from ……………. 2) MS Word is more useful than MS Excel
1) Tools menu 3) View menu 3) MS Word is better for Calculation but tabulation
2) Format menu 4) edit menu 4) None of the above
22. To change the file name and or location of the file of saved file after
editing we use ………….
1) Save 3) Both 1) and 2) 36. represent
2) Save as 4) None of the above 1) Option buttons 3) Check Boxes
23. Cursor position is the ………….. 2) Command buttons 4) List boxes
1) Type head 3) Print head
2) Mouse pointer 4) Tab position
24. …………. Shows margins and tab setting 37. represent
1) Ruler 2) Format 3) Status bar 4) Tab position 1) WordArt Style 3) Character Style
2) Font Style 4) ClipArt Style
35. Ctrl+O is used to ______ existing files MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
1) Order 3) Open Diploma Course Examination, December, 2017
2) Operate on 4) Options of Semester-I, Diploma in Computer Application
Subject : Office Automation Software (DCA-103)
36. Name this sign
1) Change font size 3) Text orientation Full Mark : 40 Time : 1 hour
2) Word art 4) Clear formatting
37. Undo command is ________ A. Choose the correct answer (1X40=40)
1) Ctrl+U 3) Ctrl+Y 1. In Power point presentation ______ key is used to slide show
2) Ctrl+Z 4) Shift+U 1) F2 2) F4 3) F3 4) F5
38. Horizontal page orientation is called _______
1) Landscape 3) Portrait 2. Name this sign
2) Oriental 4) 1) and 2) 1) To the base 2 and X square 3) Increase and decrease by two
39. ________ is the extension for PowerPoint presentation 2) Subscript and Superscript 4) None of the above
1) .ppt 3) .pts
2) .ptp 4) .pptx 3. Name this sign
40. Clipboard stores data ______ 1) Play media 3) test run
1) Permanently 3) Temporarily 2) Slide show from beginning 4) Play slide
2) Semi-permanent 4) All of the above 4. Which of the following shortcut key changes the font size?
1) F4 3) Ctrl+}
2) Shift+F3 4) Ctrl+F
5. To insert new slide; which of the following key is used?
1) Ctrl+N 3) Ctrl+O
2) Ctrl+M 4) Ctrl+F3
6. Underlined letters in the menu bar is activated by which key?
1) F10 3) Shift key
2) Alt key 4) Ctrl key
7. Table is form by a combination of _____
1) Rows and Column 3) Cell and lines
2) Only rows 4) Only columns

8. Name this sign

1) Sort and Filter 3) Sort Ascending
2) Sort Descending 4) 1) and 3)
9. Cell is the intersection of _______
1) Left and Right 3) Column and Row
2) Four lines 4) None of the above
10. Which of these toolbars allow changing of font and their size? 23. Which of these keys allow changing of indentation?
1) Standard 3) Status 1) Ctrl+N 3) Ctrl+M
2) Formatting 4) Drawing 2) Ctrl+I 4) Ctrl+P
11. What is the file extension of word 2003? 24. Name this sign
1) doc 2) docx 3) pdf 4) xls 1) Change font size 3) Change style
12. Merge cell joins the: 2) Word art 4) Sort
1) Columns 3) Only rows 25. In ______, a master document is the one which contains the recipients of
2) Rows 4) Both 1) and 2) the letter with place holders for the variable information.
13. Object are inserted from _____ 1) Mail merge 3) Add-Ins
1) Add-ins menu 3) mailings menu 2) Reference 4) 2) and 3)
2) Insert menu 4) Drawing toolbar 26. The valid minimum and maximum zoom size in MS Office is
14. The character and paragraph settings are manipulated from ____ 1) 10 and 500 3) 50 and 800
1) Format menu 3) Standard toolbar 2) 10 and 200 4) 20 and 500
2) View menu 4) Edit menu
15. Existing files can be retrieved from edit menu 27. Name this sign
1) View menu 3) File menu 1) Shape 3) Bar chart
2) Edit menu 4) Format menu 2) Pie Chart 4) Object

16. Name this sign 28. What is this sign

1) Delete sheet rows 3) Delete sheet Columns 1) Eraser character 3) Erase Formatting
2) Delete sheet 4) All of the above 2) Clear character 4) Clear Formatting
17. Font size are measured in _____ 29. A ______ is a visual representation of numeric data
1) Picas 3) Character 1) Shapes 3) Chart
2) Points 4) Bytes 2) Text box 4) Table
18. Footer appears at the bottom of ____ page(s) once inserted. 30. MS Office was developed by
1) First but the rest 3) First 1) IBM 2) Microsoft 3) Dell 4) Dell
2) All the rest but first 4) All of the above 31. The sum ( ) function has
19. ______ shows margin and tab settings 1) One argument 3) Three argument
1) View menu 3) Format 2) Two arguments 4) More than one arguments
2) Ruler 4) Page Layout Menu
20. Name this sign 32. Name this sign
1) Search and select 3) Replace 1) Make paragraph
2) Find and Select 4) None of the above 2) Show paragraph marks and other hidden formatting symbol
21. Status bar is a bar at the __________ of the screen. 3) Show Drop cap and other formatting symbols
1) Top 3) Bottom 4) 1) and 3)
2) Centre 4) Below menu bar 33. Formulae must be preceded by ______ sign in excel
22. Page orientation is of _________ types. 1) + 2) = 3) - d) ∞
1) No limit 3) Four 34. Address of cell where row No. 2 and column No. G meets is
2) One 4) Two 1) 2G 2) G2 3) 2G 4) 1) and 3)
34. If mark obtained is 85 or above it is graded “outstanding” else it is MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
graded pass. What is the output of the IF statement?’ =IF(G6> Diploma Course Examination, June, 2018
85,”outstanding”,”Passed”)’. Given: student X’s mark Obtained is 72 Semester-I, Diploma in Computer Application
a) Outstanding c) Passed Subject : Office Automation Software (DCA-103)
b) First division d) Second division
35. ________ allows you to organize the order and status of the slides in
your presentation Full Mark : 40 Time : 1 hour
a) Slide view c) Slide shorter view
b) Outline view d) All of the above A. Choose the correct answer (1X40=40)
36. Animation are ______ that are applied to the elements on a slide 1. The drawing toolbar helps in drawing objects in a
a) Transitions c) Slide timing a) Word Document c) Power Point Presentation
b) Effects d) All of the above b) Excel spreadsheet d) All of the above
2. The status bar displays the
37. represent a) Current page number c) Live and column number
a) Undo c) Reset b) Total number of page d) All of the above
b) Link back d) layout 3. The most frequently used commands/tools are displays in
a) Menu bar c) Formatting toolbar
38. represent b) Standard Toolbar d) Status bar
a) Slide orientation c) Slide animation 4. The header and footer tools is activated via the____
b) Slide Transition d) None of the above a) Format menu c) Insert
39. PowerPoint offers ______ different types of slide layout called auto b) Edit menu d) File menu
layout 5. Common typing/ spelling mistakes in word can be corrected using
a) 22 c) 24 suggestions _______
b) 23 d) None of the above a) Spell checking c) Auto correct
40. Which of the follow is a popular presentation graphics software b) Find and replace d) All of the above
a) PowerPoint c) Corel Draw 6. The tables and borders toolbar has number of components they are
b) Harvard Graphic d) All of the above a) Border size button, line size box, shading button
b) Border style button, line style box, shading box
c) Border style box, line size button, shading style
d) Both B and C
7. _______ lets you copy a format applied in one section of a document to
other portion of the document.
a) Font style c) Exit menu
b) Text Formatting d) Format painter
8. Cells in a table can be merge using _____ button
a) Split cells c) Auto format
b) Merge cells d) None of the above
9. Mail merge includes merging of ____ separate documents
a) 2 c) 4
b) 3 d) 5
10. Text excel spread sheet is ____ by default 22. Which order is ideal for Power Point Presentation design
a) Left aligned c) Right aligned a) The presentation, audience, content, decoration
b) Centre aligned d) No default alignment b) The Presentation, the content, the audience, decoration
11. In excel sheet addition/ summation is done using ____ expression c) The content, the Presentation, the Audience, decoration
a) =A1+A2+A3+A4 c) +A1+A2+A3+A4 d) The audience, the Presentation, the content, decoration
b) =Sum(A1:A4) d) All of the above 23. _______ refers to the setting the page size, page orientation and page
12. To edit cell value, ______ is the key that similarly functions as the mouse margin.
double click a) Page setting c) Page layout
a) F2 c) F4 b) Page setup d) none of the above
b) F3 d) F5 24. The ______ dialog box displays the number of pages, characters,
13. Average is calculated using _______ paragraphs and lines included in the word document
a) =Average(C6;G6) c) =Average(C6,D6,E6,F6,G6) a) Status bar c) Word count option
b) =Average(C6:G6) d) Both A and C b) Auto correct d) None of the above
14. When the selection is one with multiple rows/columns it is called 25. The shortcut key to display find and replace option is
a) Data series c) Several Series a) Ctrl+F c) Ctrl+G
b) Multiple Series d) None of the above b) Ctrl+H d) Ctrl+R
15. _____ are limited to one data series 26. File extension/ secondary file name of Powerpoint is
a) Column chart c) Live chart a) .pptx b) .ppt(2003) c) .ptt d) .xppt
b) Pie chart d) Both A and C 27. ______ refers to the formats that effect the appearance of the individual
16. Background of the presentation can be change from ______ characters
a) Slide layout c) Edit slide a) Text style c) Character style
b) Apply design d) Design menu b) Font style d) None of the above
28. Text alignment in word document is of _______ types
17. represent a) 2 b) 3 c) 4 d) 5
a) Group c) Shapes 29. Excel comprises a total of _____ columns and rows
b) Arrange d) None of the above a) 256; 65,536 c) 512; 65,536
b) 255; 65,535 d) 512; 65,535
18. Represent (in PowerPoint) 30. The cell on which you click is the _____
a) Fill Colour c) Fill style a) Current cell c) Existing cell
b) Paint Colour d) Background Style b) Active cell d) Both A and B
31. A collection of worksheets is called ________
19. represent a) Spreadsheets c) Workbook
a) Custom slide show c) Hide slide b) Sheets d) Work sheets
b) Set up slide show d) None of the above 32. Reference that change automatically when you copy them to a new cell
20. The PowerPoint start up dialog box have which of the following options are called _____
a) Auto-content wizard c) Blank presentation a) Absolute reference c) Relative reference
b) Template d) All of the above b) Mixed reference d) None of the above
21. Word has ________ predefined bullet types 33. From the list of value C6 to C14 largest number is formed using
a) 4 c) 6 a) =Min(C6:C14) c) =LARGE(C5:C14)
b) 5 d) 8 b) MAX(C6:C14) d) All of the above
35. Print what: combo box is present in _____ print dialog box MIZORAM STATE COUNCIL FOR TECHNICAL EDUCATION
a) MS Word c) MS Power Point Diploma Course Examination, December 2018
b) MS Excel d) All of these Semester-I, Diploma in Computer Application
36. A4 size paper dimension is ……….. Subject : Office Automation Software (DCA-103)
a) 8.5”X14” c) 8.5”X13”
b) 8.27”X11.69” d) 8.26”X11.69”
37. There are ……. Number of default measurement units in MS Word A. Choose the correct answer (1X40=40)
a) 3 b) 4 c) 5 d) 6 1. In MS Excel, when enter key is press, the cursor moves
38. Slide Timing can be set for a) Upward c) Previous cell
a) Each Slide c) Only one slide b) next cell d) Downward
b) Slide with Special effects d) All Slides Collectively 2. MS Excel 2007 file extension is ……
39. „Absolute referencing‟ is: a) XLX c) XLS
a) E$1 c) $E1 b) XLXS d) XLSX
b) $E$1 d) Both (a) and (c) 3. A ghosted text behind the content of the page is called
40. In MS Excel F2 function key is use to a) Washout c) Waterout
a) Edit cell value c) View Cell b) washmark d) watermark
b) Format text d) None of the above 4. Sound can be added to a presentation to make it more ______
a) Effective c) Beautiful
b) Attractive d) All of the above

5. represent
a) Highlight c) New frame
b) Tool tip d) New slide
6. Given : cell A1=1; then, IF(A1<10,“1 digit”,“2 or more digits”),
What is the output?
a) 1 digit c) No output
b) 2 or more digits d) Both (a) and (b)

7. represent
a) Line Chart c) Shape
b) Center tab d) Symbol
8. MS Excel chart sheet is also use in
a) MS Word c) Only in MS Word
b) MS Power Point d) Both (a) and (b)
9. Open shortcut key is
a) Ctrl+O c) Shift+O
b) Alt+O d) Both (a) and (b)
10. Given : cell A1 to A10 values. Then, formula to find average is
a) =AVG(A1:A10) c) =AVG(A1-A10)
b) =AVERAGE(A1:A10) d) =AVERAGE(A1-A10)
11. Shortcut key for Spelling and Grammar is
a) F5 c) F7 23. represent
b) F6 d) F8 a) Bar chart c) Line chart
12. Shortcut key to decrease indentation in MS word is b) Column Chart d) Line chart
a) Ctrl+Shift+N c) Ctrl+Shift+D 24. Spreadsheet is also known as
b) Ctrl+Shift+M d) Ctrl+Shift+E a) MS Word c) MS Power Point
13. Autocorrect is in the b) MS Excel d) All of the above
a) Tool Menu c) View Menu 25. Chart sheet can be share by
b) Review Menu d) Insert Menu a) Different charts c) Column chart
(Office button>>word option>>proofing) b) Bar chart only d) Cannot be share
14. Row in Excel is also known as
a) Vertical bar c) both (a) & (b) 26. represent
b) Horizontal bar d) Neither (a) nor (b) a) Precision c) Bubble chart
15. To change all the occurrences of a particular word which option is used? b) hundreds d) None of the above
a) Ignore all c) Change 27. …………. is a miniature view of slides
b) Replace all d) Change all a) Presenter view c) Slide sorter
16. A1 to A10 contains an array of marks Obtained by DCA students June b) Notes page view d) Outline view
2018 Exam. Find the higher mark Obtain? 28. ______ has icons for the most frequently used commands
a) =HIGH(A1:A10) c) =HIGH(A1-A10) a) Menu bar c) Standard tool bar
b) =MAX(A1:A10) d) =MAX(A1-A10) b) Formatting Tool Bar d) Drawing tool bar
17. In MS Word, Typing “=rand (4,2)” gives…… 29. Combination of rows and columns yield
a) 4 paragraphs and 2 columns of text a) Cell value c) graph
b) 4 paragraphs and 2 sentences of text b) table d) none of these
c) 4 columns and 2 paragraphs of text 30. Animation is also known as ………… in PowerPoint
d) 6 sentences and 2 paragraphs of text a) Transition c) Editing
18. To select all, which key is used? b) Special Effects d) Formatting
a) Ctrl+A c) Shift+A 31. Pictures can be group with shapes
b) Ctrl+Alt+A d) Ctrl+Shift+A a) True c) On condition of shapes
19. Graphs can only be used in all the three offices b) False d) Both (a) & (c)
a) True c) In Word & Excel only 32. By default all references in MS Excel are ….. reference
b) False d) In Excel & PowerPoint only a) Selection c) Relative
20. Power Point includes …… different types of standard slide-layout. b) Referential d) None of the above
a) 9 c) 17
b) 24 d) 64 33. Aa represent
21. Collection of worksheets is called a) Dropcap c) Change Case
a) Books c) Sheet b) Change Style d) None of the above
b) Workbook d) Spreadsheet 34. Slide is nothing but a presentation ______
22. Replace command‟s shortcut key is a) View c) effect
a) Ctrl+H c) Ctrl+R b) Animation d) Page
b) Ctrl+G d) Shift+R