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.
I would suggest Absolute reference in 13:30 for the calculation of percentage
Hafiz Muhammad Talha
kindly share your slides for revision
Sohel Khalid Nadaf
How to get dataset
I am looking for this course in Telugu language, Is there any possibilities in Telugu.
Nitesh kumar gupta
nice course all the video explained very well from scratch to advance
Overall Lectures are good but also provide the practicing spreadsheets for students.