Please help me find these answers
L () Use VLOOKUP function to get [ mall and Phone Number of the Implant Medohio Bryan Anna Pena 15) Alter the employee data and beep only the list of employees whose salary h above $70.000. 570.157.09 $54,608.00 $41.40-4.60 $15 571.00 Sat aug8 595.013.00 DEAL F1Q FII End THShare Comment Meable lidting G IN P ber of Mocks Open Hich [5) Use stathtics function(s) to find the average and median for Volume and Open columns, Show late chart title your work in cells range H24:138. DELL F11 F12 Home End Insert DEVELE\fHome Page Layout Formuin Bit Review Wow Htp The table shows employee data. Answer the following H 4 June Aler Province I-mail Vancount Pho Hine Duty Salary 5 Mulisha Alia Surrey Natisha Bruess Surrey 7 Hal Chukes Delta B Grotgeann Dal Vancouver 9 Darius Dillamrut Vancouver MUGAyahoo.com 10 Jane Durtachi Richmond VCBymail.com 11 Bret Fila uil.com 12 Marvis Fubuing Vancouver po.com 13 General, Marlin Delta 14 Antonio May Delta om 404-3013 15 Brittany Ellis Vancouver 16 Clyde Haynes Summer 17 Johnnie Jones Delta 18 Emmett Flemin Surrey 19 Krista Kennedy Surrey 20 Demadethe Bar Richmond 31 Marvin Wood Vancouver 22 Wendy Thorns Coquitlam 23 Heidi Rots Richmond 24 Otis Harrison Surrey question I quiriton ] question DELLlidtermF20202_LastFirst (2) - Protected View - Excel Help Search Amandeep K. AK X lit, it's safer to stay in Protected View. G Share Enable Editing Comments X K M N le P Q (b) Use the PivotTable to create a 2-D Bar PivotChart. Delete the legend. Select the Chart Title R S T and type Units Sold to Customers. Horizontal and Vertical Axis should be shown with proper lables. Place the chart in cells range 13:017. 100% 4:21 PM 10/22/2020 DELL Home End Insert Delete F12 SysRq Pause F8 F9 F11 ProtScr F7 F10Autism 06 AL MidtermF3020 Lastfind Co - Protected View Home Insert Page Layout Formulas Data P Starch PROTICTIDYW Becaall Hei hope the hirmet can contain union. Unless you need to all i's wade to virgin hotected Vine. D F (a] The table shows historical stock prices for Clico. Volume is the number of stocks traded on each given date. From Charts select Stock and create a Volume Open-High- b) Uve Mathties Low-Close chart. Place the chart in cells range H4:U22. Type an appropriate chart title and anis titles. Delete legend. Cisco Stock Data Date Volume High LOW Clove 1/1/2020 379359190 49.54 3/1/2020 560741100 46.40 50.28 34.35 591813100 40.15 488948300 42 30 5/1/2030 491402300 41.72 40.49 6/1/2020 571 121500 47.15 ALM 46.6-4 7/1/2020 47. 70 45.20 47.10 /1/2030 47:14 41.45 5/1/2030 42.69 19/1/2030 H.IO 40.61 17.57 question # DELLFile Home Insert Page Layout Formulas Dali Brees View Harp 23 Heidi Ross Richmond 24 Otis Harrison SUPTET Youhelpemail.com That 25 Dale EdBonds Coquitlam harisonofippemail or 104 213-4 26 Matt Malone Richmond 27 Robin Moran Surrey 38 Penny Casey Vancouver moranch Bymail.cor 60s for-1 20 Sura Daniels Port Moody caseyponermail con 504 213 30 Rodolfo Bryan Vancouver danishmur ymailer 14 al.1. 31 BCiter Simpion Vancouver 13/10/3601 32 Thelma Jacobs Surrey 3.3 Priscilla French Deltas frenchpri @gmail non Pre-305- 34 Catherine Bure Surrey 35 Jody Fitzgerald Suney fitzgeraldjodyemail. 504-314 4 36 Mandy Graves Richmond gravesman 37 Blanche Martin Vancouver 38 Shane BCtking West Vancouver By 39 Martin Wright North Vancouver B Armailes Fra-316 5 40 Robin Santos Richmond 41 Cedric Parker Delta 42 Bonnie Schuler Delta 43 Della Hernande Summer mail.com 3-537-4 44 Sonia Leve Surey 45 Anna Pena Richmond Altar Photmaile 504-343-3 46 Sara Poole Vancouver gibsoncla Bymail.con 104-603- 47 Claire Gibson Coquitlam cunninghamite Rym 604 530-7 48 Eleanor Cunning Richmond question 1 DELLAutoSave (@ off) H MidtermF20202_LastFirst (2) - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing H14 X V 4 D G H 1004 $ 51.99 $ K 11 500.95 $ 24.99 $ 32.19 L M 12 1005 $ 32.19 $ 300.99 $ 300.99 $ 35.79 13 1006 $ 35.79 $ 700.95 $ 200.99 $ 405 .19 14 1007 $ 45.19 $ 1008 $ 35.99 $ 104.99 $ 780.99 $ 35.99 15 799.99 $ 2,000.99 $ 19.99 16 1009 $ 19.99 $ 21.99 $ 500.99 $ 75.99 17 1010 $ 700.99 $ 35.99 $ 200.99 $ 139.99 18 1011 $ 24.99 $ 10.99 $ 5.99 $ 154.99 19 1012 $ 79.99 $ 120.99 $ 300.99 $ 250.99 20 1013 $ 107.99 $ 349.99 $ 299.99 $ 17.99 21 1014 $ 21.99 $ 51.99 $ 210.99 $ 559.99 22 1015 $ 779.99 $ 399.19 $ 399.99 $ 801.99 23 1016 $ 819.99 $ 3,500.79 $ 32.18 $ 707.99 24 1017 $550.99 $ 15.19 $ 441.99 $ 855.99 1018 $ 83.78 $ 35.99 $ 79.99 $ 35.99 26 1019 $ 64.99 $ 19.99 s 51.99 $ 400.99 27 1020 $ 99.99 $ 700.99 S 32.19 $ 1,000.99 28 1021 $ 21.99 $ 75.99 $ 32.99 14.99 29 1022 $ 2.99 $ 111.25 $ 38.92 $ 13.55 30 1023 $ 19.99 $ 75.99 S 75.99 $ 12.99 31 1024 $ 23.99 51.99 s 21.99 $ 105.99 32 1025 $ 154.99 20.99 $ 1,777.99 s 35.99 33 1026 $ 98.89 $ $3.99 $ 19.99 $ 19.99 34 1027 $ 12.99 199.99 S 20.99 187.99 35 1028 $ 45.99 $ 2,999.99 S 99.99 S 499.99 36 question 1 question 2 question 3 question 4 question 5 3) N o P N DELL ESC F1 F2 F3 CA E5 F7 F8 F9 F10 F11 9 144 a 2 5 Tab Q W E R T O s Lock C\fAutoSave ( Off) MidtermF20202_LastFirst (2) - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing G7 X 4 D G H K M N 1 (a) What would be the amount of each weekly payment if you loan $108000? Assume that annual interest rate is 2 1.75%, and you plan to pay off the loan in 5 years and each year has 52 weeks. W Loan Amount Annual Interest Rate 6 Years for Loan 7 Periods per Year 8 Period Interest Rate Total Periods 10 PMT 11 12 13 (b) What is the total amount of interest you 14 paid on the loan? 15 Total Interest Amount 16 17 18 19 20 21 question 1 question 2 question 3 question 4 question 5 9 X N P W 1ka F5 F8 F9 F10 F11 F12 ESC F1 F2 F4 9 F3 a 2 3 5 ab W E R Lock G H\fAutoSave @ Off MidtermF20202_LastFirst (2) - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing H14 X V fx K IN 3 A furniture store advertise that no tax on a purchase price above $ 1499. (a) Find the total purchase price for each customer. (b) Write a logical function to indicate if the purchase is qualified for tax discount. (c) Assume sales tax rate is 15%, write a logical function to evaluate the total paid pice (including tax). 6 Retail Store Tax Total discount Purchase qualified 7 Customer ID Item 1 Item 2 Item 3 Item 4 price Paid 1001 $ 71.99 $ 205.99 $ 135.99 $ 107.99 1002 $ 221.99 $ 183.99 $ 590.99 $ 203.99 10 1003 $ 177.99 $ 555.25 $ 700.99 $ 51.99 11 1004 $ 51.99 $ 500.95 $ 24.99 $ 32.19 12 1005 $ 32.19 $ 300.99 $ 300.99 $ 35.79 13 1006 $ 35.79 $ 700.95 $ 200.99 $ 405.19 14 1007 $ 45.19 $ 104.99 $ 780.99 $ 35.99 15 1008 $ 35.99 $ 799.99 $ 2,000.99 $ 19.99 16 1009 $ 19.99 $ 21.99 $ 500.99 75.99 17 1010 $ 700.99 $ 35.99 S 200.99 $ 139.99 18 1011 $ 24.99 $ 10.99 S 5.99 $ 154.99 19 1012 $ 79.99 $ 120.99 300.99 S 250.99 20 1013 $ 107.99 349.99 299.99 S 17.99 21 1014 $ 21.99 S 51.99 S 210.99 559.99 22 1015 $ 779.99 S 399.19 $ 399.99 $ 801.99 23 1016 $ 819 99 2 50n 79 32 18 5 707 99 question 1 question 2 question 3 question 4 question 5 N P W DELL F1 F2 F3 E4 F5 F6 F7 F8 F10 Esc 9 @ $ o 2 A 5 ab O W E R T
