1

2

3.

Which of the following are true with respect to the AND function? Check all that apply. The output of the function will be FALSE only if all of the logical tests are false. The function can be used to define the logical_test argument of the IF function. The output of the function will be TRUE if only one of the logical tests is true. The arguments of the function are defined with logical tests. The output of the function will be FALSE if one of the logical tests is false. The output of the function will be TRUE only if all logical tests are true. The value in cell E10 on an Excel worksheet contains the amount of profits earned from an investment. A nested IF function will be entered into cell F10 to evaluate the value in cell E10. If the value in cell E10 is less than zero, the output of the function should be the word HOLD. If the value in cell E10 is greater than or equal to zero but less than 100, the output of the function should be the word SELL. Any value greater than or equal to 100 , the output of the function should be the word BUY. Which of the following nested IF functions will produce an accurate output based on the information provided? =IF(E10100,"BUY",IF(E10=100,"BUY",IF(E10=100,"BUY",=IF(E10