Advanced IFs – Practice!
Practice Exercise Summary
0 of 2 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Results
0 of 2 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- Current
- Review / Skip
- Answered
- Correct
- Incorrect
- Question 1 of 2
1. Question
You run a Midwestern-based e-commerce business and have a table of your transactions for the month:
Given the above list of transactions and what states they occured in, determine the state tax rate applied based on the table on the right.
Some transactions occurred in states that are outside your typical Midwestern territory. In these cases, display “UNKNOWN” for the state tax rate applied.
CorrectIncorrect - Question 2 of 2
2. Question
Imagine that you run a basketball team and want to create incentives based on their play. You have the following conditions going into your upcoming game (and their designated outputs), in order of importance:
- If John scores more than 12 points, everyone gets ice cream >>> “ICE CREAM”
- If Steve and Mary combine for at least 8 points, the team won’t practice Friday >>> “NO PRACTICE”
- If Sarah scores above 25 points, she gets a medal >>> “MEDAL”
Considering the following stat line for the game, write an IFS function to determine what reward (if any) the team will receive.
CorrectIncorrect