Delhi Police Constable 4 Jan 2026 Shift 2 Paper

Concept:The AND function in Excel checks multiple conditions at once. It returns TRUE only when every condition is satisfied.Explanation:First, enter the conditions inside the AND function, separated by commas.For example: =AND(A1>5, B1<10) tests if both A1>5 and B1<10 are true.If all conditions are true, the function returns TRUE.If any one condition is false, it returns FALSE.This function stops checking at the first false condition it finds.It is often used with IF for decision-making: =IF(AND(condition1, condition2), "Yes", "No").AND can handle up to 255 conditions in newer Excel versions.It is case‑insensitive and returns only TRUE or FALSE.Answer:Option A: Returns TRUE if all conditions are true, and FALSE if any condition is false.