Quiznetik

Computer Applications for Economic Analysis | Set 2

1. An excel workbook is a collection of

Correct : B. worksheets

2. Excel Probably considers the cell entry January 1, 2000 to be a

Correct : B. value

3. You can enter which type of data into worksheet cells?

Correct : A. labels, values, and formulas

4. If you want to show the sector wise contribution to GDP, which chart you will prefer

Correct : A. pie chart

5. The operator to estimate variance is

Correct : B. =var ()

6. The operator to estimate mean is

Correct : C. =average ()

7. The operator to estimate standard deviation is

Correct : C. = stdev ()

8. In Excel spread sheet, the currently active cell is indicated by

Correct : A. cell pointer

9. While estimating descriptive statistic using analysis toolpak, we need to check

Correct : A. summary statistics

10. Quadratic trend line is polynomial of order ___

Correct : B. 2

11. Cubic trend line is polynomial of order ___

Correct : C. 3

12. Which among the following is used as model selection criteria for trend lines?

Correct : D. r2

13. Which among the following is not a descriptive statistics?

Correct : B. regression

14. Which trend line you will choose if line plot is roughly a straight line?

Correct : A. linear

15. Which tab provides the option to set chart and axis titles?

Correct : B. layout

16. Which tab provides various styles of inserted chart?

Correct : D. design

17. Which of the following formula is not entered correctly?

Correct : C. 2+4

18. ________is used to study the relationship between variables.

Correct : D. scatter plot

19. In line chart years are shown on

Correct : B. horizontal axis

20. _______ refers to displaying only the rows that meet certain conditions and the remaining rows are hidden

Correct : A. filtering

21. ______is used to display values in ascending or descending order.

Correct : B. sorting

22. Formulas built-in into a spreadsheet are called _______

Correct : C. functions

23. The intersection of a raw and column is known as _____

Correct : A. cell

24. Which of the following is a programme used to create presentations?

Correct : C. powerpoint

25. ______ helps to preview the slides in thumbnail form?

Correct : D. slide sorter view

26. _________ are already created presentation on different topics.

Correct : A. templates

27. The Background style of a power point presentation is known as

Correct : B. theme

28. The title slide consists of

Correct : C. both title and subtitle place holders

29. Which of the following is not an option to format the theme of the presentation?

Correct : D. table

30. Which of the following is not an option of transition?

Correct : D. oriel

31. Which key on the keyboard can be used to view the slide show?

Correct : C. f5

32. Which tab is not available on left panel when you open a presentation?

Correct : C. notes

33. The arrangement of elements such as title and subtitle text, pictures, tables etc. is called

Correct : A. layout

34. After choosing a predefined template, which option has to be chosen to change the background colour?

Correct : D. colour effects

35. Fly in is predefined _____________

Correct : B. colour scheme

36. Animation schemes can be applied to ___________in the presentation

Correct : C. current slide

37. To insert new slide in the presentation, we can choose

Correct : D. ctrl+f

38. In normal view, this tab displays the content of each slide

Correct : B. view

39. Which is the menu to create text box on a slide

Correct : D. format->text box

40. A new presentation can be created from

Correct : C. from design template

41. What PowerPoint feature will you use to apply motion effects to different objects of a slide

Correct : D. text box

42. What PowerPoint feature will you use to apply motion effects in between slide exits and another enters?

Correct : C. animation objects

43. The selected design template can be applied to

Correct : A. to the current slide only

44. From which menu you can access picture, chart, smart card and movie

Correct : B. insert

45. To insert a hyperlink in a slide

Correct : D. both a & b

46. Which of the following font effect is not available PowerPoint font dialog box?

Correct : C. emboss

47. The default Page set up orientation of slide in PowerPoint is

Correct : B. landscape

48. Objects on the slide that hold text are called

Correct : A. placeholders

49. Which command brings you to the first slide in your presentation?

Correct : C. ctrl+home

50. Which of the following can you use to add times to the slides in a presentation?

Correct : B. rehearse timings button

51. Which of the following presentation elements can you modify using the slide master?

Correct : B. slide transition

52. What is internet?

Correct : B. a vast collection of different networks

53. To join the internet, the computer has to be connected to a

Correct : C. internet service provider

54. Internet access by transmitting digital data over the wires of a local telephone network is provided by

Correct : B. digital subscriber line

55. Which one of the following protocol is not used in internet?

Correct : D. none of the mentioned

56. Which of the following describes e‐commerce?

Correct : D. all of the above

57. Which protocol assigns IP address to the client connected in the internet?

Correct : A. dhcp

58. Bluetooth is an example of

Correct : A. personal area network

59. Which products are people most likely to be more uncomfortable buying on the Internet?

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?

Correct : D. smart cards

61. Which of the following are advantages normally associated with e‐commerce?

Correct : D. all of the above

62. Which of the following statements accurately reflect the impact of technology?

Correct : D. all of the above

63. How the transactions occur in e‐commerce?

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?

Correct : D. all of the above

65. E-business is a term used to describe

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

Correct : A. contravention of customer privacy

67. Which of the following is not a method of accessing the web?

Correct : B. cpu

68. TCP stands for _______

Correct : B. transmission control protocol

69. CRM stands for...............

Correct : B. customer related management

70. IP stands for _______

Correct : C. internet protocol

71. A network, which is used for sharing data, software and hardware among several users of microcomputers, is called

Correct : C. local area network