Microsoft Access - 100 MCQs with Answers
1. Which of the following is the default file extension for SPSS data files?
A) .sav
B) .sps
C) .spo
D) .spv
Answer: A) .sav
2. In SPSS, which menu is used to compute new variables?
A) Analyze
B) Transform
C) Data
D) File
Answer: B) Transform
3. Which of the following is used to perform descriptive statistics in SPSS?
A) Graphs > Legacy Dialogs
B) Analyze > Descriptive Statistics
C) File > Open
D) Transform > Compute
Answer: B) Analyze > Descriptive Statistics
4. What is the purpose of the Variable View in SPSS?
A) To view data
B) To define variables
C) To generate charts
D) To input syntax
Answer: B) To define variables
5. Which of the following is not a type of variable measurement level in SPSS?
A) Nominal
Page 1
Microsoft Access - 100 MCQs with Answers
B) Ordinal
C) Interval
D) Hierarchical
Answer: D) Hierarchical
6. Which command is used to input syntax in SPSS?
A) File > New > Data
B) Edit > Options
C) File > New > Syntax
D) Analyze > Regression
Answer: C) File > New > Syntax
7. What does the 'Split File' function in SPSS allow you to do?
A) Create multiple datasets
B) Divide data for group analysis
C) Generate syntax
D) Import Excel files
Answer: B) Divide data for group analysis
8. Which chart type is best for visualizing the distribution of a continuous variable?
A) Pie Chart
B) Bar Chart
C) Histogram
D) Line Chart
Answer: C) Histogram
9. In SPSS, how do you define missing values?
A) In Data View
B) In Variable View under 'Missing'
C) In Syntax only
D) It is not possible
Page 2
Microsoft Access - 100 MCQs with Answers
Answer: B) In Variable View under 'Missing'
10. Which procedure is used to determine the relationship between two categorical variables?
A) T-test
B) ANOVA
C) Crosstabs
D) Regression
Answer: C) Crosstabs
11. What does SPSS stand for?
A) Statistical Package for the Social Sciences
B) Standard Programming Software System
C) Software Package for Scientific Studies
D) Statistical Processing and Storage Software
Answer: A) Statistical Package for the Social Sciences
12. Which of the following is used to test the mean difference between two groups?
A) ANOVA
B) T-test
C) Regression
D) Correlation
Answer: B) T-test
13. Which file contains the output of the analysis in SPSS?
A) .sav
B) .sps
C) .spv
D) .spo
Answer: C) .spv
Page 3
Microsoft Access - 100 MCQs with Answers
14. In SPSS, which of the following menus allows you to sort data?
A) File
B) Analyze
C) Data
D) Graphs
Answer: C) Data
15. What type of graph would you use to display frequency data for a categorical variable?
A) Line graph
B) Histogram
C) Pie chart
D) Scatterplot
Answer: C) Pie chart
16. Which of the following is NOT a valid variable type in SPSS?
A) Numeric
B) String
C) Comma
D) Boolean
Answer: D) Boolean
17. In SPSS, to recode values into different variables, you use:
A) Analyze > Regression
B) Data > Select Cases
C) Transform > Recode into Different Variables
D) File > Import
Answer: C) Transform > Recode into Different Variables
18. Which SPSS function helps to identify the number of valid and missing cases?
A) Descriptive Statistics
Page 4
Microsoft Access - 100 MCQs with Answers
B) Frequencies
C) Explore
D) All of the above
Answer: D) All of the above
19. In Variable View, the 'Measure' column lets you specify:
A) Format
B) Width
C) Variable type
D) Level of measurement
Answer: D) Level of measurement
20. The output window in SPSS is used for:
A) Entering data
B) Viewing charts and statistical results
C) Defining variables
D) Editing syntax
Answer: B) Viewing charts and statistical results
21. Which of the following is the default file extension for SPSS data files? (Q21)
A) .sav
B) .sps
C) .spo
D) .spv
Answer: A) .sav
22. In SPSS, which menu is used to compute new variables? (Q22)
A) Analyze
B) Transform
C) Data
D) File
Page 5
Microsoft Access - 100 MCQs with Answers
Answer: B) Transform
23. Which of the following is used to perform descriptive statistics in SPSS? (Q23)
A) Graphs > Legacy Dialogs
B) Analyze > Descriptive Statistics
C) File > Open
D) Transform > Compute
Answer: B) Analyze > Descriptive Statistics
24. What is the purpose of the Variable View in SPSS? (Q24)
A) To view data
B) To define variables
C) To generate charts
D) To input syntax
Answer: B) To define variables
25. Which of the following is not a type of variable measurement level in SPSS? (Q25)
A) Nominal
B) Ordinal
C) Interval
D) Hierarchical
Answer: D) Hierarchical
26. Which command is used to input syntax in SPSS? (Q26)
A) File > New > Data
B) Edit > Options
C) File > New > Syntax
D) Analyze > Regression
Answer: C) File > New > Syntax
Page 6
Microsoft Access - 100 MCQs with Answers
27. What does the 'Split File' function in SPSS allow you to do? (Q27)
A) Create multiple datasets
B) Divide data for group analysis
C) Generate syntax
D) Import Excel files
Answer: B) Divide data for group analysis
28. Which chart type is best for visualizing the distribution of a continuous variable? (Q28)
A) Pie Chart
B) Bar Chart
C) Histogram
D) Line Chart
Answer: C) Histogram
29. In SPSS, how do you define missing values? (Q29)
A) In Data View
B) In Variable View under 'Missing'
C) In Syntax only
D) It is not possible
Answer: B) In Variable View under 'Missing'
30. Which procedure is used to determine the relationship between two categorical variables? (Q30)
A) T-test
B) ANOVA
C) Crosstabs
D) Regression
Answer: C) Crosstabs
31. What does SPSS stand for? (Q31)
A) Statistical Package for the Social Sciences
Page 7
Microsoft Access - 100 MCQs with Answers
B) Standard Programming Software System
C) Software Package for Scientific Studies
D) Statistical Processing and Storage Software
Answer: A) Statistical Package for the Social Sciences
32. Which of the following is used to test the mean difference between two groups? (Q32)
A) ANOVA
B) T-test
C) Regression
D) Correlation
Answer: B) T-test
33. Which file contains the output of the analysis in SPSS? (Q33)
A) .sav
B) .sps
C) .spv
D) .spo
Answer: C) .spv
34. In SPSS, which of the following menus allows you to sort data? (Q34)
A) File
B) Analyze
C) Data
D) Graphs
Answer: C) Data
35. What type of graph would you use to display frequency data for a categorical variable? (Q35)
A) Line graph
B) Histogram
C) Pie chart
D) Scatterplot
Page 8
Microsoft Access - 100 MCQs with Answers
Answer: C) Pie chart
36. Which of the following is NOT a valid variable type in SPSS? (Q36)
A) Numeric
B) String
C) Comma
D) Boolean
Answer: D) Boolean
37. In SPSS, to recode values into different variables, you use: (Q37)
A) Analyze > Regression
B) Data > Select Cases
C) Transform > Recode into Different Variables
D) File > Import
Answer: C) Transform > Recode into Different Variables
38. Which SPSS function helps to identify the number of valid and missing cases? (Q38)
A) Descriptive Statistics
B) Frequencies
C) Explore
D) All of the above
Answer: D) All of the above
39. In Variable View, the 'Measure' column lets you specify: (Q39)
A) Format
B) Width
C) Variable type
D) Level of measurement
Answer: D) Level of measurement
Page 9
Microsoft Access - 100 MCQs with Answers
40. The output window in SPSS is used for: (Q40)
A) Entering data
B) Viewing charts and statistical results
C) Defining variables
D) Editing syntax
Answer: B) Viewing charts and statistical results
41. Which of the following is the default file extension for SPSS data files? (Q41)
A) .sav
B) .sps
C) .spo
D) .spv
Answer: A) .sav
42. In SPSS, which menu is used to compute new variables? (Q42)
A) Analyze
B) Transform
C) Data
D) File
Answer: B) Transform
43. Which of the following is used to perform descriptive statistics in SPSS? (Q43)
A) Graphs > Legacy Dialogs
B) Analyze > Descriptive Statistics
C) File > Open
D) Transform > Compute
Answer: B) Analyze > Descriptive Statistics
44. What is the purpose of the Variable View in SPSS? (Q44)
A) To view data
Page 10
Microsoft Access - 100 MCQs with Answers
B) To define variables
C) To generate charts
D) To input syntax
Answer: B) To define variables
45. Which of the following is not a type of variable measurement level in SPSS? (Q45)
A) Nominal
B) Ordinal
C) Interval
D) Hierarchical
Answer: D) Hierarchical
46. Which command is used to input syntax in SPSS? (Q46)
A) File > New > Data
B) Edit > Options
C) File > New > Syntax
D) Analyze > Regression
Answer: C) File > New > Syntax
47. What does the 'Split File' function in SPSS allow you to do? (Q47)
A) Create multiple datasets
B) Divide data for group analysis
C) Generate syntax
D) Import Excel files
Answer: B) Divide data for group analysis
48. Which chart type is best for visualizing the distribution of a continuous variable? (Q48)
A) Pie Chart
B) Bar Chart
C) Histogram
D) Line Chart
Page 11
Microsoft Access - 100 MCQs with Answers
Answer: C) Histogram
49. In SPSS, how do you define missing values? (Q49)
A) In Data View
B) In Variable View under 'Missing'
C) In Syntax only
D) It is not possible
Answer: B) In Variable View under 'Missing'
50. Which procedure is used to determine the relationship between two categorical variables? (Q50)
A) T-test
B) ANOVA
C) Crosstabs
D) Regression
Answer: C) Crosstabs
51. What does SPSS stand for? (Q51)
A) Statistical Package for the Social Sciences
B) Standard Programming Software System
C) Software Package for Scientific Studies
D) Statistical Processing and Storage Software
Answer: A) Statistical Package for the Social Sciences
52. Which of the following is used to test the mean difference between two groups? (Q52)
A) ANOVA
B) T-test
C) Regression
D) Correlation
Answer: B) T-test
Page 12
Microsoft Access - 100 MCQs with Answers
53. Which file contains the output of the analysis in SPSS? (Q53)
A) .sav
B) .sps
C) .spv
D) .spo
Answer: C) .spv
54. In SPSS, which of the following menus allows you to sort data? (Q54)
A) File
B) Analyze
C) Data
D) Graphs
Answer: C) Data
55. What type of graph would you use to display frequency data for a categorical variable? (Q55)
A) Line graph
B) Histogram
C) Pie chart
D) Scatterplot
Answer: C) Pie chart
56. Which of the following is NOT a valid variable type in SPSS? (Q56)
A) Numeric
B) String
C) Comma
D) Boolean
Answer: D) Boolean
57. In SPSS, to recode values into different variables, you use: (Q57)
A) Analyze > Regression
Page 13
Microsoft Access - 100 MCQs with Answers
B) Data > Select Cases
C) Transform > Recode into Different Variables
D) File > Import
Answer: C) Transform > Recode into Different Variables
58. Which SPSS function helps to identify the number of valid and missing cases? (Q58)
A) Descriptive Statistics
B) Frequencies
C) Explore
D) All of the above
Answer: D) All of the above
59. In Variable View, the 'Measure' column lets you specify: (Q59)
A) Format
B) Width
C) Variable type
D) Level of measurement
Answer: D) Level of measurement
60. The output window in SPSS is used for: (Q60)
A) Entering data
B) Viewing charts and statistical results
C) Defining variables
D) Editing syntax
Answer: B) Viewing charts and statistical results
61. Which of the following is the default file extension for SPSS data files? (Q61)
A) .sav
B) .sps
C) .spo
D) .spv
Page 14
Microsoft Access - 100 MCQs with Answers
Answer: A) .sav
62. In SPSS, which menu is used to compute new variables? (Q62)
A) Analyze
B) Transform
C) Data
D) File
Answer: B) Transform
63. Which of the following is used to perform descriptive statistics in SPSS? (Q63)
A) Graphs > Legacy Dialogs
B) Analyze > Descriptive Statistics
C) File > Open
D) Transform > Compute
Answer: B) Analyze > Descriptive Statistics
64. What is the purpose of the Variable View in SPSS? (Q64)
A) To view data
B) To define variables
C) To generate charts
D) To input syntax
Answer: B) To define variables
65. Which of the following is not a type of variable measurement level in SPSS? (Q65)
A) Nominal
B) Ordinal
C) Interval
D) Hierarchical
Answer: D) Hierarchical
Page 15
Microsoft Access - 100 MCQs with Answers
66. Which command is used to input syntax in SPSS? (Q66)
A) File > New > Data
B) Edit > Options
C) File > New > Syntax
D) Analyze > Regression
Answer: C) File > New > Syntax
67. What does the 'Split File' function in SPSS allow you to do? (Q67)
A) Create multiple datasets
B) Divide data for group analysis
C) Generate syntax
D) Import Excel files
Answer: B) Divide data for group analysis
68. Which chart type is best for visualizing the distribution of a continuous variable? (Q68)
A) Pie Chart
B) Bar Chart
C) Histogram
D) Line Chart
Answer: C) Histogram
69. In SPSS, how do you define missing values? (Q69)
A) In Data View
B) In Variable View under 'Missing'
C) In Syntax only
D) It is not possible
Answer: B) In Variable View under 'Missing'
70. Which procedure is used to determine the relationship between two categorical variables? (Q70)
A) T-test
Page 16
Microsoft Access - 100 MCQs with Answers
B) ANOVA
C) Crosstabs
D) Regression
Answer: C) Crosstabs
71. What does SPSS stand for? (Q71)
A) Statistical Package for the Social Sciences
B) Standard Programming Software System
C) Software Package for Scientific Studies
D) Statistical Processing and Storage Software
Answer: A) Statistical Package for the Social Sciences
72. Which of the following is used to test the mean difference between two groups? (Q72)
A) ANOVA
B) T-test
C) Regression
D) Correlation
Answer: B) T-test
73. Which file contains the output of the analysis in SPSS? (Q73)
A) .sav
B) .sps
C) .spv
D) .spo
Answer: C) .spv
74. In SPSS, which of the following menus allows you to sort data? (Q74)
A) File
B) Analyze
C) Data
D) Graphs
Page 17
Microsoft Access - 100 MCQs with Answers
Answer: C) Data
75. What type of graph would you use to display frequency data for a categorical variable? (Q75)
A) Line graph
B) Histogram
C) Pie chart
D) Scatterplot
Answer: C) Pie chart
76. Which of the following is NOT a valid variable type in SPSS? (Q76)
A) Numeric
B) String
C) Comma
D) Boolean
Answer: D) Boolean
77. In SPSS, to recode values into different variables, you use: (Q77)
A) Analyze > Regression
B) Data > Select Cases
C) Transform > Recode into Different Variables
D) File > Import
Answer: C) Transform > Recode into Different Variables
78. Which SPSS function helps to identify the number of valid and missing cases? (Q78)
A) Descriptive Statistics
B) Frequencies
C) Explore
D) All of the above
Answer: D) All of the above
Page 18
Microsoft Access - 100 MCQs with Answers
79. In Variable View, the 'Measure' column lets you specify: (Q79)
A) Format
B) Width
C) Variable type
D) Level of measurement
Answer: D) Level of measurement
80. The output window in SPSS is used for: (Q80)
A) Entering data
B) Viewing charts and statistical results
C) Defining variables
D) Editing syntax
Answer: B) Viewing charts and statistical results
81. Which of the following is the default file extension for SPSS data files? (Q81)
A) .sav
B) .sps
C) .spo
D) .spv
Answer: A) .sav
82. In SPSS, which menu is used to compute new variables? (Q82)
A) Analyze
B) Transform
C) Data
D) File
Answer: B) Transform
83. Which of the following is used to perform descriptive statistics in SPSS? (Q83)
A) Graphs > Legacy Dialogs
Page 19
Microsoft Access - 100 MCQs with Answers
B) Analyze > Descriptive Statistics
C) File > Open
D) Transform > Compute
Answer: B) Analyze > Descriptive Statistics
84. What is the purpose of the Variable View in SPSS? (Q84)
A) To view data
B) To define variables
C) To generate charts
D) To input syntax
Answer: B) To define variables
85. Which of the following is not a type of variable measurement level in SPSS? (Q85)
A) Nominal
B) Ordinal
C) Interval
D) Hierarchical
Answer: D) Hierarchical
86. Which command is used to input syntax in SPSS? (Q86)
A) File > New > Data
B) Edit > Options
C) File > New > Syntax
D) Analyze > Regression
Answer: C) File > New > Syntax
87. What does the 'Split File' function in SPSS allow you to do? (Q87)
A) Create multiple datasets
B) Divide data for group analysis
C) Generate syntax
D) Import Excel files
Page 20
Microsoft Access - 100 MCQs with Answers
Answer: B) Divide data for group analysis
88. Which chart type is best for visualizing the distribution of a continuous variable? (Q88)
A) Pie Chart
B) Bar Chart
C) Histogram
D) Line Chart
Answer: C) Histogram
89. In SPSS, how do you define missing values? (Q89)
A) In Data View
B) In Variable View under 'Missing'
C) In Syntax only
D) It is not possible
Answer: B) In Variable View under 'Missing'
90. Which procedure is used to determine the relationship between two categorical variables? (Q90)
A) T-test
B) ANOVA
C) Crosstabs
D) Regression
Answer: C) Crosstabs
91. What does SPSS stand for? (Q91)
A) Statistical Package for the Social Sciences
B) Standard Programming Software System
C) Software Package for Scientific Studies
D) Statistical Processing and Storage Software
Answer: A) Statistical Package for the Social Sciences
Page 21
Microsoft Access - 100 MCQs with Answers
92. Which of the following is used to test the mean difference between two groups? (Q92)
A) ANOVA
B) T-test
C) Regression
D) Correlation
Answer: B) T-test
93. Which file contains the output of the analysis in SPSS? (Q93)
A) .sav
B) .sps
C) .spv
D) .spo
Answer: C) .spv
94. In SPSS, which of the following menus allows you to sort data? (Q94)
A) File
B) Analyze
C) Data
D) Graphs
Answer: C) Data
95. What type of graph would you use to display frequency data for a categorical variable? (Q95)
A) Line graph
B) Histogram
C) Pie chart
D) Scatterplot
Answer: C) Pie chart
96. Which of the following is NOT a valid variable type in SPSS? (Q96)
A) Numeric
Page 22
Microsoft Access - 100 MCQs with Answers
B) String
C) Comma
D) Boolean
Answer: D) Boolean
97. In SPSS, to recode values into different variables, you use: (Q97)
A) Analyze > Regression
B) Data > Select Cases
C) Transform > Recode into Different Variables
D) File > Import
Answer: C) Transform > Recode into Different Variables
98. Which SPSS function helps to identify the number of valid and missing cases? (Q98)
A) Descriptive Statistics
B) Frequencies
C) Explore
D) All of the above
Answer: D) All of the above
99. In Variable View, the 'Measure' column lets you specify: (Q99)
A) Format
B) Width
C) Variable type
D) Level of measurement
Answer: D) Level of measurement
100. The output window in SPSS is used for: (Q100)
A) Entering data
B) Viewing charts and statistical results
C) Defining variables
D) Editing syntax
Page 23
Microsoft Access - 100 MCQs with Answers
Answer: B) Viewing charts and statistical results
Page 24
