please answer with explaination and ill rate you !

Melbourne Client List 4 Which formula correctly calcualates the average client spend for 2022 in L13? A=16:115/10 FALSE B =AVERAGEIFS(16:115, 2022) FALSE C =AVERAGEIFS(16:115) FALSE D =AVERAGE(16:115) FALSE 5 Which of the following would calculate the current date as shown in L6? A= DATES(L6) FALSE B= DATE() FALSE C= TODAY() FALSE D =DATEVALUE(LG) FALSE 7 Which calculation will return the number of customers who have not placed an order in the last 90 days? A = COUNTIFS(D6:D15)>90 FALSE B= COUNTIF(D6:D15,90) FALSE C= COUNTIF(D6:D1 5,>90) FALSE D= COUNTIFS(DG:D1 5,">90") FALSE 8 Using the formula =VLOOKUP (3055,F:115,4) to retum the 2022 spend for client at postcode 3055 is incorrect.. A because it should be an exad match FALSE B because it should use absolute cell referencing C because 3055 should be in quotation marks, i.e. "3055" FALSE D because the look up range should be B6:115 FALSE FALSE