11 h elherdComputer SetWhat's MoreDirection: Using the tables below create the formula that will solve the given problems.Write your answer on a separate sheet of paper.Use the table below to answer numbers 1 and 2.DQuantity Total Amount2 PHP 1,0003 PHP 3,000PHP 4001 PHPCount the number of products where priceis less than 500.Display "Within the Budget" if the totalamount is less than 1,500. Otherwise "Overthe Budget" will be displayed.1 Product Price2 ShirtPHP500PHP4 Umbrella PHP5 Shoes3 Jacket1,000200PHP3,0003,0001 PHP 2,0006 BagPHP2,000Use the table below to answer number 3.SALES FOR THE MONTH OFAUGUST 20191. Show the total sales for the month of August.NameNo of Selesa4 GAHRY ARUNAS5 KENNETH JAY ARELLANOA BIANNE CAAYAMAN7 DARVEN CARLOS8 CARL JASON COLOMA9 ROMEO JAY CURAN10 RAPHAELLLOVD DELMO5627652011 GEOFREY DEO4612 ELIUDFLORES11 ALVIN DANDAWALI14 SAMUEL ANGELO GONZAL15 JORDAN JESURA16 DYRYLE KEM LEAL17 KHALED MAMA18 REYMART MANGLICMOT562733353445468EUse the table below to answer1 Order No. Date Driver's Name10001 8/1/2019 Rent loshuas Name temNo. of hems Destinationsolsurallah10 Lake Sebu20Surallah10 Tupi5Polomolok10 Lake SebusSto. Niño30Norala15 Tupi20 Lake Sebunumbers 4. 5, and 6.3Washing MachineTelevision10002 8/2/2019 reh2. Count the number oforders delivered in Lake Sebu.4 1000 2019van lairs510004 8/3/2019 John Lherd Computer Set10005 8/4/2019 lanbert3. Count the number oftelevision orders.4. Count the number ofitems that are less than 15.610006 8/5/2019livan jarusFumitureAir ConditionerComputer Set10007 8/5/2019lJohn Lhord10008 8/5/2019 Rena Joshua Printer10 10009 8/6/2019 Rigu Daniel Television10010 8/6/2019llayson11Printer12Use the table below to answer numbers 7, 8, 9, and 10.123 Respondent AgeGlucose level1449722746.24654427355588568010742961121731223661310417214115487151255871314722141231617911815725. Count the number of respondents.6. Show how many respondents are having glucose level of more than 90.7. Compute the average of glucose level.8. Count the number of respondents whose age is older than 5o.

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

Direction: Using the tables below create the formula that will solve the given problems. Write your answer on a separate sheet of paper. Use the table below to answer numbers 1 and 2. Product Price 2 Shirt Jacket 4 Umbrella PHP 5 Shoes 6 Bag 7 Quantity Total Amount 2 PHP 1,000 al PHP 3,000 2 PHP PHP 3,000 Count the number of products where price is less than 500. Display "Within the Budget" if the total amount is less than 1,500. Otherwise "Over PHP S00 PHP 1,000 200 400 PHP 3,000 the Budget" will be displayed. PHP 2,000 РHP 2,000 Use the table below to answer number 3. SALES FOR THE MONTH OF AUGUST 2019 1. Show the total sales for the month of August. Name DAHNY ARUNAS SKENNITH IAY ARLLANO 6 RIANNE CAAYAMAN DARVEN CARLOS CAR JASON COLOMA ROMEO JAYCURAN 10 RAINIALLLOYD DELMO 1 DEOFREY DED INe of Seles 27 65 34 45 11 1 ALVIN DANDAWALI 14SAMUEL ANDELO GONZAl FOHDAN JESURA DVRYLEKEMLEAL KHALED MAMA REYMART MANOLICNOT 13 21 34 45 Use the table below to answer Order No Date Driver's Name tem 10001 R/1/201 Ren loshus Electric Fan 10002 /2/2019 veh Washing Machine No. of hems Destination S0Saralah 10ake Sebu h numbers 4. 5, and 6. 2. Count the number of orders delivered in Lake Sebu. 3. Count the number of television orders. 4. Count the number of items that are less than 15 4 Television 1000 8/1/2019van lara S10004 //2019 John Lherd 1000s 8/A/2019lantert 1000, RAS/201van laia Air Conditikner 10007 B/201 ehn Lhend Computer Set 1000 85/2019ben Joshua Printer 1000 B/6/2019 Rign Daniel Televsion 10010 /2019llayson 20suralla 10Tuel SPulondok 10Lake Sebu Se Nila 30Norala Computer Set Fumiture Air Conditiener 10 Printer 20 Lake Sebu Use the table below to answer numbers 7, 8, 9, and 10. 3 Respondent Age Glucose level 44 22 97 74 65 73 24 42 55 56 42 8 5 88 80 10 7 96 21 73 66 11 12 23 13 10 41 72 54 55 14 11 87 12 87 72 15 13 14 15 16 21 17 41 91 23 72 18 5. Count the number of respondents. 6. Show how many respondents are having glucose level of more than 90. 7. Compute the average of glucose level. 8. Count the number of respondents whose age is older than 50o.