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