Quiznetik
Computer Applications for Economic Analysis | Set 2
1. An excel workbook is a collection of
A. workbooks
B. worksheets
C. charts
D. none of above
Correct : B. worksheets
2. Excel Probably considers the cell entry January 1, 2000 to be a
A. label
B. value
C. formula
D. text string
Correct : B. value
3. You can enter which type of data into worksheet cells?
A. labels, values, and formulas
B. labels and values but not formulas
C. values and formulas but not labels
D. formulas only.
Correct : A. labels, values, and formulas
4. If you want to show the sector wise contribution to GDP, which chart you will prefer
A. pie chart
B. line chart
C. column chart
D. area chart
Correct : A. pie chart
5. The operator to estimate variance is
A. =covar ()
B. =var ()
C. =stdev ()
D. =kurt ()
Correct : B. =var ()
6. The operator to estimate mean is
A. =covar ()
B. = mode ()
C. =average ()
D. =median ()
Correct : C. =average ()
7. The operator to estimate standard deviation is
A. =covar ()
B. =var ()
C. = stdev ()
D. =median ()
Correct : C. = stdev ()
8. In Excel spread sheet, the currently active cell is indicated by
A. cell pointer
B. formula bar
C. toolbar
D. none of above
Correct : A. cell pointer
9. While estimating descriptive statistic using analysis toolpak, we need to check
A. summary statistics
B. correlation
C. anova
D. covariance
Correct : A. summary statistics
10. Quadratic trend line is polynomial of order ___
A. 1
B. 2
C. 3
D. 4
Correct : B. 2
11. Cubic trend line is polynomial of order ___
A. 1
B. 2
C. 3
D. 4
Correct : C. 3
12. Which among the following is used as model selection criteria for trend lines?
A. correlation coefficient
B. constant
C. slope
D. r2
Correct : D. r2
13. Which among the following is not a descriptive statistics?
A. mean
B. regression
C. median
D. variance
Correct : B. regression
14. Which trend line you will choose if line plot is roughly a straight line?
A. linear
B. exponential
C. cubic
D. quadratic
Correct : A. linear
15. Which tab provides the option to set chart and axis titles?
A. insert
B. layout
C. view
D. design
Correct : B. layout
16. Which tab provides various styles of inserted chart?
A. insert
B. layout
C. view
D. design
Correct : D. design
17. Which of the following formula is not entered correctly?
A. =10+5
B. =5*9
C. 2+4
D. =10/2
Correct : C. 2+4
18. ________is used to study the relationship between variables.
A. pie chart
B. line chart
C. column chart
D. scatter plot
Correct : D. scatter plot
19. In line chart years are shown on
A. vertical axis
B. horizontal axis
C. title
D. none of the above
Correct : B. horizontal axis
20. _______ refers to displaying only the rows that meet certain conditions and the remaining rows are hidden
A. filtering
B. sorting
C. numbering
D. formatting
Correct : A. filtering
21. ______is used to display values in ascending or descending order.
A. filtering
B. sorting
C. numbering
D. formatting
Correct : B. sorting
22. Formulas built-in into a spreadsheet are called _______
A. formulas
B. conditions
C. functions
D. labels
Correct : C. functions
23. The intersection of a raw and column is known as _____
A. cell
B. chart
C. formula
D. value
Correct : A. cell
24. Which of the following is a programme used to create presentations?
A. word
B. excel
C. powerpoint
D. access
Correct : C. powerpoint
25. ______ helps to preview the slides in thumbnail form?
A. title bar
B. status bar
C. menu bar
D. slide sorter view
Correct : D. slide sorter view
26. _________ are already created presentation on different topics.
A. templates
B. images
C. video
D. design
Correct : A. templates
27. The Background style of a power point presentation is known as
A. animation
B. theme
C. transition
D. effects
Correct : B. theme
28. The title slide consists of
A. title place holder
B. subtitle place holder
C. both title and subtitle place holders
D. none o the above
Correct : C. both title and subtitle place holders
29. Which of the following is not an option to format the theme of the presentation?
A. colours
B. fonts
C. effects
D. table
Correct : D. table
30. Which of the following is not an option of transition?
A. wipes
B. push and cover
C. random
D. oriel
Correct : D. oriel
31. Which key on the keyboard can be used to view the slide show?
A. f1
B. f2
C. f5
D. f10
Correct : C. f5
32. Which tab is not available on left panel when you open a presentation?
A. outline
B. slides
C. notes
D. all of above
Correct : C. notes
33. The arrangement of elements such as title and subtitle text, pictures, tables etc. is called
A. layout
B. presentation
C. design
D. scheme
Correct : A. layout
34. After choosing a predefined template, which option has to be chosen to change the background colour?
A. design template
B. colour scheme
C. animation scheme
D. colour effects
Correct : D. colour effects
35. Fly in is predefined _____________
A. design template
B. colour scheme
C. animation scheme
D. none of these
Correct : B. colour scheme
36. Animation schemes can be applied to ___________in the presentation
A. all slides
B. selected slides
C. current slide
D. all of the above
Correct : C. current slide
37. To insert new slide in the presentation, we can choose
A. ctrl+m
B. ctrl+n
C. ctrl+o
D. ctrl+f
Correct : D. ctrl+f
38. In normal view, this tab displays the content of each slide
A. slides
B. view
C. sort
D. outline
Correct : B. view
39. Which is the menu to create text box on a slide
A. view->text box
B. tools->text box
C. insert->text box
D. format->text box
Correct : D. format->text box
40. A new presentation can be created from
A. blank presentation
B. from existing presentation
C. from design template
D. all of above
Correct : C. from design template
41. What PowerPoint feature will you use to apply motion effects to different objects of a slide
A. slide transition
B. slide design
C. animation objects
D. text box
Correct : D. text box
42. What PowerPoint feature will you use to apply motion effects in between slide exits and another enters?
A. slide transition
B. slide design
C. animation objects
D. text box
Correct : C. animation objects
43. The selected design template can be applied to
A. to the current slide only
B. to all the slides
C. to all the new presentations you create
D. all of the above
Correct : A. to the current slide only
44. From which menu you can access picture, chart, smart card and movie
A. home
B. insert
C. design
D. view
Correct : B. insert
45. To insert a hyperlink in a slide
A. insert>>hyperlink
B. ctrl+k
C. view>>hyperlink
D. both a & b
Correct : D. both a & b
46. Which of the following font effect is not available PowerPoint font dialog box?
A. underline
B. shadow
C. emboss
D. strikethrough
Correct : C. emboss
47. The default Page set up orientation of slide in PowerPoint is
A. vertical
B. landscape
C. portrait
D. none of above
Correct : B. landscape
48. Objects on the slide that hold text are called
A. placeholders
B. object holders
C. auto layouts
D. text holders
Correct : A. placeholders
49. Which command brings you to the first slide in your presentation?
A. next slide button
B. page up
C. ctrl+home
D. ctrl+end
Correct : C. ctrl+home
50. Which of the following can you use to add times to the slides in a presentation?
A. slide show menu
B. rehearse timings button
C. slide transition button
D. all of the above
Correct : B. rehearse timings button
51. Which of the following presentation elements can you modify using the slide master?
A. slide comments
B. slide transition
C. speaker note font and colour
D. all of above
Correct : B. slide transition
52. What is internet?
A. a single network
B. a vast collection of different networks
C. interconnection of local area networks
D. none of the mentioned
Correct : B. a vast collection of different networks
53. To join the internet, the computer has to be connected to a
A. internet architecture board
B. internet society
C. internet service provider
D. none of the mentioned
Correct : C. internet service provider
54. Internet access by transmitting digital data over the wires of a local telephone network is provided by
A. leased line
B. digital subscriber line
C. digital signal line
D. none of the mentioned
Correct : B. digital subscriber line
55. Which one of the following protocol is not used in internet?
A. http
B. dhcp
C. dns
D. none of the mentioned
Correct : D. none of the mentioned
56. Which of the following describes e‐commerce?
A. doing business electronically
B. doing business
C. sale of goods
D. all of the above
Correct : D. all of the above
57. Which protocol assigns IP address to the client connected in the internet?
A. dhcp
B. ip
C. rpc
D. none of the mentioned
Correct : A. dhcp
58. Bluetooth is an example of
A. personal area network
B. local area network
C. virtual private network
D. none of the mentioned
Correct : A. personal area network
59. Which products are people most likely to be more uncomfortable buying on the Internet?
A. books
B. furniture
C. movies
D. all of the above
Correct : A. books
60. What are plastic cards the size of a credit card that contains an embedded chip on which digital information can be stored?
A. customer relationship management systems cards
B. e‐government identity cards
C. fedi cards
D. smart cards
Correct : D. smart cards
61. Which of the following are advantages normally associated with e‐commerce?
A. shorter cycle times
B. reduction in costs
C. reaches wider audiences
D. all of the above
Correct : D. all of the above
62. Which of the following statements accurately reflect the impact of technology?
A. technology has caused buyer power to increase
B. technology has lessened the entry barriers for many industries
C. technology has increased the threat of substitute products and services
D. all of the above
Correct : D. all of the above
63. How the transactions occur in e‐commerce?
A. using e‐medias
B. using computers only
C. using mobile phones only
D. none of the above
Correct : D. none of the above
64. If you need to transfer money to another person via the internet, which of the following methods could you use?
A. financial cybermediary
B. electronic check
C. electronic bill presentment and payment
D. all of the above
Correct : D. all of the above
65. E-business is a term used to describe
A. any electronically mediated communication between an organization and its stakeholders
B. the use of electronic communications for all business processes
C. an organization using electronic media to purchase from to its suppliers
D. an organization using electronic media to sell direct to its customers
Correct : A. any electronically mediated communication between an organization and its stakeholders
66. While there are obvious e-business advantages and opportunities, there are also risks and barriers. These include
A. contravention of customer privacy
B. internet hackers penetrating company security
C. spikes causing websites to fail at peak times
D. all of the above
Correct : A. contravention of customer privacy
67. Which of the following is not a method of accessing the web?
A. isdn
B. cpu
C. dsl
D. modem
Correct : B. cpu
68. TCP stands for _______
A. transport control protocol
B. transmission control protocol
C. terminal control protocol
D. none of the given
Correct : B. transmission control protocol
69. CRM stands for...............
A. customer relationship management
B. customer related management
C. customer resembling management
D. customer reallocation management
Correct : B. customer related management
70. IP stands for _______
A. internal protocol
B. interest protocol
C. internet protocol
D. none of the given
Correct : C. internet protocol
71. A network, which is used for sharing data, software and hardware among several users of microcomputers, is called
A. wide area network.
B. metropolitan area network.
C. local area network
D. value added network.
Correct : C. local area network