Course Content

Course Content


We use logical operators because we occasionally want to combine numerous comparisons in a conditional expression. In our programmes, we can say things like "if both X and Y are true" or "if either X or Y are true."

Example. "If today is Wednesday, then yesterday was Tuesday," says the conditional statement. Hypothesis: "If today is Wednesday," then "yesterday was Tuesday," we must conclude.

AND, OR, and NOT are logical operators that are utilised to conduct logical operations. AND, OR, XOR, and NOT are examples of Boolean Operators, which can have one of two values: true or false.

In the Sort & Filter group, select the Filter tool. A drop-down arrow appears adjacent to the column headings in Excel. Next to the title of the column containing your Boolean values, click the drop-down arrow. A selection of possibilities will appear, including a checklist of all the values in the column.

Instead of using a calculator, do the arithmetic with Microsoft Excel! Simple formulas can be entered to add, divide, multiply, or subtract two or more numeric numbers. Alternatively, you may use the AutoSum tool to instantly total a set of values without having to manually enter them into a formula.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere