Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.
0 / 20 published solutions
Question 218 MCQ · 1.0 marks
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
A.
Find and Replace
B.
Finding and Replacing
C.
Replace and Find
D.
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
A published solution is not available for this question yet.
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
A.
Statements A, B, and D are TRUE
B.
Statements A, C, and D are TRUE
C.
Only Statement C is TRUE, and A being TRUE is ambiguous.
D.
Both Statements A and C are true
A published solution is not available for this question yet.
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
A.
Statement 1 is correct
B.
Statements 1,2,4 are correct
C.
Statements 2,4 are correct
D.
Statement 3 is correct
A published solution is not available for this question yet.
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:
A.
Use the "Split" function in Excel/Google Sheets.
B.
Use the "Find and Replace" feature in Excel/Google Sheets.
C.
Use the "Wrap Text" feature in Excel/Google Sheets.
D.
Use the "Text to Columns" feature in Excel/Google Sheets.
A published solution is not available for this question yet.
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.
A.B.C.D.
A published solution is not available for this question yet.
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
A.
Alpha > Tango > Gamma > Beta
B.
Gamma > Tango > Beta> Alpha
C.
Alpha < Gamma < Tango < Beta
D.
Gamma < Tango < Beta< Alpha
A published solution is not available for this question yet.
Consider the following Volume Sales Data for 4 different SKUs. Analyze and interpret - which of the
following datasets qualifies the Volume Pareto criteria?
A.
A
B.
B
C.
C
D.
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
A published solution is not available for this question yet.