Options :
6406531892083. convert_into
6406531892084. convert_file
6406531892085. convert_all
6406531892086. convert_csv
Question Number : 218 Question Id : 640653566145 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 1
Question Label : Multiple Choice Question
From the converted csv file in previous question , you realize that the team ‘Delhi Daredevil’ has
changed its name to ‘Delhi Capital’. Using excel, you wish to replace the old name with a new
name. It can be done in Excel using
Options :
6406531892087. Find and Replace
6406531892088. Finding and Replacing
6406531892089. Replace and Find
6406531892090. Search and Replace
BDM
Section Id : 64065338405
Section Number : 8
Section type : Online
Mandatory or Optional : Mandatory
Number of Questions : 16
Number of Questions to be attempted : 16
Section Marks : 40
Display Number Panel : Yes
Group All Questions : No
Enable Mark as Answered Mark for Review and
Yes
Clear Response :
Maximum Instruction Time : 0
Sub-Section Number : 1
Sub-Section Id : 64065380957
Question Shuffling Allowed : No
Is Section Default? : null
Question Number : 219 Question Id : 640653566195 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 0
Question Label : Multiple Choice Question
THIS IS QUESTION PAPER FOR THE SUBJECT "DIPLOMA LEVEL : BUSINESS DATA MANAGEMENT
(COMPUTER BASED EXAM)"
ARE YOU SURE YOU HAVE TO WRITE EXAM FOR THIS SUBJECT?
CROSS CHECK YOUR HALL TICKET TO CONFIRM THE SUBJECTS TO BE WRITTEN.
(IF IT IS NOT THE CORRECT SUBJECT, PLS CHECK THE SECTION AT THE TOP FOR THE SUBJECTS
REGISTERED BY YOU)
Options :
6406531892278. YES
6406531892279. NO
Sub-Section Number : 2
Sub-Section Id : 64065380958
Question Shuffling Allowed : Yes
Is Section Default? : null
Question Number : 220 Question Id : 640653566196 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
Which of the following best describes the churn rate?
Options :
6406531892280. The number of new customers acquired in a given period
6406531892281. The percentage of customers who stop using a product or service in a given
period
6406531892282. The amount of money earned from a customer in a given period
6406531892283. The cost of acquiring a new customer
Question Number : 221 Question Id : 640653566197 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
Which of the following goods is likely to have the lowest marginal utility?
Options :
6406531892284. A necessity good.
6406531892285. A luxury good.
6406531892286. A good that the consumer has never tried before.
6406531892287. A good that the consumer has consumed many times before.
Question Number : 222 Question Id : 640653566198 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
When does marginal utility become negative?
Options :
6406531892288. When a consumer consumes the first unit of a good.
6406531892289. When the total utility of a good is zero.
6406531892290. When the total utility of a good is at its maximum.
6406531892291. When the consumer reaches the point of overconsumption.
Question Number : 223 Question Id : 640653566199 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
If the price of a product increases by 20% and the quantity demanded decreases by 10%, what is
the price elasticity of demand?
Options :
6406531892292. 2
6406531892293. 0.5
6406531892294. 1
6406531892295. 1.5
Question Number : 224 Question Id : 640653566200 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
The current ratio is a measure of:
Options :
6406531892296. A company's ability to pay its long-term debt obligations.
6406531892297. A company's liquidity and short-term solvency.
6406531892298. A company's ability to generate profits.
6406531892299. A company's efficiency in managing its inventory.
Question Number : 225 Question Id : 640653566201 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
A Company has current assets of $750,000 and current liabilities of $250,000. What is the current
ratio of the company?
Options :
6406531892300. 3
6406531892301. 1
6406531892302. 1.5
6406531892303. 0.33
Question Number : 226 Question Id : 640653566202 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
A/B testing is used for:
Options :
6406531892304. Measuring the churn rate of a product
6406531892305. Comparing two versions of a product to determine which one performs better
6406531892306. Increasing the price of a product to maximize revenue
6406531892307. Reducing the number of features of a product to make it simpler
Question Number : 227 Question Id : 640653566212 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
Consider the following graphical representation of the Average of Credit Scores of Approved and
Declined Credit Applications. Which of the following statements stands TRUE?
Statement A: The average of Credit Scores of customers getting declined remains more or less
constant throughout the months
Statement B: Average Credit Scores of customers getting approved have increased over time
Statement C: Average Credit Scores of customers getting approved have decreased over time
Statement D: Grand Total Average has no correlation with whether the decline rate reduces or
increases
Options :
6406531892318. Statements A, B, and D are TRUE
6406531892319. Statements A, C, and D are TRUE
6406531892320. Only Statement C is TRUE, and A being TRUE is ambiguous.
6406531892321. Both Statements A and C are true
Question Number : 228 Question Id : 640653566213 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
Consider the following graph representing the volume sales through an E-Commerce run
distribution center through 15 days. Which among the following explains Thursday's volume being
more than the rest of the days?
Statement 1 : There was a Black Friday sale on Thursday
Statement 2 : It’s possible that Thursday’s data is the only day occouring thrice among in the 15
day data
Statement 3 : It is not possible to judge trends with this less information
Statement 4 : One of the thursdays could be a public holiday/ online sale festival day
Options :
6406531892322. Statement 1 is correct
6406531892323. Statements 1,2,4 are correct
6406531892324. Statements 2,4 are correct
6406531892325. Statement 3 is correct
Question Number : 229 Question Id : 640653566215 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
There is a column containing multiple courses a student has registered for like “BDM, TDS, BA,
Python, English II” How can you separate these courses/words into distinct cells like this:
Options :
6406531892330. Use the "Split" function in Excel/Google Sheets.
6406531892331. Use the "Find and Replace" feature in Excel/Google Sheets.
6406531892332. Use the "Wrap Text" feature in Excel/Google Sheets.
6406531892333. Use the "Text to Columns" feature in Excel/Google Sheets.
Question Number : 230 Question Id : 640653566216 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 2
Question Label : Multiple Choice Question
Consider the following screenshot. Which among the following will be the correct syntax to put in
the formula box for cell I2? Consider a situation where the company takes 2.5% as a commission
on all application amounts for processing the application.
Options :
6406531892334.
6406531892335.
6406531892336.
6406531892337.
Sub-Section Number : 3
Sub-Section Id : 64065380959
Question Shuffling Allowed : No
Is Section Default? : null
Question Id : 640653566203 Question Type : COMPREHENSION Sub Question Shuffling
Allowed : No Group Comprehension Questions : No Question Pattern Type : NonMatrix
Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Question Numbers : (231 to 234)
Question Label : Comprehension
Calculate the given subquestion for Gear Broaching Process for Week 1
Sub questions
Question Number : 231 Question Id : 640653566204 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
Availability - _______% (upto one decimal point)
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
82 to 84
Question Number : 232 Question Id : 640653566205 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
Performance ________% (upto one decimal point)
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
86 to 87.5
Question Number : 233 Question Id : 640653566206 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
Quality ________% (upto one decimal point)
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
91 to 93
Question Number : 234 Question Id : 640653566207 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
OEE _______ (Enter a number between 0 and 1 up to 3 decimal places)
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
0.600 to 0.720
Sub-Section Number : 4
Sub-Section Id : 64065380960
Question Shuffling Allowed : No
Is Section Default? : null
Question Id : 640653566208 Question Type : COMPREHENSION Sub Question Shuffling
Allowed : No Group Comprehension Questions : No Question Pattern Type : NonMatrix
Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Question Numbers : (235 to 236)
Question Label : Comprehension
Answer the given subquestions concerning the Hobbing process of gear manufacturing.
Total Output of Gear casts after Hobbing: 2600.
Cost of Hobbing: INR 33 per Gear cast, Raw Material Cost: INR 37 per Gear Cast
Sub questions
Question Number : 235 Question Id : 640653566209 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
Scrap Percentage after broaching process_______________%
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
4.02 to 4.06
Question Number : 236 Question Id : 640653566210 Question Type : SA Calculator : None
Response Time : N.A Think Time : N.A Minimum Instruction Time : 0
Correct Marks : 2
Question Label : Short Answer Question
Loss due to scrap after broaching_______________
Response Type : Numeric
Evaluation Required For SA : Yes
Show Word Count : Yes
Answers Type : Range
Text Areas : PlainText
Possible Answers :
7150 to 7500
Sub-Section Number : 5
Sub-Section Id : 64065380961
Question Shuffling Allowed : Yes
Is Section Default? : null
Question Number : 237 Question Id : 640653566211 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 3
Question Label : Multiple Choice Question
Consider the following dataset:
Here all the factors are “more the better” . You can combine all the criteria as :
Composite Score= Sum of all criteria on the same scale
Rank the above candidates and choose the correct ranking from the below options
Options :
6406531892314. Alpha > Tango > Gamma > Beta
6406531892315. Gamma > Tango > Beta> Alpha
6406531892316. Alpha < Gamma < Tango < Beta
6406531892317. Gamma < Tango < Beta< Alpha
Question Number : 238 Question Id : 640653566214 Question Type : MCQ Is Question
Mandatory : No Calculator : None Response Time : N.A Think Time : N.A Minimum Instruction
Time : 0
Correct Marks : 3
Question Label : Multiple Choice Question
Consider the following Volume Sales Data for 4 different SKUs. Analyze and interpret - which of the
following datasets qualifies the Volume Pareto criteria?
Options :
6406531892326. A
6406531892327. B
6406531892328. C
6406531892329. D
System Commands
Section Id : 64065338406
Section Number : 9
Section type : Online
Mandatory or Optional : Mandatory
Number of Questions : 14
Number of Questions to be attempted : 14
Section Marks : 100
