Q.No.

Question Option A Option B Option C Option D Answer

1 1. What is the symbol for multiplication in Excel? / * x ^ *
2 2. How do you apply bold formatting to text? Ctrl + B Ctrl + U Ctrl + I Ctrl + F Ctrl + B
3 3. What does Paste Special > Values do? Pastes formulas Pastes values only Pastes formatting Pastes comments Pastes values only
4 4. Conditional Formatting can be found in which tab? File Home Data Review Home
5 5. Which chart is best for showing proportions? Bar Chart Line Chart Pie Chart Scatter Chart Pie Chart
6 6. What is the correct syntax for the IF function? IF(logical_test, IF(value_if_true, IF(logical_test, IF(value_if_false, IF(logical_test,
value_if_true, logical_test, value_if_false, logical_test, value_if_true,
value_if_false) value_if_false) value_if_true) value_if_true) value_if_false)
7 7. How does IF-AND work? Returns true if all Returns true if any Returns true if all Returns true if at Returns true if all
conditions are true condition is true conditions are false least one condition is conditions are true
false
8 8. Which function returns true if at least one condition is AND OR IF NOT OR
true?
9 9. Nested IF functions are used for: Adding conditions Applying multiple Formatting cells Filtering data Applying multiple
conditions in a single conditions in a single
formula formula
10 10. How do you sort data in ascending order? Use Sort in the Home Use Sort in the Data Apply Conditional Use Text to Columns Use Sort in the Data
tab tab Formatting tab
11 11. What does a filter do? Rearranges data Displays specific rows Deletes unwanted Adds conditional Displays specific rows
based on criteria rows formatting based on criteria

12 12. Data Validation is used to: Highlight duplicates Restrict data entry Sort data Remove blanks Restrict data entry

13 13. Which function combines text strings in Excel? CONCATENATE JOIN MERGE SPLIT CONCATENATE
14 14. What does Text to Columns do? Combines data into Splits data into Removes duplicates Highlights errors Splits data into
one column multiple columns multiple columns
15 15. Which tab contains the Remove Duplicates tool? Home Data Insert View Data
16 16. How does SUMIF work? Adds all numbers Adds numbers that Counts non-empty Returns an average Adds numbers that
meet a condition cells meet a condition
17 17. COUNTIF can be used to: Count all cells Count cells meeting a Count blank cells Count text cells only Count cells meeting a
condition condition

18 18. What does AVERAGEIF calculate? Average of all values Average of values Average of duplicates Total sum of values Average of values
that meet a condition that meet a condition

19 19. SUMIFS is used when: Only one condition is No conditions are Multiple conditions Data needs to be Multiple conditions
present needed are present highlighted are present
20 20. COUNTIFS works for: Counting all values Counting values Counting values Counting blanks only Counting values
based on one based on multiple based on multiple
condition conditions conditions
21 21. What does VLOOKUP do? Searches for values Searches for values Filters data Formats cells Searches for values
horizontally vertically vertically
22 22. The last argument in VLOOKUP specifies: Column index Range lookup type Lookup value Table array Range lookup type
number
23 23. How is HLOOKUP different from VLOOKUP? HLOOKUP searches HLOOKUP searches Both search vertically Both search HLOOKUP searches
horizontally, vertically, VLOOKUP horizontally horizontally,
VLOOKUP searches searches horizontally VLOOKUP searches
vertically vertically
24 24. INDEX is used to: Retrieve data from a Find duplicates Count values Combine text strings Retrieve data from a
specific position in a specific position in a
range range
25 25. MATCH is used to: Match duplicate Retrieve data from a Return the relative Count values in a Return the relative
values specific position position of a value in range position of a value in
a range a range
26 26. What is the main advantage of using INDEX-MATCH over Can search both Faster with large More flexible All of the above All of the above
VLOOKUP? vertically and datasets
horizontally
27 27. How do you insert a hyperlink in Excel? Insert > Hyperlink Right-click > Insert Use the HYPERLINK All of the above All of the above
Hyperlink function
28 28. What does CONCATENATE do? Combines text from Splits text into Highlights duplicates Removes spaces Combines text from
multiple cells multiple cells from text multiple cells
29 29. What is the shortcut for Cut in Excel? Ctrl + C Ctrl + X Ctrl + V Ctrl + Z Ctrl + X
30 30. Which key combination copies formatting? Ctrl + Alt + C Alt + C Ctrl + Shift + C None of these Ctrl + Shift + C
31 31. What does the Remove Duplicates feature do? Highlights duplicates Deletes duplicate Merges duplicate Sorts unique values Deletes duplicate
values, keeping only rows values, keeping only
the first occurrence the first occurrence

32 32. How do you apply multiple conditions in Conditional Use multiple rules Use the AND function Use the OR function All of the above All of the above
Formatting?
33 33. What does the AVERAGE function calculate? The sum of a range The total count of a The average of a The median of a The average of a
range range range range
34 34. What is the purpose of the Fill Handle in Excel? To copy formulas or To sort data To filter data To remove duplicates To copy formulas or
values to adjacent values to adjacent
cells cells
35 35. What does the HYPERLINK function do? Creates a clickable Filters data Splits text into Combines text strings Creates a clickable
link to a file, web columns link to a file, web
page, or cell page, or cell
36 36. What is the default delimiter in Text to Columns? Comma Tab Space Semicolon Tab
37 37. What does the COUNTA function count? Empty cells Non-empty cells Numbers only Text only Non-empty cells
38 38. Which tool is best for summarizing data? PivotTable Remove Duplicates Conditional Data Validation PivotTable
Formatting
39 39. How do you fix a value in a formula? Add a $ symbol Use the = sign Use conditional Add a filter Add a $ symbol
formatting
40 40. What does RIGHT("Excel", 2) return? "Ex" "el" "Ce" "Elce" "el"
41 41. What does LEFT("Excel", 3) return? "Exc" "Cel" "Ex" "Celx" "Exc"
42 42. Which function calculates the number of characters in a LEN COUNT TEXT CONCAT LEN
string?
43 43. What does TRIM(" Excel ") do? Adds spaces Removes all spaces Removes extra Converts text to Removes extra
spaces except single uppercase spaces except single
spaces between spaces between
words words
44 44. How does VLOOKUP handle exact matches? Requires TRUE in the Requires FALSE in the Always finds exact Always finds Requires FALSE in the
range_lookup range_lookup matches approximate range_lookup
argument argument matches argument
45 45. What is the result of =ROUND(12.345, 2)? 12.34 12.35 12.3 12.4 12.35
46 46. Which key combination is used to open the Find and Ctrl + F Ctrl + R Ctrl + H Ctrl + G Ctrl + H
Replace dialog?
47 47. How do you convert text to uppercase in Excel? =UPPER() =LOWER() =PROPER() =TEXT() =UPPER()
48 48. What does PROPER("excel spreadsheet") return? "EXCEL "excel spreadsheet" "Excel Spreadsheet" "Spreadsheet Excel" "Excel Spreadsheet"
SPREADSHEET"
49 49. Which chart is best for showing trends? Pie Chart Line Chart Bar Chart Radar Chart Line Chart
50 50. What does the NOW() function return? The current date The current time The current date and A random number The current date and
time time
51 51. What does the TODAY() function return? The current date The current time Both date and time The first day of the The current date
month
52 52. How do you apply a filter to a dataset? Select data and click Select data and click Use Conditional Use Text to Columns Select data and click
"Sort" "Filter" under the Formatting "Filter" under the
Data tab Data tab
53 53. What is the difference between CONCAT and CONCAT can handle No difference CONCATENATE is CONCAT is outdated CONCAT can handle
CONCATENATE? ranges, faster ranges,
CONCATENATE CONCATENATE
cannot cannot
54 54. Which function calculates the sum of squares of SUM SUMIF SUMSQ SUMIFS SUMSQ
differences?
55 55. What does HLOOKUP stand for? Horizontal Lookup Hybrid Lookup Header Lookup None of the above Horizontal Lookup
56 56. How do you highlight duplicates in a column? Use Conditional Use Data Validation Use Sort Use Remove Use Conditional
Formatting > Duplicates Formatting >
Highlight Cells Rules Highlight Cells Rules
> Duplicate Values > Duplicate Values

57 57. What does the UNIQUE function do in Excel? Finds duplicate Returns unique Sorts data Removes formatting Returns unique
values values from a range values from a range

58 58. What is the result of =MOD(10, 3)? 3 1 0 10 1

59 59. How do you lock a worksheet for editing? Use Conditional Use Protect Sheet Use Freeze Panes Use Data Validation Use Protect Sheet
Formatting under the Review tab under the Review tab
60 60. What is the shortcut to insert the current date in a cell? Ctrl + ; Ctrl + Shift + ; Ctrl + D Alt + D Ctrl + ;

61 1. What is the purpose of a PivotTable? To filter data To summarize and To create charts To edit raw data To summarize and
analyze data analyze data
dynamically dynamically
62 2. Where do you place numerical fields in a PivotTable? Filters Columns Values Rows Values

63 3. PivotCharts are directly linked to which feature? Raw data PivotTables Tables Data models PivotTables
64 4. What tool finds an input value to Goal Seek Solver Scenario Manager Data Table Goal Seek
achieve a desired output?
65 5. What does Scenario Manager allow you to do? Compare different Automaticall y Create PivotCharts Secure worksheets Compare different
input sets optimize formulas input sets
66 6. Data Tables are used to... Create charts Analyze multiple Format text Edit macros Analyze multiple
outcomes outcomes
67 7. Which function calculates the #NAME? #NAME? #NAME? #NAME? #NAME?
average in Excel?
68 8. Where can you record a macro? Developer Tab View Tab → Record Developer Tab Formulas Tab → Developer Tab
→ Macros Macro → Record Macro Record Macro → Record Macro
69 9. Solver is used to... Create charts Solve optimization Edit PivotTables Format data Solve optimization
problems problems
70 10. What is the purpose of Get & Edit cell styles Import and clean data Create PivotTables Apply filters Import and clean data
Transform data?
71 11. Which is a basic finance function? #NAME? #NAME? #NAME? All of the above All of the above
72 12. A simple dashboard usually contains... Charts Tables Slicers All of the above All of the above
73 13. What feature protects your workbook with a password? Encrypt Workbook Protect Sheet Track Changes Data Validation Encrypt Workbook

74 14. To print only a selected range of cells, you use... Page Layout > Set File > Print Selection Home > Format Data > Print Page Layout > Set
Print Area > Print Area Print Area
75 15. Which is an example of a PivotTable formula? =SUM(A1:A1 0) #NAME? #NAME? #NAME? #NAME?
76 16. What tab is used to insert a PivotTable? Home Insert Data Formulas Insert
77 17. What does the "Slicer" feature in a PivotTable do? Filters data visually Changes styles Removes duplicates Exports data Filters data visually

78 18. What is the function of Goal Seek? Change multiple Find the input for a Visualize data trends Record macros Find the input for a
variables desired result desired result
simultaneously
79 19. What does the PMT function calculate? Loan payment Loan interest Loan duration Loan principal Loan payment
80 20. The first step in recording a macro is... Open VBA editor Enable macros Click Record Macro Write the macro code Click Record Macro

81 21. What is a Scenario Summary? A table of multiple A PivotChart A data validation A chart type A table of multiple
outcomes report outcomes
82 22. Solver is located under which tab? Insert Data Formulas Review Data
83 23. The formula =MEDIAN(10, 20, 30) returns... 10 20 30 15 20
84 24. What chart is most often used in dashboards? Line chart Pie chart Column chart All of the above All of the above
85 25. Which data format is easiest for Formatted tables Merged cells Text boxes Charts Formatted tables
Get & Transform to process?
86 26. Which button updates a PivotTable after the source data Refresh Update Recalculate Load Refresh
changes?
87 27. What is the shortcut key for opening the Goal Seek Alt + T + G Alt + D + T Alt + A + G Alt + F + G Alt + T + G
dialog box?
88 28. Which of the following can be customized in a Axis titles Data labels Chart type All of the above All of the above
PivotChart?
89 29. What is the use of the FV function? Calculates future Calculates loan Finds internal rate of Calculates Calculates future
value of an payment return depreciation value of an
investment investment
90 30. Macros are written in which programming language? Python VBA Java C# VBA

91 31. How many scenarios can be added in the Scenario Unlimited 10 32 255 32
Manager?
92 32. Which tab contains the Print Area option? Home Page Layout File Data Page Layout
93 33. Which is a valid statistic function? #NAME? #NAME? #NAME? Both A and C Both A and C
94 34. What is the first step in creating a dashboard? Insert charts Define goals and key Add slicers Apply conditional Define goals and key
metrics formatting metrics
95 35. What is the role of Solver’s Constraints? Limit solution range Maximize variables Filter data Create charts Limit solution range

96 36. How can you create a Data Table in Excel? Data > What-If Insert > Table > Data File > Options > Data Formulas > Data Data > What-If
Analysis > Data Table Table Table Analysis > Data
Table Table
97 37. Which feature allows importing data from websites? Solver Get & Transform Goal Seek Scenario Manager Get & Transform

98 38. What does =STDEV.P(A1:A10 ) calculate? Sample standard Population standard Variance Mean Population standard
deviation deviation deviation
99 39. What is the shortcut for inserting a new worksheet? Ctrl + N Ctrl + T Shift + F11 Alt + W + N Shift + F11

100 40. In PivotTables, what does the Filter area do? Adds a dropdown for Adds a column to the Formats data Sorts rows Adds a dropdown for
filtering specific table filtering specific
values values
101 41. What can you apply to a chart to display trends over Trendline Slicer Data label PivotTable Trendline
time?

102 42. What is the default file extension for a macro-enabled .xlsx .xlsm .xlt .xls .xlsm
workbook?
103 43. To protect a worksheet, you need to go to: Review Tab > Protect File Tab > Options Data Tab > Protect Home Tab > Lock Review Tab > Protect
Sheet Workbook Sheet Sheet
104 44. What is the purpose of conditional formatting in Highlight key trends Protect cells Automate tasks Create pivot tables Highlight key trends
dashboards? and insights and insights
105 45. Which tool can handle multiple what-if scenarios? Solver Scenario Manager Goal Seek Trendline Scenario Manager

106 46. What does =ROUND(3.14159,2) return? 3 3.1 3.14 3.141 3.14
107 47. Which function calculates the present value of an #NAME? #NAME? #NAME? #NAME? #NAME?
investment?
108 48. How do you add a slicer to a PivotTable? Insert Tab > Slicer Developer Tab > Analyze Tab > Insert Data Tab > Slicer Analyze Tab > Insert
Slicer Slicer Slicer
109 49. How can you ensure your workbook is read- only? Save As > Tools > File > Protect Review > Lock Page Layout > Secure Save As > Tools >
General Options > Workbook Workbook Workbook General Options >
Read-only Read-only
110 50. What does the Solver Objective field specify? The cell to change The variable to The output range The cell to ignore The variable to
maximize, minimize, maximize, minimize,
or set to a value or set to a value

111 51. What is the purpose of the SUMIF function? Adds all values in a Adds values based on Adds only unique Adds values in Adds values based on
range a condition values PivotTables a condition
112 52. How can you highlight duplicates in a dataset? Use conditional Apply a filter Use a PivotTable Create a chart Use conditional
formatting formatting
113 53. What does the Trace Dependents tool show? Formula errors Cells affected by the Cell formatting External references Cells affected by the
selected cell selected cell
114 54. Which chart is best for comparing parts of a whole? Line Chart Bar Chart Pie Chart Scatter Plot Pie Chart

115 55. How can you combine data from multiple Get & Transform Goal Seek Solver Conditional Get & Transform
worksheets? Formatting
116 56. The shortcut for running a recorded macro is: Alt + F8 Alt + F11 Ctrl + Shift + M Ctrl + M Alt + F8
117 57. What does the =COUNTIF(A1:A1 0, ">5") formula do? Counts all cells Counts blank cells Counts cells with Adds all values Counts cells with
values greater than 5 greater than 5 values greater than 5

118 58. In which tab can you find Get & Transform tools? Insert Data Formulas View Data
119 59. What is the output of =IF(2>1, "Yes", "No")? No Error Yes 2 Yes
120 60. How do you enable Solver in Excel? File > Options Data > Analysis Developer Review > Protect File > Options
> Add-ins Tools > Macros Workbook > Add-ins
121 1. How do you open a data file in SPSS? File > Open > Data File > Import > Data File > New > Data Edit > Open > Data File > Open > Data

122 2. Which file extension is used for SPSS data files? .sav .sps .spv .xls .sav
123 3. How can you save a dataset in SPSS? File > Export File > Save As File > Save > Export File > Export > Save File > Save As
124 4. Which menu allows you to import data from other File > Open File > Import Data > Import Analyze > Data File > Import
sources? Import
125 5. What is the first step in entering data manually in SPSS? Click on Data View Switch to Variable Import from Excel Open a new syntax Switch to Variable
View file View
126 6. What is the purpose of labeling variables in SPSS? To create new To assign meaningful To recode values To transpose data To assign meaningful
variables names or names or
descriptions to descriptions to
variables variables
127 7. What does "Recode into Same Variable" do in SPSS? Changes the original Creates a new Transposes the data Deletes missing Changes the original
variable's values variable values variable's values

128 8. What is "Recode into Different Variable" used for? Modifies the same Creates a new Deletes cases Changes variable Creates a new
variable variable with recoded labels variable with recoded
values values
129 9. How do you transpose data in SPSS? Data > Restructure Transform > Edit > Transpose Analyze > Data Data > Restructure
Transpose Transpose
130 10. Which command is used to insert variables in SPSS? Insert > Variable Edit > Add Variable Data > Insert Variable Right-click > Insert Right-click > Insert
Variable Variable
131 11. How do you merge datasets in SPSS? Transform > Merge Data > Merge Files Analyze > Merge File > Merge Files Data > Merge Files
Cases Data
132 12. What is the purpose of splitting data in SPSS? To create separate To analyze subsets of To delete cases To merge variables To analyze subsets of
files data separately data separately
133 13. Which option allows you to select specific cases for Transform > Select Data > Select Cases Analyze > Select Edit > Select Cases Data > Select Cases
analysis? Cases Cases
134 14. How can you compute a total score in SPSS? Transform > Data > Total Score Analyze > Compute Edit > Add Total Transform >
Compute Variable Total Score Compute Variable
135 15. Which menu in SPSS is used to change the table Analyze > Table Data > Table Look Edit > Table Format > Table Look Format > Table Look
appearance? Options Appearance
136 16. What does the "Split File" option do? Merges data files Divides the dataset Deletes selected Reorganizes data Divides the dataset
into subsets for cases into subsets for
analysis analysis
137 17. How do you change the column width in SPSS? Right-click on column Edit > Adjust Width Format > Column View > Column Right-click on column
> Adjust Width Width Options > Adjust Width

138 18. Where can you change the font style in SPSS? Data View > Font Edit > Options Format > Font View > Font Style Format > Font
Style
139 19. What is the shortcut to insert a case in SPSS? Ctrl + I Right-click > Insert Data > Add Case Transform > Insert Right-click > Insert
Case Case Case
140 20. How do you rename a variable in SPSS? Right-click > Rename Variable View > Data > Rename Edit > Change Variable View >
Name Column Variable Variable Name Name Column
141 21. How do you merge variables in SPSS? Data > Merge Transform > Merge Compute > Merge Analyze > Merge Data > Merge
Variables Variables Variables Variables Variables
142 22. What is the default alignment for numeric data in SPSS? Left Center Right Justified Right

143 23. Which view allows you to edit data directly in SPSS? Variable View Data View Output View Syntax View Data View
144 24. What does the "Compute Variable" function do in SPSS? Creates new Recodes variables Merges variables Deletes variables Creates new
variables based on variables based on
formulas formulas
145 25. How can you exclude specific cases from analysis in Use Filter Use Split File Use Select Cases Delete Cases Use Select Cases
SPSS?
146 26. How do you reset a split file in SPSS? Data > Reset Split Transform > Clear Data > Split File > File > Clear Split Data > Split File >
Split Analyze All Cases Analyze All Cases
147 27. What does "Label Values" do in SPSS? Assigns numeric Assigns descriptions Changes variable Deletes cases Assigns descriptions
codes to text to numeric codes names to numeric codes
responses
148 28. How do you delete a variable in SPSS? Variable View > Right-click > Delete Data > Remove Format > Delete Right-click > Delete
Delete Variable Variable Variable Variable Variable
149 29. Which function is used to group data for analysis? Compute Variable Recode into Groups Split File Select Cases Split File

150 30. How do you handle missing data in SPSS? Delete Missing Data Transform > Handle Data > Define Missing Format > Handle Data > Define Missing
Missing Data Missing Data

151 31. Which tab allows importing Excel files into SPSS? File > Open File > Import Data Analyze > Import Data > Import File > Open
152 32. What does the "Add Cases" option do? Combines two Combines two Merges variables Deletes cases Combines two
datasets by rows datasets by columns datasets by rows

153 33. How can you display variable labels in Data View? Edit > Display Labels View > Variable Data > Show Labels File > Variable Labels View > Variable
Labels Labels
154 34. Which menu is used to add variable labels in SPSS? Data > Label Transform > Variable Variable View > Label Analyze > Label Variable View > Label
Variables Labels Column Variables Column
155 35. What is the role of the "Define Variable Properties" Adjusts font styles Adjusts case formats Defines labels and Deletes missing data Defines labels and
tool? measurement levels measurement levels

156 36. How do you save the output in SPSS? File > Save File > Save Output As File > Export Output Edit > Save Output File > Save Output As

157 37. Which format is used for exporting SPSS data to Excel? .sav .xls .xlsx Both B and C Both B and C

158 38. What does "Transform > Rank Cases" do? Deletes duplicates Sorts data Assigns ranks to data Transposes data Assigns ranks to data
values values
159 39. How do you specify custom missing values in SPSS? Data > Define Missing Transform > Handle Variable View > Edit > Missing Values Variable View >
Missing Missing Column Missing Column
160 40. What is the purpose of the Output Viewer in SPSS? To edit data To display analysis To manage syntax To view variable To display analysis
results files labels results
161 41. What does the "Weight Cases" function do? Groups cases Assigns weights to Splits data Merges files Assigns weights to
cases for analysis cases for analysis
162 42. Which measure level is used for categorical data in Scale Ordinal Nominal Continuous Nominal
SPSS?
163 43. Which feature combines datasets based on a common Merge Cases Add Variables Match Cases Merge Files Merge Files
key?
164 44. What is the default font style in SPSS? Arial Times New Roman Calibri Courier New Arial
165 45. What does the Syntax Editor allow you to do? Write and run SPSS Edit variable labels Adjust data Export data Write and run SPSS
commands formatting commands
166 46. How do you run a syntax file in SPSS? File > Run Syntax > Run Edit > Run All Right-click > Run All Edit > Run All
167 47. What is the purpose of "Select Cases"? To filter rows based To merge datasets To recode variables To rename variables To filter rows based
on criteria on criteria
168 48. How do you transpose rows to columns in SPSS? Data > Transpose Transform > Edit > Transpose Analyze > Transpose Transform >
Restructure Restructure
169 49. Which view in SPSS allows you to define variable Data View Variable View Syntax View Output View Variable View
attributes?
170 50. How do you add new rows to a dataset in SPSS? Use Data View > Add Right-click > Insert Variable View > Add Edit > Add Rows Right-click > Insert
Rows Case Rows Case
171 51. What does the "File > Export" option do? Saves data in SPSS Exports data to other Deletes variables Imports new data Exports data to other
format formats formats
172 52. How do you compute a z-score in SPSS? Analyze > Compute Z- Data > Compute Z- Transform > Transform > Rank Transform >
Score Score Compute Variable Cases Compute Variable
173 53. What is the "Measure" column in Variable View used To set data types To label variables To set levels of To recode variables To set levels of
for? measurement measurement
174 54. What does "Recode into Same Variable" do? Deletes cases Changes the Merges datasets Adjusts missing data Changes the
variable's original variable's original
values values
175 55. How do you hide gridlines in SPSS tables? View > Gridlines Edit > Hide Gridlines Format > Table Look Analyze > Gridlines Format > Table Look

176 56. What is the purpose of the "Sort Cases" feature? To rank cases To arrange rows in To merge datasets To group variables To arrange rows in
ascending or ascending or
descending order descending order
177 57. Which window displays warnings and errors in SPSS? Data View Output Viewer Syntax Editor Variable View Output Viewer

178 58. How do you clear all filters in SPSS? Data > Clear Filters Analyze > Reset Select Cases > All Edit > Clear Filters
Select Cases > All
Filters Cases Cases
179 59. What is the "Role" column in Variable View used for? To assign roles like To merge variables To add labels To adjust To assign roles like
Input or Target measurement scales Input or Target

180 60. How do you split data into subsets for analysis? Data > Split File Transform > Subset Edit > Divide Dataset Analyze > Split Data Data > Split File
Data
181 1. What does the Compute Variable function in SPSS do? Creates a new Modifies an existing Deletes missing data Recodes variables Creates a new
variable based on a variable variable based on a
formula formula
182 2. What is the purpose of Count Values within Cases? To count the To count the total To summarize data To create a new To count the
frequency of values number of cases values variable frequency of values
in a case in a case
183 3. What happens when you use "Recode into Same To count the Deletes the original Creates a new Adds missing values To count the
Variable"? frequency of values variable variable to the dataset frequency of values
in a case in a case
184 4. What is the effect of using "Recode into Different It changes the It creates a new It merges two It deletes the variable It creates a new
Variables"? original variable's variable with recoded datasets variable with recoded
values values values
185 5. What does Automatic Recode do in SPSS? Automatically sorts Automatically labels Recodes string Deletes duplicate Recodes string
the data missing values variables into values variables into
numeric values numeric values
186 6. How does Visual Binning work in SPSS? Converts variables Creates new cases Sorts variables based Creates charts Converts variables
into categories or based on bins on bin values into categories or
bins bins
187 7. What does the Descriptive Statistics option in SPSS do? Summarizes data Recodes data Transposes data Creates charts Summarizes data

188 8. What is the primary function of a Bar Chart? To represent data To show frequency or To display data over To show correlations To show frequency or
distribution comparison between time between variables comparison between
categories categories
189 9. Which chart type is used for comparing multiple Simple Bar Chart Multiple Bar Chart Pie Chart Histogram Multiple Bar Chart
categories side by side?
190 10. What is a Sub-divided Bar Diagram used for? To show the To compare the To show data points To show parts of a To compare the
distribution of data values of different on a line whole values of different
over time categories within one categories within one
bar bar
191 11. What does a Percentage Diagram show? Total values Parts of a whole Frequency Trend over time Parts of a whole
represented as distribution of data represented as
percentages percentages
192 12. What is a Pie Chart used for? Showing data over Comparing data Displaying parts of a Visualizing trends Displaying parts of a
time between multiple whole whole
groups
193 13. What does a Frequency Table display? Counts of each Relationships A histogram of data A line chart Counts of each
unique value in a between two unique value in a
dataset variables dataset
194 14. What is the primary purpose of a Histogram? To display parts of a To show data To compare different To plot relationships To show data
whole distribution and categories between variables distribution and
frequency frequency
195 15. What does a Scatter Diagram represent? The relationship Parts of a whole Frequency Trends over time The relationship
between two distribution of values between two
variables variables
196 16. What is the main feature of a Box Plot? To show central To show trends over To represent the To compare To show central
tendency and time frequency of values categories tendency and
variability of data variability of data
197 17. How do you calculate the total count of values within Use Compute Use Count Values Use Recode into Use Automatic Use Count Values
cases in SPSS? Variable within Cases Same Variable Recode within Cases
198 18. What does the "Visual Binning" option in SPSS do? Creates new Recodes data to Displays bar charts Computes total Creates new
variables based on numeric values scores variables based on
binning criteria binning criteria
199 19. What type of data is most suitable for a Pie Chart? Numerical Nominal categorical Ordinal data Time-series data Nominal categorical
continuous data data data
200 20. Which function can you use to summarize a set of Descriptive Statistics
Count Values within Compute Variable Recode into Same Descriptive Statistics
continuous variables in SPSS? Cases Variable
201 21. How does a Multiple Bar Chart differ from a Simple Bar It compares multiple It is used for only one It uses lines instead It shows a It compares multiple
Chart? data points within category of bars percentage of a total data points within
the same bar the same bar

202 22. What does a Frequency Table allow you to do in SPSS? Count unique values Summarize and Visualize a histogram Recode variables Count unique values
in a dataset analyze data in a dataset
203 23. How can you visualize the distribution of numerical data Use a Bar Chart Use a Pie Chart Use a Histogram Use a Box Plot Use a Histogram
in SPSS?
204 24. Which function in SPSS creates a new variable based on Recode into Same Recode into Different Compute Variable Count Values within Compute Variable
an existing one? Variable Variable Cases
205 25. What does a Box Plot visually represent? Parts of a whole Relationship between Central tendency and Frequency Central tendency and
variables spread of data distribution spread of data
206 26. How do you recode string variables into numeric values Recode into Same Recode into Different Automatic Recode Visual Binning Automatic Recode
automatically in SPSS? Variable Variable
207 27. In SPSS, what is the main purpose of using "Recode into To delete data To create new To modify existing To merge variables To modify existing
Same Variable"? variables based on variable values variable values
recoding
208 28. What type of diagram is best used for comparing Box Plot Histogram Pie Chart Bar Chart Bar Chart
categories of data?
209 29. How can you create a visual representation of the Use a Box Plot Use a Scatter Use a Frequency Use a Pie Chart Use a Scatter
relationship between two continuous variables in SPSS? Diagram Table Diagram

210 30. What is the effect of using the "Shift Values" function in It shifts the position It changes the values It merges data It creates a new It shifts the position
SPSS? of data points of variables variable of data points

211 31. What is the best method to represent the distribution of Pie Chart Box Plot Histogram Multiple Bar Chart Histogram
a variable in SPSS?
212 32. How does the "Recode into Different Variables" function It creates a new It computes new It generates It deletes data It creates a new
help in data analysis? variable with values based on summary statistics variable with
transformed values formulas transformed values
213 33. What type of chart is useful for showing trends over Line Chart Pie Chart Histogram Bar Chart Line Chart
time?
214 34. What does the "Statistical Analysis" option in SPSS do? Computes summary Generates new Visualizes data Reorganizes data Computes summary
statistics variables statistics
215 35. In SPSS, what does the "Recode into Same Variable" Replaces the original Adds a new variable Sorts data Creates a frequency Replaces the original
function do? values with new with transformed table values with new
recoded values values recoded values

216 36. What is a key feature of a Multiple Bar Chart? Displays a single Shows parts of a Allows comparison Visualizes Allows comparison
category comparison whole across multiple distribution across multiple
groups groups
217 37. What is the default display for values in a Frequency Percentages Counts Mean values Median values Counts
Table in SPSS?
218 38. How do you create a Sub-divided Bar Diagram in SPSS? Use the Bar Chart Use the Multiple Bar Use the Pie Chart Use the Line Graph Use the Bar Chart
option and subdivide Chart option option option option and subdivide
the bars the bars
219 39. How do you visualize correlations between two variables Use a Scatter Plot Use a Box Plot Use a Histogram Use a Bar Chart Use a Scatter Plot
in SPSS?
220 40. What does the "Visual Binning" feature in SPSS allow Display data Create bins for Transform variables Merge datasets Create bins for
you to do? distribution continuous variables into categories continuous variables

221 41. What chart would you use to compare the frequency of Histogram Pie Chart Box Plot Bar Chart Bar Chart
different categories?
222 42. How do you compute the total value of a new variable in Use the Compute Use the Recode Use Count Values Use Automatic Use the Compute
SPSS? Variable function function within Cases Recode Variable function
223 43. What does the "Count Values within Cases" function do Counts the frequency Computes totals of Displays percentage Recodes variable Counts the frequency
in SPSS? of cases based on values distributions values of cases based on
conditions conditions

224 44. In SPSS, what type of data does a Histogram work best Nominal Ordinal Continuous Categorical Continuous
for?
225 45. Which chart is ideal for comparing parts of a whole? Bar Chart Line Chart Pie Chart Scatter Diagram Pie Chart

226 46. How can you visualize a cumulative distribution of data Histogram Bar Chart Box Plot Line Chart Histogram
in SPSS?
227 47. What type of chart shows individual data points to Box Plot Pie Chart Histogram Scatter Diagram Box Plot
assess distribution?
228 48. How do you create a total score for each case in SPSS? Use the Compute Use Recode into Use Count Values Use Select Cases Use the Compute
Variable option Same Variable within Cases Variable option
229 49. What is a key feature of the "Recode into Different Creates new Transposes data Deletes variables Merges data Creates new
Variables" option in SPSS? variables based on variables based on
recoding rules recoding rules
230 50. How do you visualize the distribution of categorical data Use a Pie Chart Use a Scatter Plot Use a Histogram Use a Line Chart Use a Pie Chart
in SPSS?
231 51. How do you represent the relationship between two Box Plot Scatter Plot Histogram Pie Chart Scatter Plot
continuous variables visually?
232 52. What type of data does the "Count Values within Cases" Continuous String variables Categorical data Both A and C Both A and C
function work with? numerical data
233 53. What is the main purpose of the "Recode into Different To merge datasets To compute scores To create a new To change variable To create a new
Variables" feature? variable with labels variable with
transformed values transformed values
234 54. What type of data is typically displayed in a Box Plot? Categorical data Continuous Time-series data Ordinal data Continuous
numerical data numerical data
235 55. How do you calculate the mean for a new variable in Use the Compute Use Descriptive Use Recode into Use Count Values Use Descriptive
SPSS? Variable function Statistics Same Variable within Cases Statistics
236 56. What is a key feature of a Frequency Table in SPSS? Displays only the Displays the count of Displays correlation Displays data Displays the count of
mode of data unique values between variables distributions unique values

237 57. What does the "Shift Values" function in SPSS do? Adjusts the positions Changes the value of Sorts the data Merges data Adjusts the positions
of data points data points of data points

238 58. How do you visualize data distribution in SPSS? Use a Pie Chart Use a Histogram Use a Box Plot Use a Scatter Plot Use a Histogram
239 59. How can you merge two datasets in SPSS? Use the Merge Files Use the Add Cases Use the Split File Use Recode into Use the Merge Files
function option function Same Variable function
240 60. What type of chart would you use to compare multiple Scatter Plot Histogram Line Chart Bar Chart Line Chart
variables over time?
Q.No. Questions
1 Explain the purpose of the "Compute Variable" function in
SPSS and provide an example of how it is used to create new
variables.
2 What is the difference between "Recode into Same
Variable" and "Recode into Different Variables" in SPSS?
Provide examples of when each should be used.
3 Describe how the "Count Values within Cases" function
works in SPSS. How would you use this function to analyze
categorical data?
4 Explain the role of the "Shift Values" function in SPSS and
how it can be useful in data manipulation. Provide an
example scenario where shifting values is necessary.

5 What is "Visual Binning" in SPSS, and how does it convert

continuous variables into categorical data? Discuss the
advantages and limitations of using this feature.

6 Describe the process and benefits of using "Automatic

Recode" in SPSS to convert string variables into numeric
values. Provide an example where this function would be
applied.
7 In SPSS, how would you use "Descriptive Statistics" to
summarize a dataset? What types of statistical measures
can be obtained using this feature?
8 Explain the difference between a Simple Bar Diagram and a
Multiple Bar Diagram in SPSS. How would you choose which
one to use in a data presentation?
9 Describe the advantages of using a Sub-divided Bar Diagram
compared to a Simple Bar Diagram. How does this type of
diagram help in visualizing complex data?

10 What is a Percentage Diagram, and how can it be used in

SPSS to show the relationship of parts to a whole? Discuss
how this can be helpful in data analysis.

11 In SPSS, when would you choose to use a Pie Chart over a

Bar Diagram? Discuss the strengths and weaknesses of each
method for representing categorical data.

12 Describe how a Histogram and a Box Plot can be used to

visualize continuous data distributions in SPSS. What key
insights can each type of chart provide?
13 Explain the process of opening an SPSS data file. What steps
would you follow to load a dataset into SPSS and ensure it is
ready for analysis?
14 How can you save an SPSS data file? Describe the different
formats you can save your data in and the implications of
choosing each format.
15 What is the procedure for importing data from other data
sources into SPSS? Provide an example of how you would
import data from Excel or a CSV file.
16 Discuss the steps involved in data entry in SPSS. How would
you enter data manually into the Data View, and what
precautions should you take?
17 What is the purpose of labelling dummy numbers in SPSS,
and how can you assign labels to these numbers effectively?
Give an example of dummy variables.
18 What is the difference between "Recode into Same
Variable" and "Recode into Different Variables" in SPSS?
Provide examples of when you would use each option.

19 How do you transpose data in SPSS? Explain when you

might need to transpose data and what this operation
accomplishes in terms of structure.
20 Describe the steps to insert new variables and cases in SPSS.
How would you add a new variable to a dataset or insert
new cases (rows) into the Data View?
21 Explain how you can merge variables and cases in SPSS.
When would you need to use the "Merge Files" function,
and what types of datasets would benefit from merging?

22 In SPSS, what does the "Split File" function do? Describe a

scenario where you would use it to analyze data by different
groups or categories.
23 How do you select specific cases for analysis in SPSS using
the "Select Cases" function? Provide an example of how this
feature is useful for filtering datasets.
24 Describe how to compute total scores for a set of variables
in SPSS. What steps would you follow to create a new
variable that represents the sum or average of existing
variables?
25 Describe the different basic arithmetic operations in Excel
(addition, subtraction, multiplication, and division). How
would you use these operations to perform calculations
across multiple cells?
26 Explain the process of cell formatting in Excel. What options
are available for changing the appearance of text and
numbers, and how can formatting be applied to improve
readability?
27 What is the "Paste Special" function in Excel? Provide
examples of different paste options available, such as
pasting values, formats, and transposing data.
28 What is Conditional Formatting in Excel, and how can it be
used to visually highlight data that meets specific criteria?
Provide examples of using Conditional Formatting for data
analysis.
29 Explain how to insert advanced charts in Excel. How would
you create and customize different types of charts, such as
line charts, bar charts, and combo charts, for visualizing
complex data?
30 Describe how to use conditional functions in Excel, such as
IF, IF-AND, IF-OR, and Nested IF. Provide examples of
situations where these functions can be used to make
decisions based on conditions.
31 How does sorting and filtering work in Excel? Describe the
steps involved in sorting data by different criteria and
filtering data based on specific conditions.
32 What is Data Validation in Excel, and how can it be used to
ensure the accuracy and integrity of data entered into a
spreadsheet? Provide examples of how to apply data
validation rules, such as restricting input types or ranges.

33 How does hyperlinking work in Excel? Explain how to insert

hyperlinks to external websites, other worksheets, or
specific cell references within a workbook.

34 What is the CONCATENATE function in Excel? How would

you use it to combine text from multiple cells into one cell,
and what are the benefits of using this function in data
management?
35 Explain how the "Text to Columns" feature works in Excel.
How would you use it to split text from a single cell into
multiple columns based on a delimiter, such as a comma or
space?
36 Describe how to use functions such as SUMIF, COUNTIF,
AVERAGEIF, SUMIFS, COUNTIFS, and AVERAGEIFS in Excel.
Provide examples of how each of these functions can be
applied to calculate values based on specific criteria in a
dataset.
37 Explain how to create and manipulate a PivotTable in Excel.
What are the steps involved in selecting data and arranging it
in a PivotTable for analysis?
38 Describe how to build and apply formulas in PivotTables.
How can you calculate sums, averages, or percentages within
a PivotTable, and what are some common uses for these
formulas?
39 What is a PivotChart, and how does it differ from a
PivotTable? Discuss how to create a PivotChart and how it
can be customized for better visualization of data.

40 How do you use the Goal Seek feature in Excel? Provide an

example where you would use Goal Seek to find a value
needed to achieve a specific goal.
41 Explain how the Scenario Manager works in Excel. How
would you set up different scenarios to analyze the impact of
various assumptions or conditions on a financial model?
42 What is a Data Table in Excel, and how can it be used for
sensitivity analysis? Provide an example of how a one-
variable or two-variable data table could be applied in
decision-making.
43 Discuss the use of basic statistics functions in Excel, such as
AVERAGE, MEDIAN, and STDEV. How would you apply
these functions to summarize a dataset?

44 Describe how to record and use a basic Macro in Excel.

What are the steps involved in creating a Macro to automate
repetitive tasks, and how can macros improve efficiency?

45 What is the Solver tool in Excel, and how can it be used for
optimization problems? Provide an example of how Solver
can help in maximizing or minimizing a target value under
certain constraints.
46 Explain the process of importing and transforming data in
Excel. How can the Get & Transform (Power Query) feature
be used to clean, reshape, and prepare data for analysis?

47 What are basic finance functions in Excel, such as PMT, FV,

and PV? Provide examples of how each function can be used
in financial analysis or planning.
48 How do you build a simple dashboard in Excel? Discuss the
process of creating a dashboard using PivotTables,
PivotCharts, and other visual elements to display key
performance indicators (KPIs) and insights.