Computer Science Study Guide: Advanced Excel Course Logical Function Notes Set 01
Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Logical Function Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.
Download MS Office Study Material PDF
Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.
The logical functions OR, AND and IF are used on sales and result sheets in this page: a bonus percentage worked out with OR, a second percentage worked out with AND, and a PASS or FAIL result worked out with IF on the total marks.
OR
OR returns TRUE if any one of its conditions is true. Together with IF it decides a bonus. The employee sheet has the columns Employee Name, Mouse Sale, Keyboard Sale, Router Sale, Hub Sale and Bonus [OR].
=IF(OR(B2>=5000,C2>=5000,D2>=5000,E2>=5000),"45%","Not Bonus")
1. 45 %: any one sales amount is greater than or equal to 5000.
2. Not Bonus: all the sales amounts are less than 5000.
| Employee Name | Mouse Sale | Keyboard Sale | Router Sale | Hub Sale | Bonus [OR] |
|---|---|---|---|---|---|
| Zafar Abbas | 4000 | 5000 | 5000 | 500 | 45% |
| Ananaya | 1000 | 1000 | 2000 | 6000 | 45% |
| Shaayla Zehra | 7000 | 9000 | 8000 | 1000 | 45% |
| Candy | 1000 | 2000 | 1000 | 1000 | Not Bonus |
| Shelena | 5000 | 2000 | 3000 | 1000 | 45% |
| Amit Kumar | 2000 | 3000 | 1000 | 2000 | Not Bonus |
| Praveen Kumar | 6000 | 4000 | 7000 | 1000 | 45% |
| Amisha Singh | 9000 | 2000 | 2000 | 3000 | 45% |
| Dennis John | 1000 | 1000 | 2000 | 1000 | Not Bonus |
| Rey Mysterio | 5000 | 2000 | 1000 | 3000 | 45% |
AND
AND returns TRUE only if all its conditions are true. The sheet has the columns Employee Name, Application Software Sale, System Software Sale, Windows 7 Sale, Windows 10 Sale and Bonus [AND].
=IF(AND(B2>=12000,C2>=12000,D2>=12000,E2>=12000),"52%","12%")
1. 52 %: all the sales amounts are greater than or equal to 12000.
2. 12 %: any one (or all) of the sales amounts is less than 12000.
| Employee Name | Application Software Sale | System Software Sale | Windows 7 Sale | Windows 10 Sale | Bonus [AND] |
|---|---|---|---|---|---|
| Dennis John | 12000 | 14000 | 20000 | 12000 | 52% |
| Ananaya | 25000 | 11000 | 22000 | 14000 | 12% |
| Shaayla Zehra | 12000 | 32000 | 10000 | 20000 | 12% |
| Ankit Kumar | 50000 | 20000 | 13000 | 25000 | 52% |
| Shelena | 11000 | 23000 | 12000 | 20000 | 12% |
| Amit Kumar | 25000 | 32000 | 20000 | 11000 | 12% |
| Candy | 15000 | 32000 | 14000 | 25000 | 52% |
| Amisha Singh | 9000 | 5000 | 4000 | 50000 | 12% |
| Zafar Abbas | 16000 | 12000 | 14000 | 20000 | 52% |
| Rey Mysterio | 8000 | 9000 | 10000 | 11000 | 12% |
IF
IF chooses between two results. The Results sheet has the marks of ten students in Hindi, English, Computer, Maths, Science and Accountancy, followed by the columns Total, Max, Min, Average and Result (IF). The student passes if the total is above 300 and fails if it is below 300.
=IF(H4>300,"PASS","FAIL")
| Student Names | Hindi | English | Computer | Maths | Science | Accountancy | Total | Max | Min | Average | Result (IF) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Zainab Rizvi | 78 | 84 | 58 | 49 | 78 | 89 | 436 | 89 | 49 | 72.7 | PASS |
| Amit Tyagi | 71 | 41 | 45 | 25 | 22 | 49 | 253 | 71 | 22 | 42.2 | FAIL |
| Shahid Kapoor | 78 | 43 | 54 | 65 | 32 | 79 | 351 | 79 | 32 | 58.5 | PASS |
| Dennis Ritchie | 96 | 49 | 62 | 45 | 42 | 56 | 350 | 96 | 42 | 58.3 | PASS |
| Nusbeeha Naqvi | 56 | 65 | 84 | 89 | 23 | 58 | 375 | 89 | 23 | 62.5 | PASS |
| James Thomas | 51 | 74 | 56 | 54 | 28 | 30 | 293 | 74 | 28 | 48.8 | FAIL |
| Eli Christian | 63 | 54 | 74 | 55 | 35 | 62 | 343 | 74 | 35 | 57.2 | PASS |
| Jameson | 56 | 42 | 21 | 23 | 35 | 78 | 255 | 78 | 21 | 42.5 | FAIL |
| Ravi Kumar | 65 | 53 | 23 | 23 | 62 | 56 | 282 | 65 | 23 | 47.0 | FAIL |
| Shivi Singh | 79 | 42 | 80 | 84 | 78 | 67 | 430 | 84 | 42 | 71.7 | PASS |
Free study material for Computer Science
CBSE Computer Science Study Material: MS Office
Core Study Kit: Computer Science MS Office
Access comprehensive study material for MS Office, including revision notes, concept maps, and high-probability questions. These resources are designed in alignment with the latest 2026 CBSE syllabus for Computer Science to support effective exam preparation.
NCERT-Aligned Solutions for MS Office
Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within MS Office and demystifies standard marking schemes for Computer Science evaluations.
Next Steps in Your Exam Preparation
For peak performance in upcoming evaluations, integrate official Computer Science sample papers directly into your study schedule. Follow up your revision by attempting online MCQ tests for MS Office to refine calculation speed and precision.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.