In an MS-Excel spreadsheet containing a customer database from row 2 to 101, column 'C' contains the payment category where '0' represents discounted price and '1' represents full price. Consider the following two statements: Statement I: The formula =COUNTIFS(C2:C101, '0') counts all customers who get a discounted price. Statement II: The formula =COUNTIF(C2:C101, '=0') counts all customers who get a discounted price. In the light of the above statements, choose the correct answer from the options given below:

Question

Teaching Aptitude · General Paper

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

Both Statement I and Statement II are true

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on General Paper?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Teaching Aptitude · General Paper

Mahatma Gandhi's last fast unto death in 1948 was primarily against which of the following?

What was the primary meaning of 'Swaraj' as popularized by Mahatma Gandhi during India's independence movement?

What was one major impact of India’s independence on its economy?

Answer 1

Both Statement I and Statement II are true

Answer 2

Both Statement I and Statement II are false

Answer 3

Statement I is true but Statement II is false

Answer 4

Statement I is false but Statement II is true

Related Practice Questions