Quiznetik
Computer Applications for Economic Analysis | Set 1
1. The basic architecture of computer was developed by
A. john von neumann
B. charles babbage
C. blaise pascal
D. garden moore
Correct : B. charles babbage
2. Can you tell what passes into and out from the computer via its ports?
A. data
B. bytes
C. graphics
D. picture
Correct : A. data
3. Which of the items below are considered removable storage media?
A. removable hard disk cartridges
B. (magneto-optical) disk
C. flexible disks cartridges
D. all of the above
Correct : D. all of the above
4. Which of the following is not purely output device?
A. screen
B. printer
C. speaker
D. plotter
Correct : D. plotter
5. In how many generations a computer can be classified?
A. 6
B. 3
C. 4
D. 5
Correct : D. 5
6. The brain of any computer system is
A. alu
B. memory
C. cpu
D. control unit
Correct : C. cpu
7. What difference does the 5th generation computer have from other generation computers?
A. technological advancement
B. scientific code
C. object oriented programming
D. all of the above
Correct : D. all of the above
8. __________ is the signals or data received by the system.
A. input
B. error
C. exception
D. output
Correct : A. input
9. Signals or data sent from system is called as ______________.
A. input
B. variable
C. exception
D. output
Correct : D. output
10. The first Macintosh computer was from
A. first generation
B. second generation
C. third generation
D. fourth generation
Correct : A. first generation
11. Which is not a computer classification?
A. mainframe
B. max frame
C. mini
D. notebook
Correct : B. max frame
12. Which operation is not performed by computer
A. inputting
B. processing
C. controlling
D. understanding
Correct : D. understanding
13. A collection of related instructions organized for a common purpose is referred to as
A. file
B. database
C. program
D. none of above
Correct : C. program
14. Which language is directly understood by the computer without translation program?
A. machine language
B. assembly language
C. high level language
D. none of above
Correct : B. assembly language
15. On which aspect the analog computers are better than digital?
A. speed
B. accuracy
C. reliability
D. automatic
Correct : A. speed
16. Which of the following terms is the most closely related to main memory?
A. non volatile
B. permanent
C. control unit
D. temporary
Correct : A. non volatile
17. The word length of a computer is measured in
A. bytes
B. millimetres
C. meters
D. bits
Correct : A. bytes
18. Which unit holds data permanently?
A. input unit
B. secondary storage unit
C. output unit
D. primary memory unit
Correct : B. secondary storage unit
19. Computer system comprises of major units
A. input unit, output unit, control unit
B. input unit, output unit, control unit and storage
C. input unit, output unit, central processing unit and storage unit
D. input, output and storage units
Correct : C. input unit, output unit, central processing unit and storage unit
20. Signals can be analog or digital and a computer that processes the both type of signals is known as
A. analog computer
B. digital computer
C. hybrid computer
D. mainframe computer
Correct : C. hybrid computer
21. Which company is the biggest player in the microprocessor industry?
A. motorola
B. ibm
C. intel
D. amd
Correct : C. intel
22. Which of the following is a storage device?
A. tape
B. hard disk
C. floppy disk
D. all of the above
Correct : D. all of the above
23. Central Processing Unit is combination of
A. control and storage
B. control and output unit
C. arithmetic logic and input unit
D. arithmetic logic and control unit
Correct : D. arithmetic logic and control unit
24. CD-ROM stands for
A. compactable read only memory
B. compact data read only memory
C. compactable disk read only memory
D. compact disk read only memory
Correct : C. compactable disk read only memory
25. What type of device is computer keyboard?
A. memory
B. output
C. storage
D. input
Correct : D. input
26. Fifth generation computer is also known as
A. knowledge information processing system
B. very large scale integration (vlsi)
C. both of above
D. none of above
Correct : A. knowledge information processing system
27. ALU is
A. arithmetic logic unit
B. array logic unit
C. application logic unit
D. none of above
Correct : A. arithmetic logic unit
28. WAN stands for
A. wap area network
B. wide area network
C. wide array net
D. wireless area network
Correct : B. wide area network
29. Second Generation computers were developed during
A. 1949 to 1955
B. 1956 to 1965
C. 1965 to 1970
D. 1970 to 1990
Correct : B. 1956 to 1965
30. The computer size was very large in
A. first generation
B. second generation
C. third generation
D. fourth generation
Correct : A. first generation
31. Microprocessors as switching devices are for which generation computers
A. first generation
B. second generation
C. third generation
D. fourth generation
Correct : B. second generation
32. Which generation of computer is still under development
A. fourth generation
B. fifth generation
C. sixth generation
D. seventh generation
Correct : B. fifth generation
33. Which statement is valid?
A. 1kb = 1024 bytes
B. 1 mb=2048 bytes
C. 1 mb = 1000 kilobytes
D. 1 kb = 1000 bytes
Correct : A. 1kb = 1024 bytes
34. Software in computer
A. enhances the capabilities of the hardware machine
B. increase the speed of central processing unit
C. both of above
D. none of above
Correct : C. both of above
35. Which of the following is a secondary memory device?
A. keyboard
B. disk
C. alu
D. all of the above
Correct : B. disk
36. The differeŶĐe ďetǁeeŶ ŵeŵory aŶd storage is that ŵeŵory is … aŶd storage is …
A. temporary, permanent
B. permanent, temporary
C. slow, fast
D. all of above
Correct : A. temporary, permanent
37. Which will not harm computer resources
A. firewall
B. virus
C. trojan horse
D. none of the above
Correct : A. firewall
38. The first Generation computer was based on which technology?
A. transistor
B. lsi
C. vlsi
D. vaccum tube
Correct : D. vaccum tube
39. Who protects system from external threats?
A. firewall
B. edi
C. erp
D. script kiddies
Correct : A. firewall
40. Microsoft Word is an example of
A. an operating system
B. processing device
C. application software
D. an input device
Correct : C. application software
41. Which of the following is not a text editor
A. notepad
B. textpad
C. textmate
D. ms excel
Correct : D. ms excel
42. The key board shortcut for making fonts Italic is
A. ctrl + c
B. ctrl + i
C. ctrl + x
D. alt + b
Correct : B. ctrl + i
43. The short cut for centrally aligning a text is
A. ctrl+c
B. ctrl+l
C. ctrl+e
D. ctrl+r
Correct : C. ctrl+e
44. Replacing a word with another word throughout the document can be done using
A. cut and paste
B. find and replace
C. copy and paste
D. go
Correct : B. find and replace
45. Which among the following is not an option in editing group?
A. find
B. replace
C. select
D. illustrations
Correct : D. illustrations
46. Which of the key shortcut is used for printing a document in word ?
A. ctrl+p
B. ctrl+r
C. altl+p
D. alt+r
Correct : A. ctrl+p
47. The keyboard short cut for cut command is
A. ctrl+c
B. altl+c
C. ctrl+x
D. alt+v
Correct : C. ctrl+x
48. The key board shortcut for making fonts bold is
A. ctrl + c
B. ctrl + b
C. ctrl + x
D. alt + b
Correct : B. ctrl + b
49. Which of the following is not a type of page margin?
A. normal
B. narrow
C. moderate
D. middle
Correct : D. middle
50. Portrait and Landscape are
A. paper size
B. page layout
C. page orientation
D. none of the above
Correct : C. page orientation
51. Which of the following is not a font style?
A. bold
B. superscript
C. regular
D. italics
Correct : B. superscript
52. Which enables us to send the same letter to different persons?
A. macros
B. mail merge
C. template
D. none
Correct : B. mail merge
53. Which of the following is not an essential component to create mail merge?
A. main document
B. data source
C. merge fields
D. word fields
Correct : D. word fields
54. ________consists of most frequently used commands such as cut, copy, paste, print etc
A. quick access toolbar
B. title bar
C. status bar
D. rulers
Correct : A. quick access toolbar
55. Number of tabs in MS word
A. 8
B. 7
C. 10
D. 5
Correct : B. 7
56. Which of the following is not an option under font group?
A. underline
B. bold
C. shapes
D. change case
Correct : C. shapes
57. The word indicates the spelling errors with
A. blue underline
B. green underline
C. red underline
D. black underline
Correct : C. red underline
58. The word indicates the grammar mistakes with
A. blue underline
B. green underline
C. red underline
D. black underline
Correct : B. green underline
59. The keyboard short cut for Undo command is
A. alt+u
B. ctrl+y
C. ctrl+u
D. ctrl+z
Correct : D. ctrl+z
60. The keyboard short cut for Redo command is
A. ctrl+r
B. ctrl+y
C. ctrl+j
D. alt+r
Correct : B. ctrl+y
61. The keyboard short cut for Paste command is
A. ctrl+v
B. ctrl+p
C. ctrl+j
D. alt+p
Correct : A. ctrl+v
62. The keyboard short cut for justifying alignment is
A. ctrl+a
B. ctrl+y
C. ctrl+j
D. ctrl+n
Correct : C. ctrl+j
63. The keyboard short cut for creating a new document is
A. alt+n
B. ctrl+n
C. alt+d
D. ctrl+d
Correct : B. ctrl+n
64. _______is a collection of predefined design elements and colour schemes
A. feature
B. hyperlink
C. palette
D. theme
Correct : D. theme
65. Change the _____to create a document in wide format
A. page margins
B. paper style
C. page orientation
D. paper source
Correct : A. page margins
66. Which operation you will perform if you need to move a block of text.
A. copy and paste
B. paste and delete
C. cut and paste
D. title bar
Correct : C. cut and paste
67. To view header and footer you must switch to
A. normal view
B. print layout view
C. print preview mode
D. both b and c
Correct : D. both b and c
68. From where you can access save command.
A. home tab
B. insert tab
C. review tab
D. none of above
Correct : D. none of above
69. Essential business letter elements include the_________
A. date line and inside address
B. message
C. signature bloc
D. all of above
Correct : D. all of above
70. Which of the following helps to reduce spelling error in the document?
A. auto format
B. auto correct
C. smart tags
D. auto text.
Correct : B. auto correct
71. In Word 2007 the Zoom is placed on
A. view tab
B. home tab
C. status bar
D. both a & c
Correct : D. both a & c
72. A command under a group is known as _____
A. button
B. tab
C. ribbon
D. none of above
Correct : A. button
73. ________indicates writable area of the document
A. gridlines
B. rulers
C. thumbnails
D. document map
Correct : B. rulers
74. Which is not an option to insert equations?
A. equations
B. symbols
C. smartart
D. ms equation editor
Correct : C. smartart
75. What is the default file extension for all word documents?
A. .txts
B. . word
C. .docs
D. .docx
Correct : D. .docx
76. What is the smallest and largest font size tool on formatting toolbar?
A. 8 and 72
B. 8 and 64
C. 12 and 72
D. none of the above.
Correct : A. 8 and 72
77. The extension of database file in excel is
A. .doc
B. .xls
C. bmp
D. dbf
Correct : B. .xls
78. The menu for locating regression in MS Excel is
A. format
B. tools
C. insert
D. data analysis
Correct : D. data analysis
79. Which of the following formula in excel is used for exponential operation?
A. ^
B. +
C. *
D. /
Correct : A. ^
80. Analysis toolpak is an add-in function in
A. powerpoint
B. excel
C. word
D. access
Correct : B. excel
81. Which of the following is an electronic spreadsheet?
A. powerpoint
B. excel
C. word
D. access
Correct : B. excel
82. Solver is an add-in function in
A. powerpoint
B. word
C. excel
D. access
Correct : C. excel
83. Conditional sum wizard is an add-in function in
A. powerpoint
B. word
C. excel
D. access
Correct : C. excel
84. Which of the following is an operator for defining natural logarithm in excel worksheet
A. =ni().
B. =ln()
C. =^()
D. =log()
Correct : B. =ln()
85. Which of the following defines a formula in excel ?
A. &.
B. *
C. ^
D. =
Correct : D. =
86. Which among the following is a valid cell address in MS Excel?
A. a:20
B. b;15
C. d6
D. 10h
Correct : C. d6
87. Which among the following represents a union type cell reference in Excel?
A. (a10:a20)
B. (b10:b20)
C. (a10,a20)
D. a10
Correct : C. (a10,a20)
88. Which among the following represents a individual cell reference in Excel?
A. (c10:c20)
B. (d10,d20)
C. (a10,a20)
D. f10
Correct : D. f10
89. ________useful to display trend of an economic variable over a time period
A. line chart
B. bar chart
C. pie chart
D. scatter plot
Correct : A. line chart
90. AutoSum can be used to calculate
A. sum
B. average
C. maximum
D. all of the above
Correct : D. all of the above
91. Which of the following is not an element in formula syntax?
A. equal to sign
B. operator
C. chart
D. cell address
Correct : C. chart
92. Which of the following is forecasting tool?
A. moving average
B. variance
C. linear trend line
D. cubic trend line
Correct : B. variance
93. The function library is available under _______tab.
A. formula
B. insert
C. data
D. review
Correct : A. formula
94. __________ means the structure or order of the elements of a formula
A. operator
B. cell
C. formula syntax
D. operand
Correct : C. formula syntax
95. Which of the following methods cannot be used to enter data in a cell?
A. pressing an arrow key
B. pressing an tab key
C. pressing escape key
D. clicking on the formula bar
Correct : C. pressing escape key
96. You can activate a cell by
A. pressing tab key
B. clicking the cell
C. pressing an arrow key
D. all of above
Correct : D. all of above
97. Which of the following is not a basic step in creating a worksheet?
A. save workbook
B. modify the worksheet
C. enter text and the data
D. copy the worksheet
Correct : D. copy the worksheet
98. How many worksheets a workbook normally consist of?
A. 3
B. 2
C. 1
D. 4
Correct : A. 3
99. Which area in an excel allows entering values and formulas
A. title bar
B. menu bar
C. formula bar
D. standard toolbar
Correct : C. formula bar
100. ________cell address remains constant, no matter where they are copied
A. individual
B. union
C. range
D. absolute.
Correct : A. individual