Concept:The IF function checks whether a condition is true or false and returns one value for each result.Explanation:Option A describes the AVERAGE function.Option B describes text functions like CONCATENATE or TEXTJOIN.Option C correctly describes the IF function: it performs a logical test and returns a specified value if the condition is TRUE, and another value if it is FALSE.Option D describes functions like INDEX.Answer:C. perform a logical test and return a value for a condition.