In cell c5, enter a formula that uses a nested if function to calculate the bonus. if sales in b5 are less $15,000, the sales person earns a 5% bonus. if the sales are greater than or equal to $15,000 but less than $25,000, the sales person earns a 10% bonus. if sales are more than or equal to $25,000, the sales person earns a 15% bonus.

Multiple choice project create a program with two multiple choice questions. 1. users have two attempts only, show attempt number each time. hint: while loop with break control. (20%) 2. only one correct answer for each question, use switch case for each question. (20%) 3. show total score after the two questions are answered. hint: . (20%) 4. user have options to answer the two questions again if first attempt score is not 100%. hint: if statment. (20%) 5. use string method .toupper() to allow users to enter with lowercase or uppercase letters. (20%) 1. where is the capital of the state of florida? a. orlando b. tallahassee c. miami d. tampa b 2. where is walt disney world park located in florida? a. orlando b. tallahassee c. miami d. tampa a