EXCEL FUNCTIONS_Basic   AND Returns “TRUE” or “FALSE” based on two or more conditions. =AND(B2=”Fire”;C2>70) =IF(AND(B10=”Fire”;C10>70);”Yes”;”No”)   AVERAGE Calculates the average  =AVERAGE(B2:E2)   AVERAGEIF Calculates the average of a range based on a true or false condition. =AVERAGEIF(range, criteria, [average_range])   AVERAGEIFS The average of a range based on one or more true or false condition. =AVERAGEIFS(average_range, criteria_range1, criteria1, …)   CONCAT To link something together. =CONCAT(A2,” “,A3)   =CONCAT(A2,”and”,A3)  …