A B C D E F G H J K 1 Ad Size Height (pixels) 2 S 90 3 M 150 4 L 220 5 6 7 VLOOKUP Example in cell F6 looks up height of ad size in cell E6 M 150 8 9 Ad # Size Border Bid Ht w/o Border 10 11 12 12 13 14 15 16 123456 N M S M L S M 7 L 17 8 L 18 9 M 19 10 L 20 11 S 21 12 M 22 13 M 23 14 M 24 15 S 25 16 L 26 17 M 27 18 L 28 19 S 29 20 M 30 21 L 31 22 L 32 23 M 33 24 M 34 25 M 35 26 M 36 27 M 37 28 L 38 29 M 39 30 L HOOOOHOOOH OOOOHOOOOHHONO 1 $21.00 0 $1.00 0 $30.00 1 $32.00 0 $54.00 0 $12.00 1 $36.00 1 $51.00 1 $12.00 1 $46.00 1 $32.00 0 $15.00 0 $21.00 0 $39.00 1 $18.00 0 $9.00 0 $14.00 0 $60.00 1 $40.00 0 $27.00 1 $15.00 0 $5.00 0 $35.00 0 $45.00 0 $17.00 1 $55.00 1 $78.00 0 $49.00 1 $9.00 0 $96.00 40 41 42 43 44 Answers Question 1 Question 2 Question 3 Question 4 Question 5 + 123456782 A B C D E F Ad Size Height (pixels) S 90 M 150 L 220 G H J VLOOKUP Example in cell F6] M =VLOOKUP(E6,E$2:F$4,2,FALSE) looks up height of ad size in cell E6 9 Ad # Size Border Bid Ht w/o Border 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 19 29 30 31 32 33 34 35 36 37 38 39 12345678GONNENSORPRE222222223 M S M L S M L L 9 M 10 L 11 S M M M S L M SOOHOOHOOOHOO 1 $21.00 0 $1.00 0 $30.00 1 $32.00 0 $54.00 0 $12.00 1 $36.00 1 $51.00 1 $12.00 1 $46.00 1 $32.00 0 $15.00 0 $21.00 0 $39.00 1 $18.00 0 $9.00 0 $14.00 L 0 $60.00 S 20 M L L M M M M M L 29 M 30 L HOOoooHHOHO 1 $40.00 0 $27.00 1 $15.00 0 $5.00 0 $35.00 0 $45.00 0 $17.00 1 $55.00 1 $78.00 0 $49.00 1 $9.00 0 $96.00 40 41 42 43 44 Answers Question 1 Question 2 Question 3 Question 4 Question 5 + Question 1 Profit Which jobs? Question 2 Profit Which jobs? Please show two digits to the right of the decimel point for your profit answers. Your answers should be reflected on the worksheets for the individual questions. 140.24 1-5 and 19% of 6. Question 3 Profit Which jobs? Question 4 Profit Which jobs? Did you need to resort? Why or why not? Question 5 Profit Which jobs? Did you need to resort? Why or why not?