D.C.A.ST -5

S.S.COMPUTER EDUCATION INST. SUBJECT:--- D.C..A. MARKS --100 TIME :---1 HRS

ONLINE PAPER

  

The question consists of 100 questions and it divided into four section .each question to be 1 marks. 0.25 will be cut on double clicking
note:---- All types of exam material note book, wrist watch, digital things, paper will be prohibited during the exam in examination centre .

 

1. scenario manager using for ........................
   1.   setting customer demond
   2.   setting low cost
   3.   setting high cost
   4.   setting market value
2. Goal seek is one of the option ,which is ..........................
   1.   calculates the input value
   2.   calculates the out put value
   3.   calculate the input and out value based on given output
   4.   none of these
3. when we types =Randbetween(30,40),it will Generates.............................
   1.   34
   2.   35
   3.   32
   4.   33
4. consolidate function in excel work on ........................................
   1.   single sheet
   2.   doubble sheet
   3.   multiple sheet
5. Alt + += using for in excel
   1.   Auto sum
   2.   sum
   3.   multiplying
   4.   addition
6. insert a new sheet in the existing excel workbook using ....................................
   1.   F12
   2.   F10
   3.   F9
   4.   SHIFT+F11
7. What command used to print privew in excel sheet ?
   1.   SHIFT+F2
   2.   ALT+F2
   3.   CTRL+F2
   4.   NONE
8. Shortcut command for open copy, cut ,paste and so on , in excel sheet ...........................
   1.   SHIFT+F5
   2.   CTRL+F10
   3.   ALT+F10
   4.   SHIFT+10
9. We can insert border in excel sheet by ....................................
   1.   CTRL+SHIFT+P
   2.   ALT+P
   3.   SHIFT+P
   4.   CTRL+P
10. We can Bold any numbers by pressing ............................
    1.   CTRL+B, CTRL+2
    2.   ALT+B
    3.   SHIFT+B
11. What is the command for underline in excel sheet ............................
    1.   CTRL+4
    2.   CTRL+U
    3.   A & B BOTH
12. What is format cell in excel ?
    1.   used to modify the formatting of cell no. without modifying the actual number
    2.   used to modify the value of cell in excel sheet
    3.   used to change the alignment ,font style , border style of cell
    4.   none of these
13. command for displying formate cell dialog box in excel sheet ..............
    1.   SHIFT+F1
    2.   CTRL+F1
    3.   CTRL+SHIFT+F
    4.   B & C BOTH
14. press the shortcut keys for pivot table in excel ..............................
    1.   ALT+N+V
    2.   CTRL+N+V
    3.   SHIFT+V+N
    4.   NONE OF THESE
15. Appear at the bottom of the excel window
    1.   TITLE BAR
    2.   FORMULA BAR
    3.   WORK SHEET TABS
    4.   NAME BOX
16. What is the basic rectangular building blocks of a spreadsheet
    1.   ZOOM SLIDER
    2.   HELP BUTTON
    3.   ALL OF THESE
    4.   CELLS
17. Another name for a pre-programmed formula in excel is .............................
    1.   cell
    2.   Graph
    3.   function
    4.   Range
18. press.............to close an open menu or submenu ,dialog box, or message window
    1.   ESC
    2.   ALT+5
    3.   CTRL+1
19. In a spreadsheet program the .......... contains related worksheets and document
    1.   CELL
    2.   FORMULA
    3.   COLUMN
    4.   WORKBOOK
20. Form that are used to organise business data into rows and columns are called ..........................
    1.   BUSINESS FORMS
    2.   REGISTERS
    3.   TRANSACTION SHEET
    4.   SPREADSHEETS
21. Repeats the last command or action ......................................
    1.   CTRL+C
    2.   CTRL+R
    3.   CTRL+Y
    4.   CTRL+U
22. Press ............. to bring up search box
    1.   SHIFT+F3
    2.   SHIFT+F4
    3.   SHIFT+F5
    4.   SHIFT+F6
23. In ................................tab you will find Auto sum Button
    1.   FORMATTING TAB
    2.   FORMULAS BAR
    3.   FORMULAS TAB
    4.   CLIPBOARD TAB
24. What is A,B, C, D, E...........IN excel ?
    1.   cell
    2.   cell address
    3.   formula
    4.   function
25. what called that cell ,Where pointer availabe ...............................
    1.   cell address
    2.   active cell
    3.   pointer
    4.   cell value
26. Which enables us to send the same letter to different persons ?
    1.   MACROS
    2.   TEMPLATES
    3.   MAIL MERGE
    4.   NONE OF THESE
27. A word processor would most likely be used to do
    1.   keep an account of money spent
    2.   Do computer search in media center
    3.   maintain an inventory
    4.   type a biography
28. what is gutter margin ?
    1.   Margin that is added to the left margin when printing
    2.   margin that is added to right margin when printing
    3.   margin that is added to the binding side of page when printing
29. microsoft word is ....................software
    1.   application
    2.   comiler
    3.   system
    4.   programming
30. Which is not in m.s.word
    1.   italic
    2.   magic word
    3.   font
    4.   Bold
31. ..................can't used to work in m.s.office ?
    1.   joystick
    2.   scanner
    3.   light pen
    4.   mouse
32. The ....................work with the standard copy and paste commands.
    1.   view tab
    2.   paragraph dialog box
    3.   office clipoard
    4.   all of these
33. what is the blank space outside the printing area on a page
    1.   clipart
    2.   margin
    3.   header
    4.   footer
34. What of the following is an example of page orientation
    1.   landscape
    2.   subscript
    3.   A4
    4.   superscript
35. Formatting is performed on ..............................
    1.   text
    2.   table
    3.   menu
    4.   A & B both
36. Which of the following software is used for making a Resume ?
    1.   ms excel
    2.   ms word
    3.   Dev c
    4.   java
37. press .................to open the help window in the ms word document
    1.   F1
    2.   F2
    3.   F9
    4.   F11
38. which can be used for quick access to commonly used command and tools ?
    1.   status bar
    2.   Toolbar
    3.   Menubar
    4.   title bar
39. which file starts with ms word
    1.   winword.exe
    2.   word.exe
    3.   msword.exe
    4.   word356.exe
40. what are inserted as cross reference in word ?
    1.   placeholders
    2.   bookmarks
    3.   objects
    4.   word fields
41. The full form of BAsic ?
    1.   Beginner all purpose symbolic instruction code
    2.   ms office
    3.   ms word
    4.   word pad
42. To open an calculator in m.s.word ?
    1.   CTRL+F9
    2.   SHIFT+F9
    3.   ALT+F9
    4.   F9
43. +------------------------+-------------------------+---+---------------------+ IN THIS section ,how many box can be created.
    1.   3
    2.   2
    3.   4
    4.   6
44. what is the shortcut command for print layout ?
    1.   alt+ctrl+p
    2.   alt+ctrl+a
    3.   ctrl+p
45. command for creating a folder ................................
    1.   ctrl+shift+n
    2.   alt+shift+n
    3.   ctrl+n
46. command for theasurus in m.s.word ?
    1.   shift+f7
    2.   ctrl+f7
    3.   alt+f7
    4.   none of these
47. what is the command for Header and footer ?
    1.   ALT+V+H
    2.   CTRL+V+H
    3.   ALT+V+L
    4.   SHIFT+V+L
48. Command for Drop cap ....................
    1.   ALT+O+D
    2.   SHIFT+O+D
    3.   CTRL+O+D
    4.   ALT+SHIFT+T
49. Symbol is one of the .........................
    1.   coded character
    2.   unicoded character
50. command for created column in your text ...............................
    1.   ALT+O+C
    2.   ALT+O+D
    3.   ALT+O+P
    4.   ALT+O+T
51. In m.s. powerpoint presentations the designs rugulate the layout and formating for the slide ,these are commonly known as ..................
    1.   Blueprints
    2.   placeholder
    3.   templates
    4.   Design plates
52. The hand out master consists of placeholders for all of these except the ..............................................
    1.   title
    2.   slide number
    3.   header
    4.   footer
53. which of these powerpoint feature would allow any user to create a given simple presentation quicker ?
    1.   Animation
    2.   chart wizard
    3.   Transition wizard
    4.   Auto content wizard
54. The file that consist of readymade style that we can easily use for our presentation is known as :...................
    1.   pre formating
    2.   template
    3.   wizard
    4.   Auto style
55. what is the max zoom % in ms powerpoint ?
    1.   400%
    2.   300%
    3.   200%
    4.   100%
56. Which of these options in powerpoint would allow us to carry any set of slides from a given computer to another one ?
    1.   web and go
    2.   pack and go
    3.   save and go
    4.   save as
57. which of these is a type of sound file ?
    1.   dat files
    2.   log files
    3.   drv files
    4.   wav files
58. in current presentation ,if we want to insert a new slide ,we can choose which of these
    1.   ctrl+m
    2.   ctrl+f
    3.   ctrl+n
    4.   ctrl+o
59. which of these terms do we use when an image in a clip art changes the direction that it was originally facing ?
    1.   mirror
    2.   Rotate
    3.   flip
    4.   Group
60. which of these refers to the powerpoint view used for displaying only the text
    1.   slide sorter show
    2.   slide view
    3.   outline view
    4.   notes page view
61. which toolbar provides various options in different master views ?
    1.   standard toolbar
    2.   formatting toolbar
    3.   drawing toolbar
    4.   comman tast toolbar
62. we can find any and every command on the .....................................
    1.   menu bar
    2.   standard toolbar
    3.   formating toolbar
    4.   Drawing toolbar
63. which of these feature should one use when we want to type in the text box for notes ?
    1.   insert
    2.   slide shows
    3.   zoom
    4.   slide master
64. which of these is the page setup orientation by default of the slides in powepoint ?
    1.   landscape
    2.   portrait
    3.   vertical
    4.   none of these
65. from which of these menu can access a text box,picture, chart etc ?
    1.   view
    2.   insert
    3.   Edit
    4.   file
66. which of these font effects is not availabe in the powerpoint font dialogue box ?
    1.   shadow
    2.   underline
    3.   strikethrough
    4.   Emboss
67. which of these sections does a slides layout Not have ?
    1.   List
    2.   Animations
    3.   titles
    4.   charts
68. what do we use if we want to add texts in a given slides ?
    1.   comman box
    2.   text box
    3.   note box
    4.   text layer
69. which types of templates provides all the user with a design concept,colour scheme and fonts for presentation ?
    1.   content
    2.   format
    3.   normal
    4.   design
70. when we search power point ,we can write .............................
    1.   ppt
    2.   powerpnt
    3.   powerpoint
    4.   all of these
71. what is the component of ms Access ?
    1.   Table
    2.   Form
    3.   Reports
    4.   All of these
72. how many types of databases are there in ms access ?
    1.   Flate file database
    2.   Relational Database
    3.   A & b both
    4.   none of these
73. which of the following is not a component of ms access ?
    1.   Table
    2.   form
    3.   module
    4.   worksheet
74. ...............is the another name for columns in microsoft Access tables
    1.   Record
    2.   Fields
    3.   Datafield
    4.   cell
75. what is the size of yes/no fields
    1.   1kb
    2.   i bytes
    3.   1 mb
    4.   1bit
76. The tool using which predefined actions which can Automate tasks on on Access report is called .......................
    1.   micros
    2.   Form
    3.   Table
    4.   Module
77. The first version of MS Access database management system launched by microsoft was released in the year .........................
    1.   1991
    2.   1993
    3.   1992
    4.   1982
78. Disadvantages of ms Access is ....................
    1.   use over internet
    2.   not used over internet
    3.   recommended for smal database only
    4.   B and C both
79. what are ihe four object of ms access ?
    1.   table,queries , form. report
    2.   sheet, list . wizard, disign
80. what is Relationship of ms access ?
    1.   As the name suggests
    2.   when more than one table is added
    3.   many way to many
    4.   all of these
81. BIOS is used by
    1.   application software
    2.   operating system
    3.   complier
    4.   interpreter
82. THE DOS OPERATING SYSTEM IS A ...................
    1.   COMMAND DRIVEN INTERFACE ,SINGLE TASKING O.S.
    2.   GRAPHICAL USER INTERFACE ,
       MULTITASKING O.S.
83. TASK BAR IS USED FOR IN DOS .......................
    1.   START A PROGRAM
    2.   NAVIGATION PROGRAM
    3.   SWITHCHING PROGRAM
    4.   ALL OF THESE
84. THE OS USED TO OPERATE THE MOBILE PHONE IS A ..............
    1.   SMART END OS
    2.   MULTIUSER OS
    3.   EMBEDDED OS
    4.   NONE OF THESE
85. BOOT STARTUP PROCESS
    1.   PREPARE THE COMPUTER READY
    2.   CLEAN UP THE COMPUTER READY
    3.   LOAD SYSTEM FILE TO RAM
86. ..............ARE THE LIST COMMANDS THAT APPEAR ON THE SCREEN
    1.   WINDOW
    2.   MENUS
    3.   ICONS
    4.   GUIS
87. VIRTUAL MEMORY LOCATED ON ........................
    1.   FLASH CARD
    2.   HARD DRIVE
    3.   CENTRAL PROCESSING UNIT
    4.   READ ONLY MEMORY
88. THE CORE OF OPERATING SYSTEM IS ................
    1.   UNIX
    2.   KERNEL
    3.   NONE OF THESE
89. WHO WAS THE FIRST MICROSOFT OPERATING SYSTEM
    1.   MSDOS
    2.   MS OFFICE
    3.   WORD PAD
    4.   NOTE PAD
90. MS DOS DEVELOPED BY ..............................
    1.   PAL ALEN
    2.   BILL GATES
    3.   ADROW MICHAL
    4.   NONE OF THES
91. the physical stracture of computer called .....................
    1.   hardware
    2.   software
    3.   application software
    4.   system software
92. for finding mistake in software is called ....................
    1.   booting
    2.   Debugging
    3.   processing
    4.   all of these
93. Google and yahoo is one of the .........................
    1.   compiler
    2.   software
    3.   search engine
    4.   search box
94. the full form of WIFI ..............................................
    1.   wireless network
    2.   wireless fidelity
95. touch screen one of the ....................
    1.   input device
    2.   output device
96. what is DSL in computer
    1.   BROAD BAND
    2.   NETWORKCARD
    3.   TELEPHONE CONNECTION
97. The first computer of world was .........................
    1.   ABACUS
    2.   SIDHARTH
    3.   PARAM
    4.   NONE OF THESE
98. First computer language was .............................?
    1.   fortran
    2.   cobol
    3.   pascal
    4.   c- language
99. The first web browser prepared by Goole company is ................................?
    1.   Crome
    2.   yahoo
    3.   Google
    4.   mozila fire fox
100. Founder of microsoft ...................................
     1.   PAL ELAN
     2.   BILL GATES
     3.   BOTH A & B
     4.   NO ONE