Question
Download Solution PDFIn the following MS-Excel spreadsheet, you are given a list of 100 customers. Column 'A' represents their names. 'B' is for customer category, 'C' for payment category (0 means discounted price and 1 means full price). 'D' indicates price that customer pays. The example spreadsheet below is not the actual list and simply shows different categories.
|
|
A |
B |
C |
D |
|
1 |
Customer Name |
Customer Category |
Payment Category |
Price (Rs.) |
|
2 |
Raman |
Child |
0 |
0 |
|
3 |
Dinesh |
Adult |
1 |
5 |
|
4 |
Jashan |
Adult |
0 |
2 |
|
|
|
|
: |
|
|
101 |
Amit |
Child |
0 |
0 |
:
:
Which of the following formula would indicate the total amount paid by customers who are adults but do not get discounted price?
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFSUMIFS formula:
- The SUMIFS formula is used to calculate the total amount of cells that meet multiple criteria.
- In this case, we want to calculate the total amount of cells that are for adult customers who have not paid the discounted price.
The formula can be understood as follows:
- SUMIFS - A function that calculates the total amount of cells that meet multiple criteria.
- D2:D101 - The range in which we want to calculate the total amount.
- B2:B101 - The range that includes the customer category.
- "=Adult" - The condition that we want to apply to the customer category.
- C2:C101 - The range that includes the payment category.
- "=1" - The condition that we want to apply to the payment category.
As a result, the formula SUMIFS(D2:D101, B2:B101, "=Adult", C2:C101, "=1") will calculate the total amount paid by adult customers who have not paid the discounted price.
The correct answer is 4) =SUMIFS(D2:D101, B2:B101, "=Adult", C2:C101, "=1").
Last updated on Jun 12, 2025
-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.
-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.
-> The exam is conducted bi-annually - in June and December cycles.
-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions.
-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.