Excel Question: AND, OR functions using arrays?

Just use siti Vi's example and the confusion should be removed from the use of this function. It is a good example.