1.
How does the AND function behave in Excel?
2.
Which logical function in Excel will return TRUE if at least one condition is TRUE?
3.
In Excel, which logical operator is used to check if two conditions are both TRUE?
4.
Which function is used in Excel to check if a condition is TRUE or FALSE?
5.
Which of the following Excel functions can be used to check if any condition is TRUE?
6.
When using nested IF functions in Excel, how should the formula be constructed?
7.
In an IF function, what does the 'FALSE' argument represent?
8.
If the condition in an IF function is TRUE, what is returned?
9.
What is the purpose of nesting the IF function in Excel?
10.
Which function can be used in Excel as an alternative to nested IFs when there are many conditions?