Advanced Excel Course Logical Function Notes Set 01

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 NameMouse SaleKeyboard SaleRouter SaleHub SaleBonus [OR]
Zafar Abbas40005000500050045%
Ananaya100010002000600045%
Shaayla Zehra700090008000100045%
Candy1000200010001000Not Bonus
Shelena500020003000100045%
Amit Kumar2000300010002000Not Bonus
Praveen Kumar600040007000100045%
Amisha Singh900020002000300045%
Dennis John1000100020001000Not Bonus
Rey Mysterio500020001000300045%

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 NameApplication Software SaleSystem Software SaleWindows 7 SaleWindows 10 SaleBonus [AND]
Dennis John1200014000200001200052%
Ananaya2500011000220001400012%
Shaayla Zehra1200032000100002000012%
Ankit Kumar5000020000130002500052%
Shelena1100023000120002000012%
Amit Kumar2500032000200001100012%
Candy1500032000140002500052%
Amisha Singh9000500040005000012%
Zafar Abbas1600012000140002000052%
Rey Mysterio80009000100001100012%

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 NamesHindiEnglishComputerMathsScienceAccountancyTotalMaxMinAverageResult (IF)
Zainab Rizvi788458497889436894972.7PASS
Amit Tyagi714145252249253712242.2FAIL
Shahid Kapoor784354653279351793258.5PASS
Dennis Ritchie964962454256350964258.3PASS
Nusbeeha Naqvi566584892358375892362.5PASS
James Thomas517456542830293742848.8FAIL
Eli Christian635474553562343743557.2PASS
Jameson564221233578255782142.5FAIL
Ravi Kumar655323236256282652347.0FAIL
Shivi Singh794280847867430844271.7PASS

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

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

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.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

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.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

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.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

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.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

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.