Question: A B C D E F G H I J Instructions: The ages of Sue, Jimmy, and Linda are listed in cells B5, C5, and

 A B C D E F G H I J Instructions:

A B C D E F G H I J Instructions: The ages of Sue, Jimmy, and Linda are listed in cells B5, C5, and D5, respectively. Write formulas (in cells B8:B20) that will evaluate each condition stated below to a boolean value (i.e., TRUE or FALSE). As an example, the solution to the first condition has been completed for you. Note that each conditon is independent of any of the others. Also note that, for some of the statements below, there may be various formulas that can be used to solve the condition; however, you need only to provide one of them. Sue 30 Jimmy 42 Linda 39 Answers TRUE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE FALSE 14 TRUE Sue is at least 30 years old. FALSE Jimmy is not more than 40 years old. FALSE Linda is at most 35 years old. FALSE Both Sue and Jimmy are under 36. TRUE Linda is between 30 and 40 (inclusive). At least one person (of the three) is over 40. XXX No one is over 45 years old. XXX Jimmy and Sue are under 40, but Linda is not. XXX Sue is the oldest XXX Sue is not the oldest. XXX Sue, Jimmy, and Linda are all different ages. XXX Linda is the oldest and Jimmy is the youngest. | 2 points Jimmy is the second oldest. 19

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!