D.C.A.ST -2

https://www.s.s.computeredu.com paper code -ssc005 time : 60 min Subject:-diplome in computer application(DCA)

paper code :ssc005

  

use smart phone , paper, digital watch during the paper to be interdict .

 

1. If we write H10 & press shift and press enter together , what will appeared in excel sheet ............?
   
   1.   all sheet to be selected
   2.   A1 TO H10 range to be Selected
   3.   A TO Z Sheet to be selected
   4.   none of these
2. serial number not be effected if ,we write .................in drop down list .
   1.   =index()
   2.   =row()
   3.   =match()
   4.   =now()
3. if we write =left(select no. range,2)& right(select no.range,2) in the particular no.which is 97583984383434. , the out put will get ..............
   1.   97**34
   2.   9758**39
   3.   97583984**3434
   4.   97****34
4. for increase the length of column using .....................in excel sheet .
   1.   ctrl+^
   2.   ctrl+ %
   3.   ctrl+-------
   4.   ctrl+ ~
5. =randbetween (20,99) using for selected Number ............................
   1.   20 to 99 no.
   2.   1 to 100 no.
   3.   1 to 99 marks
   4.   none of these
6. window +D command using for .........................
   1.   minimize your sheet
   2.   maxmize & minimize sheet
   3.   duplicate value
   4.   none of above
7. if the temprature of dehra dun is 10,20,16,20 ,so what will be the avarage ..........................
   1.   17
   2.   15
   3.   20
   4.   16
8. find the LCM OF 4 and 6 using the prime factorization method ?
   1.   10
   2.   14
   3.   12
   4.   15
9. if Rishu's blood fee is 500 and consulting fee is 100 .then what will be his total amount & if we give him 20% discount .then final amount be...............?
   1.   490
   2.   450
   3.   600
   4.   480
10. we brought 10 mouse of Rupees 500 & sold 4 mouse of Rupess 600 , then what will be the income ...................?
    1.   400
    2.   450
    3.   100
    4.   40
11. if the principal is 1000 ,Rate 10% , time 5 years then calculate the monthly intrest rate ....................
    1.   300
    2.   400
    3.   500
    4.   8.33
12. workbook is the collection of ...............
    1.   workbook
    2.   cells
    3.   worksheets
    4.   none of these
13. what is the last column of an excel 2010 worksheet ?
    1.   iv
    2.   AV
    3.   XV
    4.   XFD
14. In excel found
    1.   1048574 rows
    2.   1048576 rows
15. command for inserting table in excel ?
    1.   Alt+T
    2.   shift+T
    3.   ctrl+T
16. . enabling filter in selected cell press?
    1.   ctrl+l
       .
    2.   alt+shift+l
    3.   ctrl+shift+l
17. excel display the current cells address in the ?
    1.   name box
    2.   formula bar
18. shortcut for using chart in excel ?
    1.   f11
    2.   f10
    3.   f9
19. How do you display date and time in excel
    1.   Now()
    2.   time()
    3.   today()
20. what is the command to highlight the entire column ?
    1.   ctrl+c
    2.   ctrl+spacebar
21. ..............appear at the bottom of excel window ?
    1.   title bar
    2.   name bar
22. Excel is the program that is used to prepare a
    1.   text document
    2.   spreadsheet
    3.   Database
23. which command is used to close the window of excel ?
    1.   Alt+F4
    2.   CTRL+W
    3.   CTRL+C
24. What is the total region surrounding the chart ?
    1.   chart Area
    2.   legend
    3.   clipart area
    4.   plot Area
25. Select the entire column ,press ?
    1.   Tab+C
    2.   Tab+E
    3.   Alt+space
    4.   Ctrl+space
26. when you enter text in a cell in excel . it also appear in the ?
    1.   status bar
    2.   Formula bar
    3.   Row heading
    4.   Name box
27. The fill serious dialog box in excel has ...................sections
    1.   1
    2.   Range
    3.   Formula
    4.   current cell
28. which of the following is an active cell in excel ?
    1.   cell address
    2.   Range
    3.   Formula
    4.   current cell
29. URL Stand for ......................
    
    1.   uniform resource locator
    2.   uniform real locator
30. The full form of SMPS...........................
    1.   Switch mode power supply
    2.   power supply
    3.   none of these
31. AGP Slot found in .........................
    1.   motherboard
    2.   moblie
    3.   t.v.
32. smallest storage unit of computer is...............................
    1.   kb
    2.   Gb
    3.   Eb
    4.   pb
33. Bios means in your pc is .................................
    1.   basic input system
    2.   Basic input and output system
34. system software is designed to run .................................
    
    1.   computer hardware
    2.   computer software
35. ...................is the longest key on the keyboard
    1.   spacebar
    2.   enter
    3.   Arrow
36. number ...........key is used to type numbers
    1.   space bar
    2.   shift
    3.   number
37. The small blinking line on the monitor screen is called ........
    1.   +
    2.   -
    3.   cursor
38. Alphabet keys are .................................in numbers
    1.   25
    2.   27
    3.   26
39. make the letter on capital using.......................
    1.   Backspace
    2.   space
    3.   shiftkey
    4.   capslock key
40. There are .............shift keys on a standard keyboard.
    1.   Two
    2.   three
    3.   one
41. small led light on the keyboard tell us capslock key is
    1.   on/on
    2.   on/off
    3.   off/off
42. Full stop dot comma are associated with which key .................
    
    1.   Arrow key
    2.   punctuation key
    3.   shift key
43. A mouse is an ......................
    1.   input device
    2.   output device
    3.   processing device
44. The long wire coming out of the mouse is to be connected with ......................
    1.   keyboard
    2.   ups
    3.   cpu
    4.   printer
45. computer mouse is a part of .........................
    1.   motherboard
    2.   keyboard
    3.   Hardware
    4.   Software
46. Who invented computer mouse ..............
    1.   Douglas Engelbart
    2.   charles babbage
    3.   Alan turin
    4.   Christopher latham soles
47. The fourth Generation was based on intergrated circuits ..........
    1.   True
    2.   False
48. The generation based on VLSI Microprocessor .
    1.   4th
    2.   1st
    3.   3rd
    4.   2nd
49. vacuum tubes were introduced in ...............................Generations .
    1.   first
    2.   second
    3.   third
    4.   fifth
50. in which Generation of computer microprocessors was introduced ?
    1.   second Generation
    2.   Fourth Generation
    3.   first generation
51. which is not a font style
    1.   Bold
    2.   italic
    3.   superscript
    4.   Regular
52. ladscape is
    1.   A font style
    2.   page orientation
    3.   page layout
53. F7 Keys using for ....................in m.s.word
    1.   Grammer check
    2.   find and replace
    3.   go to page
    4.   none of above
54. end note using in m.s.word for .....................
    1.   show note
    2.   end of documents
    3.   end of any text
    4.   end of page
55. when you create the first document file in word , what will be the default file name ?
    1.   page 1
    2.   doc.1
    3.   word 1
    4.   all of above
56. how many columns can you insert in a word document in maximum .
    1.   40
    2.   42
    3.   44
    4.   45
57. A symbol is one of the
    1.   character
    2.   bullet
    3.   mark
    4.   none of these
58. what is the default file extension of ms word ?
    1.   msword
    2.   .ppt
    3.   .doc
    4.   run box
59. when we open word , what is the default font style?
    
    1.   Arial
    2.   calibri
    3.   Times new Roman
    4.   kurti
60. http/www.sarkarinaukari.com what is the means of .com ....
    1.   Domain name
    2.   ip address
    3.   wordwide web
61. networking is the process of ................
    1.   transmission of data
    2.   internet
    3.   device transmission
    4.   all of above
62. when we access word wide network is called ..............
    1.   lan
    2.   wan
    3.   man
63. s.m.p.s.stand for ...............
    1.   simple mode power supply
    2.   power supply
    3.   switch mode power supply
64. operating system is on of the ....................
    1.   hardware program
    2.   computer program
65. in slide layout panel how many layouts are available for text layout be default ?
    1.   4
    2.   5
    3.   7
    4.   9
66. what lets you to create new presentation by selecting ready made font color and graphics effects ?
    1.   master slide
    2.   presentation template
    3.   design template
67. what power point feature will you use to apply motion effects to different objects of a slide ?
    1.   slide design
    2.   animation objects
    3.   animation scheme
68. which of the default page setup orientation of slide in power point
    1.   portrait
    2.   vertical
    3.   landscape
69. from which menu you can access picture,text, chart etc.
    1.   file
    2.   edit
    3.   insert
70. command for enable new slide in power point .
    1.   alt+m
    2.   shift+m
    3.   ctrl+m
71. which feature used to check spelling of the text in power point ?
    
    1.   spelling
    2.   Replace
    3.   go to
    4.   find
72. ms access is one of the ................
    1.   Data base management system
    2.   workbook management sytem
    3.   none of these
73. what is a data base ?
    1.   it is a collections of data arranged in row
    2.   its a collection of data arranged in row and colums
74. To quit ms access ,press ..............?
    1.   shift+F4
    2.   ALT+F4
75. Which of the following is not a field type in access............?
    1.   lookup wizard
    2.   ole object
    3.   hyperlink
    4.   memo
76. ms dos developed by which company ........?
    1.   dell
    2.   microsoft
    3.   TCS
    4.   lenova
77. Directory is called as a ...........in ms dos .
    
    1.   file
    2.   folder
    3.   documents
78. ms dos stand for .......................
    1.   microsecond disk operating system
    2.   microsoft disk operating system
79. MS DOS was first released in the year.........................?
    1.   1969
    2.   1972
    3.   1981
    4.   2000
80. To clear screen contents command is used ......................?
    1.   ver
    2.   dir
    3.   cls
    4.   vol
81. ................command may also be used in place of the Dos command CD ?
    1.   RMDIR
    2.   MKDIR
    3.   CHDIR
    4.   ERASE
82. full form of usb
    1.   universal serial bus
    2.   uniwarsal serial bus
83. full form of b.i.o.s.
    1.   basic input system
    2.   basic input and output system
84. full form of c.m.o.s.
    1.   complementry metal oxide semiconductor
    2.   cell metal oxide system
85. full form of CRT
    1.   Cathod raise tube
    2.   cathod random tube
86. full form of ocr
    1.   optical charater reader
    2.   optical charater text reder
87. full form of omr
    1.   optical mark reader
    2.   optical mark raise
88. full form of e-mail
    1.   electronic mail
    2.   e-learning mail
89. full form of Url
    1.   union resource locate
    2.   universal resource locator
90. FAT file is called as .....................
    1.   file location table
    2.   folder
    3.   drive
    4.   file locate
91. full form of Wifi
    1.   wireless network
    2.   wireless fidelity
92. what is DSl in computer
    1.   broad band
    2.   device
    3.   network wire
93. form form of ALU
    1.   airthmetic and logic unit
    2.   Aromatic and logic unit
94. extension of power point
    1.   .ppt
    2.   powernt
95. extension of paint
    1.   .bmp
    2.   mspaint
96. Extension of excel is ............
    1.   .xls
    2.   msexcel
97. Extension of m.s.access is ................
    1.   .accdb
    2.   .mdb
98. full form of PDF IS ........................
    1.   ACROBAT READER
    2.   PORTABLE DOCUMENT FORMAT
99. Command for theme in m.s.word documents.........................
    1.   alt+0+h
    2.   ctrl+0+h
    3.   shift+o+h
100. watermark in m.s.word is one of the ...................
     1.   symbol
     2.   text
     3.   mark
     4.   none of these