Quiz Space

Business Data Management · End Term · 13 Sept 2026 · May 2026 term · Set 1

Question 23: What happens if you attempt to run the Descriptive Stati…

Question 23

+1 markOne correct option

What happens if you attempt to run the Descriptive Statistics tool on a range that includes embedded text strings inside the data body?

  1. A

    Excel replaces all text cells with zero values and computes the summary stats.

  2. B

    Excel returns an alert stating, 'Descriptive statistics: Input range contains non- numeric data.'

  3. C

    Excel converts text values to their corresponding ASCII numerical values.

  4. D

    Excel ignores all text cells and calculates statistics using only numeric cells.

Show answer

Correct answer

  • B

    Excel returns an alert stating, 'Descriptive statistics: Input range contains non- numeric data.'

See the whole paperTake it as a mock test

Question 23 of 43 in the IIT Madras BS Business Data Management (BDM) End Term paper sat on 13 Sept 2026, in the May 2026 term (Business Data Management 13 Sep 26 (Session 2)). It carries 1 mark.

More questions from this paper

  1. Q1Case Background: The Sivasagar, Assam Flood Economic Shock The severe floods that struck the Sivasagar and neighboring …
  2. Q2Case Background: The Sivasagar, Assam Flood Economic Shock The severe floods that struck the Sivasagar and neighboring …
  3. Q3Case Background: The Sivasagar, Assam Flood Economic Shock The severe floods that struck the Sivasagar and neighboring …
  4. Q4Case Background: The Sivasagar, Assam Flood Economic Shock The severe floods that struck the Sivasagar and neighboring …
  5. Q5Swiggy offers discounts to its customers based on their previous order records. Under which branch of economics does th…
  6. Q6Based on the graph below, what does a vertical supply curve indicate about the responsiveness of sellers to price chang…
  7. Q7During Lionel Messi’s tour of India, physical stadium seating was strictly capped, so organizers sold digital streaming…
  8. Q8A business delivers a product to a customer in October, but the customer does not pay until December. Under the Revenue…
  9. Q9A business pays ₹15,000 for a utility bill that was recorded as a liability in the previous month. What is the impact o…
  10. Q10A stock has a Market Price of ₹500 and an Earnings Per Share (EPS) of ₹50. What does the resulting P/E ratio of 10 indi…
  11. Q11If a company has a healthy Gross Profit but a low Net Profit, what does this indicate to management?
  12. Q12When customers are unable to gauge the service quality, even post feeling them, they tend to be rich in
  13. Q13Which of the following are characteristics of B2B markets?
  14. Q14In what phase of the 7 steps of selling process, the openers are used?
  15. Q15Indigo had a lot of cancellations during December 2025 last year. The customers were also not given any information on …
  16. Q16Ravi's Lemonade Stand sells 60 glasses a day on average for the month of June (30 days) at 10 each. Daily operating exp…
  17. Q17A company reports a Net Income of ₹172,500. To calculate 'Net Cash from Operating Activities', the accountant adds back…
  18. Q18Maya performed ₹60,000 of services on credit. During the same month, she paid ₹15,000 for rent, ₹5,000 for supplies, an…
  19. Q19If a firm has total sales of Rs 25,00,000 and its Profit After Tax (PAT) is Rs 3,75,000, what is the Net Profit Margin?
  20. Q20If a company pays an annual dividend of Rs 5 per share and the current market price of the stock is Rs 200, what is the…
  21. Q21Which character must always be entered first in a cell to begin a formula or function in Excel?
  22. Q22Which keyboard shortcut triggers Excel's Flash Fill feature to automatically complete data patterns in adjacent cells?
  23. Q24If a company issues a share with a face value of ₹20 at a price of ₹60, where is the extra ₹40 recorded?
  24. Q25Targeting is done using a process referred to as “BANT”. The “A” here refers to
  25. Q26A business starts the month with an opening inventory of 200 units at ₹10 each. During the month, it purchases 300 unit…
  26. Q27A manufacturing concern reports opening raw material inventory of ₹ 60,000, purchases of 5,20,000, and a closing invent…
  27. Q28A firm has Current Liabilities of ₹50,000. Its Current Ratio is 2.0:1 and its Quick Ratio is 1.2:1. Based on these figu…
  28. Q29Their decided to start with prospecting. Which aspect of prospecting should their marketing team majorly focus on
  29. Q30Following the completion of prospecting process, their marketing department identified 150 potential B2B customers. Wha…
  30. Q31They decided to do a BANT. The process of prospecting gave them a total of 150 customers. Of this 20% customers did not…
  31. Q32Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  32. Q33Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  33. Q34Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  34. Q35Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  35. Q36Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  36. Q37Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  37. Q38Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  38. Q39Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  39. Q40Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  40. Q41Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  41. Q42Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …
  42. Q43Case Study\ XYZ Tech Manufacturing is a mid-sized company specializing in the production of electronic components. The …