1. Provide an example of how an in-depth analysis of data may lead to a competitive...

Transcribed Image Text:

1. Provide an example of how an in-depth analysis of data may lead to a competitive advantage. 2. Describe three types of data inputs that can be used for arguments within an IF function. 3. Explain how a decision tree can help you write a nested IF function. 4. Explain how the limitation that an IF function only allows for one logical test can be overcome. 5. Develop a T-chart for the following situation: The result $5,000 is displayed for an employee who has been with the company for 5 years or more and has generated at least $20,000 in revenue or has been with the company for 3 years or more and has generated at least $15,000 in revenue. Otherwise, the result displayed is $0.00. 1. Provide an example of how an in-depth analysis of data may lead to a competitive advantage. 2. Describe three types of data inputs that can be used for arguments within an IF function. 3. Explain how a decision tree can help you write a nested IF function. 4. Explain how the limitation that an IF function only allows for one logical test can be overcome. 5. Develop a T-chart for the following situation: The result $5,000 is displayed for an employee who has been with the company for 5 years or more and has generated at least $20,000 in revenue or has been with the company for 3 years or more and has generated at least $15,000 in revenue. Otherwise, the result displayed is $0.00.