Can someone help me with these excel related questions please. i am new to this course and i am trying to catch up but i have no way how to answer any of these. thank you in advance for your help, i greatly appreciate it.

Question 1 (1 point) Saved Which of the following formulas would produce a numerical value in Excel? ( =5>3 . =SUM(C3:E8) O ="AVERAGE" =IF(B3=5,"True"False") Question 2 (1 point) Which of the following formulas contain valid references for two separate worksheets? =Sheet!1+Sheet!2 =!Sheet1R2+!Sheet2D2 =Sheet1B8Sheet288 =Sheet1!H3*Sheet3!F7Question 3 (1 point) Which tool can be used in Excel to identify cell(s) that meet a certain criteria by highlighting them? O Filter Sort OVLOOKUP Function OConditional Formatting Question 4 (1 point) Which of the following formulas would produce the value "FALSE"? ( =OR(5>4, 2>5) =NOT(610,"Good"Bad"),AND(C310, C310, C310,"Good", "Bad"),IF(C332", B4, "apples", or "32". criteria_range2, criteria2, ..: Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed Select the following statement which best describes the correct usage of COUNTIFS for counting the number of Excel cells within the range E3 to E? which display a value that is less than 100 but greater than 50. criteria_rangel: $6$3:SE$9 criteria1: ">50" criteria_range2: $E$3:SE$9 criteria2: "" "50" criteria_range2: $E$9 criteria2: "=50" criteria_range2: $8$3:SE$9 criteria2: "