You are in charge of the cattle breeding operation at your farm. You are breeding 25 first calf heifers and 25 cows-all Hereford influenced commercial crossbreds 84 -2.7 Bull A B D U I ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 BW 1.3 2.4 2.5 -0.2 1.1 -2.7 -0.1 0.1 1.4 -1.1 1.5 2 -0.7 1 1.1 -0.6 1.3 1.7 -1.8 2.2 ww 82 55 52 68 70 51 54 66 77 57 80 62 67 50 67 84 73 71 60 44 YW 145 102 135 144 170 162 128 158 114 142 172 160 156 124 133 178 168 121 135 145 CED 14 17 16 12 15 7 14 8 9 12 9 16 11 14 4 6 10 13 11 16 CW 77 59 68 34 45 46 55 50 62 42 68 76 58 80 48 40 56 62 44 38 K L M N S T 1. In cell 13 write a formula that will tell us the numerical value of the highest weaning weight (WW) bull. 2. In cell 14 write a formula that will give us the numerical value of the bull with the lowest birth weight (BW) 3. Name the range in cells A4:G23 Lookup1, name the range in cells D4 through D23 WW, name the range in cells C4 through C23 BW. 4. In cells 15 and 15 write a formula(s) that will tell us which row has the bull with the highest carcass weight (CW). 5. In cell K5 write a formula that will tell you the name/letter of the bull with the highest carcass weight (CW) 6. In cell 16 use the INDEX function to tell us the yearling weight (YW) of Bull P 7. In cells M4:M23 write a formula (and copy it down) that will lookup calving ease (CED) on all bulls 8. In cell G24 write a formula that will show the average carcass weight (CW) of all the bulls 9. In cell H8 through L8 write a formula(s) that will find the bulls with the highest WW and rank them 1st through 5th 10. In cells H9 through L9 write a formula that would find the rows in which those bulls from previous question are located. 11: In cells H10 through L10 write a formula that would take the row location from the above question and lookup which bull it is referring to 12. In cell H11 through L11 write a formula(s) that will find the bulls with the lowest BW and rank them 1st through 5th 13. In cells H12 through L12 write a formula that will find the rows in which those bulls from the previous question are located 14. In cells H13 through L13 write a formula that would take the row location from the above question and lookup which bull it is referring to 15. Using the results from questions 9-14, what is the bull you would use if you were looking for the lowest BW and the highest WW? You are in charge of the cattle breeding operation at your farm. You are breeding 25 first calf heifers and 25 cows-all Hereford influenced commercial crossbreds 84 -2.7 Bull A B D U I ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 BW 1.3 2.4 2.5 -0.2 1.1 -2.7 -0.1 0.1 1.4 -1.1 1.5 2 -0.7 1 1.1 -0.6 1.3 1.7 -1.8 2.2 ww 82 55 52 68 70 51 54 66 77 57 80 62 67 50 67 84 73 71 60 44 YW 145 102 135 144 170 162 128 158 114 142 172 160 156 124 133 178 168 121 135 145 CED 14 17 16 12 15 7 14 8 9 12 9 16 11 14 4 6 10 13 11 16 CW 77 59 68 34 45 46 55 50 62 42 68 76 58 80 48 40 56 62 44 38 K L M N S T 1. In cell 13 write a formula that will tell us the numerical value of the highest weaning weight (WW) bull. 2. In cell 14 write a formula that will give us the numerical value of the bull with the lowest birth weight (BW) 3. Name the range in cells A4:G23 Lookup1, name the range in cells D4 through D23 WW, name the range in cells C4 through C23 BW. 4. In cells 15 and 15 write a formula(s) that will tell us which row has the bull with the highest carcass weight (CW). 5. In cell K5 write a formula that will tell you the name/letter of the bull with the highest carcass weight (CW) 6. In cell 16 use the INDEX function to tell us the yearling weight (YW) of Bull P 7. In cells M4:M23 write a formula (and copy it down) that will lookup calving ease (CED) on all bulls 8. In cell G24 write a formula that will show the average carcass weight (CW) of all the bulls 9. In cell H8 through L8 write a formula(s) that will find the bulls with the highest WW and rank them 1st through 5th 10. In cells H9 through L9 write a formula that would find the rows in which those bulls from previous question are located. 11: In cells H10 through L10 write a formula that would take the row location from the above question and lookup which bull it is referring to 12. In cell H11 through L11 write a formula(s) that will find the bulls with the lowest BW and rank them 1st through 5th 13. In cells H12 through L12 write a formula that will find the rows in which those bulls from the previous question are located 14. In cells H13 through L13 write a formula that would take the row location from the above question and lookup which bull it is referring to 15. Using the results from questions 9-14, what is the bull you would use if you were looking for the lowest BW and the highest WW
