ICT · Information and Communication Technology (ICT)
In the following MS-EXCEL spreadsheet, a list of 100 customers is given. Column 'A' represents their names, 'B' is for customer category, 'C' for payment category (0 means discounted price and 1 means full price), and 'D' indicates the price that the customer pays. The sample spreadsheet below simply shows different categories. Sheet Structure: Row 1: Customer Name (A) | Customer Category (B) | Payment category (C) | Price (D) Row 2: Raman | Child | 0 | 0 Row 3: Dinesh | Adult | 1 | 5 Row 4: Jashan | Adult | 0 | 2 ... Row 101: Amit | Child | 0 | 0 Which of the following formulas correctly counts all customers who are adults and get a discounted price?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1=COUNTIFS(B2:B101, "=0", C2:C101, "=Adult")
- 2=COUNTIFS(B2:B101, "=Adult", C2:C101, "=0")✓
- 3=COUNTIF(B2:B101, =Adult, C2:C101, "=0")
- 4=COUNTIF(B2:B101, "=Adult", C2:C101, "=0")
Correct answer
=COUNTIFS(B2:B101, "=Adult", C2:C101, "=0")
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for ICT?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Information and Communication Technology (ICT) MCQs →Want more practice questions on Information and Communication Technology (ICT)?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in ICT · Information and Communication Technology (ICT)