help with all. they are all readable so dont use that excuse.

K32 x & fi M 1000 G H Question 1 - Use the data from the NCAA t-shirt sales to answer the following questions: Assigning amestech of the wees in continet to BS Use the range ants to cale e Total Flow. To cost and Marimum Profit See the lectures to the teve condition 5 Uncertain wariable Our demande 1200 7 Decision variable Quantity Ouderet Input variables Fed cost 11 wiste con Original price Discounted price 14 15 16 Tote Total Com 3750 19 Mam POR 11250 20 750 5 22 23 25 25 Question 2 - Use Data Table and the results from question 1 to answer the following questions: 2 Complete the Two Input Data Table below for Profit 28 Data Table -TVO INPUT: orders and Price 22 00 Prices 15 16 17 18 1000 1920 1050 0 0 0 1100 0 0 0 1150 0 0 0 0 1250 0 0 0 1350 0 0 0 0 14.00 0 0 0 0 0 . 0 1200 1300 0 46 0 hot wheese and share ordered and to 317 pt. 100 Preview Sheet View Layout Views Workbook Views K32 WRA f e B C D 37 E d F 1300 G H 0 38 0 0 0 1350 0 0 39 0 0 1400 0 0 0 40 0 S 0 1450 G 0 41 0 0 1500 0 0 0 42 0 1550 0 0 0 0 0 1600 0 0 0 0 44 0 1650 0 0 0 0 45 0 0 1700 0 0 0 0 46 0 0 47 Use the VLOOKUP function to find profit when 1250 and 1600 t-shirts are ordered and sold for $17 per shirt 48 Order Profit 49 1250 50 1600 51 52 53 54 Question 3 - Goal Seek 55 1. Using the Goal Seek function, how mang t-shorts should be ordered to make profits below? 56 chal Sales DOMOTO Terror the dance for Cancelar 57 Prolia Order 58 30 59 $10,000 60 61 62 53 84 65 67 ES 69 70 71 22 23 24 70 Data from a questionnaire on environmental policy M N Children 0 1 3 Question 4 - Use COUNT or COUNTIE function to identity columns (Field Use yellow light to mark the field ones, and the contesponding cele ii Conect the highlighted cells marked in our The Gredelsecentered Check to see whether they were entered trademar 2 2 2 bel Mgo Gender State Eddy 1 Ancona Model 1 Ailiona 3 Mased 2 California 4 Young 1 Cuis 6 Young 1 Florida 1 Flora 7 El 2 inois M-gd 1 los Med 1 Michigan 2 Michigan i Matage Michigan 1 Michigan 1 Minnesota 1 Miste- 2 Minnesota Mweged Minnesota Moded 2 New Yon 11 Mattewed New York MM New York Me Two 20 Middle aged 1 Now York 21 Mdee New York 22 Mid New Yo 00 O 25 Ml Ono Moed To YO 2 Young TA 23 Yang Vegni Question 5 - Other errors Ein the Age category columns SORT to wrig whether there are eitt space inco Hure the motion to correct them, you find any Use gelowigights to mark the corrected Winthepe below, describe the process you will see not the Sway com V. Highly the found out how the 1 2 0 2 1 2. 2 Salary Opinion apital City $43.200 Strong Phoeni $399 Ne Phone 191400 Strongly disagree Secret 144,100 Nel Secreto 152.000 Shree Tallahassee 145.200 Neut Tallahassee 156.000 songs aree Speeglid 145.400 Disagree Springfield 161500 Disage Luig 13.999 Agree 153.000 A Lining 150.300 Strong Lansing 15.400 Songs Saraw 143.600 Songs St Paul 154,300 Degree Sunt 146,300 Strong Ab 6. Strong gree $40.00 A 38.000 Dage 162,00 Agree Ah 073.000 Neutral 43000 A 14200 N Com 27,700 Songs 14.00 w Com Austin 14700 A Austin 450.300 Agree Austin ON Pont 113.400 Semond 1 2 1 o Ah Ah AD A O 0 1 Question 6. Which of the following will you use to correct the errors found Det beror whom File there the wrapy Prepare the end with the were notion Osito obro Te 3 1 O 2 K32 x & fi M 1000 G H Question 1 - Use the data from the NCAA t-shirt sales to answer the following questions: Assigning amestech of the wees in continet to BS Use the range ants to cale e Total Flow. To cost and Marimum Profit See the lectures to the teve condition 5 Uncertain wariable Our demande 1200 7 Decision variable Quantity Ouderet Input variables Fed cost 11 wiste con Original price Discounted price 14 15 16 Tote Total Com 3750 19 Mam POR 11250 20 750 5 22 23 25 25 Question 2 - Use Data Table and the results from question 1 to answer the following questions: 2 Complete the Two Input Data Table below for Profit 28 Data Table -TVO INPUT: orders and Price 22 00 Prices 15 16 17 18 1000 1920 1050 0 0 0 1100 0 0 0 1150 0 0 0 0 1250 0 0 0 1350 0 0 0 0 14.00 0 0 0 0 0 . 0 1200 1300 0 46 0 hot wheese and share ordered and to 317 pt. 100 Preview Sheet View Layout Views Workbook Views K32 WRA f e B C D 37 E d F 1300 G H 0 38 0 0 0 1350 0 0 39 0 0 1400 0 0 0 40 0 S 0 1450 G 0 41 0 0 1500 0 0 0 42 0 1550 0 0 0 0 0 1600 0 0 0 0 44 0 1650 0 0 0 0 45 0 0 1700 0 0 0 0 46 0 0 47 Use the VLOOKUP function to find profit when 1250 and 1600 t-shirts are ordered and sold for $17 per shirt 48 Order Profit 49 1250 50 1600 51 52 53 54 Question 3 - Goal Seek 55 1. Using the Goal Seek function, how mang t-shorts should be ordered to make profits below? 56 chal Sales DOMOTO Terror the dance for Cancelar 57 Prolia Order 58 30 59 $10,000 60 61 62 53 84 65 67 ES 69 70 71 22 23 24 70 Data from a questionnaire on environmental policy M N Children 0 1 3 Question 4 - Use COUNT or COUNTIE function to identity columns (Field Use yellow light to mark the field ones, and the contesponding cele ii Conect the highlighted cells marked in our The Gredelsecentered Check to see whether they were entered trademar 2 2 2 bel Mgo Gender State Eddy 1 Ancona Model 1 Ailiona 3 Mased 2 California 4 Young 1 Cuis 6 Young 1 Florida 1 Flora 7 El 2 inois M-gd 1 los Med 1 Michigan 2 Michigan i Matage Michigan 1 Michigan 1 Minnesota 1 Miste- 2 Minnesota Mweged Minnesota Moded 2 New Yon 11 Mattewed New York MM New York Me Two 20 Middle aged 1 Now York 21 Mdee New York 22 Mid New Yo 00 O 25 Ml Ono Moed To YO 2 Young TA 23 Yang Vegni Question 5 - Other errors Ein the Age category columns SORT to wrig whether there are eitt space inco Hure the motion to correct them, you find any Use gelowigights to mark the corrected Winthepe below, describe the process you will see not the Sway com V. Highly the found out how the 1 2 0 2 1 2. 2 Salary Opinion apital City $43.200 Strong Phoeni $399 Ne Phone 191400 Strongly disagree Secret 144,100 Nel Secreto 152.000 Shree Tallahassee 145.200 Neut Tallahassee 156.000 songs aree Speeglid 145.400 Disagree Springfield 161500 Disage Luig 13.999 Agree 153.000 A Lining 150.300 Strong Lansing 15.400 Songs Saraw 143.600 Songs St Paul 154,300 Degree Sunt 146,300 Strong Ab 6. Strong gree $40.00 A 38.000 Dage 162,00 Agree Ah 073.000 Neutral 43000 A 14200 N Com 27,700 Songs 14.00 w Com Austin 14700 A Austin 450.300 Agree Austin ON Pont 113.400 Semond 1 2 1 o Ah Ah AD A O 0 1 Question 6. Which of the following will you use to correct the errors found Det beror whom File there the wrapy Prepare the end with the were notion Osito obro Te 3 1 O 2