Quiz Space

Tools in Data Science · End Term · 13 Apr 2025 · January 2025 term · Set QDD3

Question 1: You have a spreadsheet with values containing leading zer…

Question 1

+1 markOne correct option

You have a spreadsheet with values containing leading zeros (e.g., "001234"). What's the most effective way to preserve these zeros during Text-to-Columns?

  1. A

    Save as CSV before applying Text-to-Columns

  2. B

    Format cells as Text before using Text-to-Columns

  3. C

    Change the delimiter to semicolons

  4. D

    Manually change the affected cells back to numbers

Show answer

Correct answer

  • B

    Format cells as Text before using Text-to-Columns

See the whole paperTake it as a mock test

Question 1 of 35 in the IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 13 Apr 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025). It carries 1 mark.

More questions from this paper

  1. Q2What is the correct order of execution in a Python try-except-finally block if no exception occurs?
  2. Q3A data scientist needs to count non-null values in each column of a DataFrame. Which pandas method should they use?
  3. Q4What Git command would you use to discard changes in your working directory and revert to the last committed state?
  4. Q5To debug a memory leak in a JavaScript application, which Chrome DevTools panel is most useful?
  5. Q6A data scientist is analyzing the relationship between advertising spend and sales. Which statistical test would be mos…
  6. Q7Which OpenRefine feature allows you to track and reapply the same cleaning operations to similar datasets?
  7. Q8A web developer wants to analyze the load time and resources of a webpage. Which Chrome DevTools feature provides compr…
  8. Q9Which of the following is NOT typically a built-in feature of modern IDEs?
  9. Q10In Kumu, what feature allows you to highlight specific parts of your visualization based on element properties?
  10. Q11Which HTTP method is considered safe because it doesn't modify server state?
  11. Q12If a researcher needs to perform advanced spatial analysis and calculate the distance between geometric objects, which …
  12. Q13Aisha prompts the LLM: "Provide a detailed analysis of immunotherapy developments for cancer treatment." What aspect of…
  13. Q14When Aisha uses the LLM for her medical research, which of the following statements are TRUE regarding LLM capabilities…
  14. Q15Aisha needs to gather information about a specific cancer treatment approach. Which of these prompts would likely gener…
  15. Q16During the emergency response, multiple teams are updating patient intake records. Which Git command would a team membe…
  16. Q17An administrator needs to search through patient records to find all entries related to "Accident Site Triage". Which c…
  17. Q18In a resource-constrained hospital environment, which deployment method would be MOST appropriate for the patient manag…
  18. Q19Which computational tool would be MOST APPROPRIATE for optimizing ambulance routes to transport patients efficiently?
  19. Q20What is the primary advantage of using the Haversine formula in ambulance route planning?
  20. Q21Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  21. Q22Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  22. Q23Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  23. Q24Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  24. Q25Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  25. Q26Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  26. Q27Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  27. Q28Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  28. Q29Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  29. Q30Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  30. Q31Scenario 3:\ You are provided with a Gzipped Apache log file from a website having the below data in each row. The fiel…
  31. Q32What is the primary purpose of the system prompt in controlling an AI learning assistant's behavior?
  32. Q33Choose the best system prompt that achieves the instructor's goals.
  33. Q34A student asks: "How do I identify open reading frames (ORFs) in a DNA sequence?"\ Choose the most pedagogically effect…
  34. Q35Assume that BioTutor uses a RAG (Retrieval-Augmented Generation) system to assist students with bioinformatics queries.…