Question
Download Solution PDFMS-EXCEL वर्कशीट के निम्नलिखित स्नैपशॉट पर विचार करें:
| A | B | C | D | |
| 1 | Roll Number | Test Marks-1 | Test Marks-2 | Total marks |
| 2 | 201 | 80 | 60 | 140 |
| 3 | 202 | 70 | 50 | 120 |
| 4 | 203 | 40 | 30 | 70 |
| 5 | 204 | 30 | 32 | 62 |
| 6 | 205 | 85 | 85 | 170 |
| 7 | 206 | 65 | 80 | 145 |
| 8 | 207 | 72 | 96 | 168 |
| 9 | 208 | 25 | 32 | 57 |
| 10 | 209 | 90 | 78 | 168 |
| 11 | 210 | 25 | 40 | 65 |
| 12 |
सूत्र = SUMIF(B2 ∶ B11,"<50", D2 ∶ D11) सेल D12 में परिणाम होगा
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFविस्तार:
- सेल D12 में सूत्र = SUMIF(B2:B11, "<50", D2:D11) उन सभी छात्रों के कुल अंकों को जोड़ देगा जिनके (परीक्षा अंक-1) 50 से कम हैं।
- दिए गए वर्कशीट में, रोल नंबर 203, 204, 208 और 210 वाले छात्रों के लिए (परीक्षण अंक -1) 50 से कम हैं, और उनके संबंधित कुल अंक क्रमशः 70, 62, 57 और 65 हैं।
इसलिए, सूत्र का मूल्यांकन होगा:
=SUMIF(B2:B11, "<50", D2:D11) = SUMIF(B2:B11, "<50", 70, 62, 0, 0, 0, 0, 0, 57, 0, 65) = 254
Last updated on Jun 19, 2025
-> The UGC NET City Slip 2025 has been released on its official website today.
-> 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.