B D E F G Targets Probation (in years) Performance General Opinion 5 6 G Bonus Do not edit this cell! "Bonus Multi" Employee Probation Years Remaining Bonus Performance (0 to 10) 6 7 Years Worked 5 3 7 Bob Carol Ted Alice General Opinion (G or B) G G B 4 4 6 B What if Vlookup IF Multiple Worksheets North South East West Bonus Quest -- Use the IF worksheet to answer the following questions. *** NOTE: The BonusMulti cell provided has been obscured so that you cannot see the values it contains. USE THE NAME PROVIDED in your formulas. The name refers to the red outlined cell indicated. Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? O A) 1 year B) 2 years K Question 12 (3 points) In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see if the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. . Once done, use the Scenario tool to select the Dataset 2 scenario. What is Alice's bonus? A) $247.50 B) $252.78 C) $299.92 DI PIU.UJ Question 13(1 point) In Column E (General Opinion) something was done to ensure that the cell values make sense. What was done to these cells? O A) Data Validation was used to ensure that the user types in a single letter (text length of 1 character) B) Bob the gremlin was hired to ever-so-slightly annoy, by a precise application of "wet willies", anyone who tries to change these cells. C) Worksheet Protection was applied to keep users from changing these cells. D) Data Validation was used to limit the values to a list, containing only G and B Que E B E Letto Data Analysis ? Solver F4 Advanced Data Types Columns - Sort & Filter f What Forecast Outline Analysis. She Forest VLOOKUP UEHH Data Tools A B Anarze C VLOOKUP lookup_value, table array, colindes num (range Jookup 2 F G H 3 Targets Probation (in years) Performance General Opinion 5 4 6 5 6 G 7 Bonus 8 Do not edit this cell! "Bonus Multi 9 10 Employee 11 12 13 14 15 16 Bonus Bob Carol Ted Alice Years Worked 5 3 7 4 Performance (0 to 10) 6 7 General Opinion Probation Years (G or B) Remaining G G B B 4 6 > What Vleak up IF Multiple Worksheets North South East West Sint Bonus Quest Type here to search BI e hp Part 3 - IF Logic Use the IF worksheet to answer the following questions. *** NOTE: The BonusMulti cell provided has been obscured so that you cannot see the values it contains. USE THE NAME PROVIDED in your formulas. The name refers to the red outlined cell indicated. Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? OA) 1 year B) 2 years C) Past D) 3 years Question 12 (3 points) In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see IF the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. Once done, use the Scenario tool to select the Dataset 2 scenario. What is Alice's bonus? A) $247.50 B) $252.78 WC) $299.92 ORI e hp D) $270.85 Question 13 (1 point) In Column E (General Opinion) something was done to ensure that the cell values make sense. What was done to these cells? A) Data Validation was used to ensure that the user types in a single letter (text length of 1 character) B) Bob the gremlin was hired to ever-so-slightly annoy, by a precise application of "wet willies", anyone who tries to change these cells. c) Worksheet Protection was applied to keep users from changing these cells. DD) Data Validation was used to limit the values to a list, containing only G and B B D E F G Targets Probation (in years) Performance General Opinion 5 6 G Bonus Do not edit this cell! "Bonus Multi" Employee Probation Years Remaining Bonus Performance (0 to 10) 6 7 Years Worked 5 3 7 Bob Carol Ted Alice General Opinion (G or B) G G B 4 4 6 B What if Vlookup IF Multiple Worksheets North South East West Bonus Quest -- Use the IF worksheet to answer the following questions. *** NOTE: The BonusMulti cell provided has been obscured so that you cannot see the values it contains. USE THE NAME PROVIDED in your formulas. The name refers to the red outlined cell indicated. Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? O A) 1 year B) 2 years K Question 12 (3 points) In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see if the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. . Once done, use the Scenario tool to select the Dataset 2 scenario. What is Alice's bonus? A) $247.50 B) $252.78 C) $299.92 DI PIU.UJ Question 13(1 point) In Column E (General Opinion) something was done to ensure that the cell values make sense. What was done to these cells? O A) Data Validation was used to ensure that the user types in a single letter (text length of 1 character) B) Bob the gremlin was hired to ever-so-slightly annoy, by a precise application of "wet willies", anyone who tries to change these cells. C) Worksheet Protection was applied to keep users from changing these cells. D) Data Validation was used to limit the values to a list, containing only G and B Que E B E Letto Data Analysis ? Solver F4 Advanced Data Types Columns - Sort & Filter f What Forecast Outline Analysis. She Forest VLOOKUP UEHH Data Tools A B Anarze C VLOOKUP lookup_value, table array, colindes num (range Jookup 2 F G H 3 Targets Probation (in years) Performance General Opinion 5 4 6 5 6 G 7 Bonus 8 Do not edit this cell! "Bonus Multi 9 10 Employee 11 12 13 14 15 16 Bonus Bob Carol Ted Alice Years Worked 5 3 7 4 Performance (0 to 10) 6 7 General Opinion Probation Years (G or B) Remaining G G B B 4 6 > What Vleak up IF Multiple Worksheets North South East West Sint Bonus Quest Type here to search BI e hp Part 3 - IF Logic Use the IF worksheet to answer the following questions. *** NOTE: The BonusMulti cell provided has been obscured so that you cannot see the values it contains. USE THE NAME PROVIDED in your formulas. The name refers to the red outlined cell indicated. Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? Question 11 (2 points) In Column F (Probation Years Remaining), enter a formula that will compare the employees' Years Worked against the Target Probation (in years) value. This formula should return "Past" if Years Worked is greater than or equal to the Probation target, and otherwise show the number of years remaining. Use the Scenario tools to show the Dataset 1 scenario. What is Carol's Probation Years Remaining value? OA) 1 year B) 2 years C) Past D) 3 years Question 12 (3 points) In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see IF the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. Once done, use the Scenario tool to select the Dataset 2 scenario. What is Alice's bonus? A) $247.50 B) $252.78 WC) $299.92 ORI e hp D) $270.85 Question 13 (1 point) In Column E (General Opinion) something was done to ensure that the cell values make sense. What was done to these cells? A) Data Validation was used to ensure that the user types in a single letter (text length of 1 character) B) Bob the gremlin was hired to ever-so-slightly annoy, by a precise application of "wet willies", anyone who tries to change these cells. c) Worksheet Protection was applied to keep users from changing these cells. DD) Data Validation was used to limit the values to a list, containing only G and B