Instructions Below are three questions on conversions, taken directly from the previous quiz. In the Excel sheet provided, complete the following: 1. Set up fraction values (numerator and denominator) required for the fractions. Separate the number from the units in separate cells, as demonstrated in Assignment 5. Make sure it is clear what information in in each cell. 2. Draw lines to indicate borders for fractions. 3. Using the appropriate cell references, provide the Excel formula to calculate the conversion. You do not need to calculate the result - just provide the Excel formula. Question 1 - Shots of Whiskey Gary purchased a nice 750 ml bottle of Irish Whisky, His shot glass contains 1.5 fluid Ounces. How many shots can Gary down before he needs to purchase another bottle? a B C D E F G H O 1 Q CY 1 2 3 4 5 6 8 9 10 D'ai 2 Question 4 - Dean's Drive to York Sometime between May and August, Dean will be moving from Greeley to York, PA, home of the York Peppermint Patty. Google indicates the drive is 1637 miles. Dean's car gets 32 miles per gallon on the highway, and due to rising fuel prices, assume gasoline will cost $4.89 per gallon. How much will Dean spend on fuel on his upcoming trip? N o M Q B D K E F G 1 H 1 2 3 4 5 6 7 8 9 10 Question 5 - Usain, the Man, the Legend Usain Bolt is a retired Jamaican springer, widely considered to be the greatest sprinter of all time. In 2009, he ran the 100-meter race in 9.58 seconds. What would be Usain's speed in miles per hour? C D OP Q B E N M F G K H 1 2 3 4 5 6 7 B 9 10 Instructions Below are three questions on conversions, taken directly from the previous quiz. In the Excel sheet provided, complete the following: 1. Set up fraction values (numerator and denominator) required for the fractions. Separate the number from the units in separate cells, as demonstrated in Assignment 5. Make sure it is clear what information in in each cell. 2. Draw lines to indicate borders for fractions. 3. Using the appropriate cell references, provide the Excel formula to calculate the conversion. You do not need to calculate the result - just provide the Excel formula. Question 1 - Shots of Whiskey Gary purchased a nice 750 ml bottle of Irish Whisky, His shot glass contains 1.5 fluid Ounces. How many shots can Gary down before he needs to purchase another bottle? a B C D E F G H O 1 Q CY 1 2 3 4 5 6 8 9 10 D'ai 2 Question 4 - Dean's Drive to York Sometime between May and August, Dean will be moving from Greeley to York, PA, home of the York Peppermint Patty. Google indicates the drive is 1637 miles. Dean's car gets 32 miles per gallon on the highway, and due to rising fuel prices, assume gasoline will cost $4.89 per gallon. How much will Dean spend on fuel on his upcoming trip? N o M Q B D K E F G 1 H 1 2 3 4 5 6 7 8 9 10 Question 5 - Usain, the Man, the Legend Usain Bolt is a retired Jamaican springer, widely considered to be the greatest sprinter of all time. In 2009, he ran the 100-meter race in 9.58 seconds. What would be Usain's speed in miles per hour? C D OP Q B E N M F G K H 1 2 3 4 5 6 7 B 9 10
