LOGICAL FUNCTIONSLearn how to use Excel's logical functions such as the IF, AND and OR function. If FunctionThe IF function checks whether a condition is met, and returns one value if TRUE and another value if FALSE.1. Select cell C2 and enter the following function.The IF function returns Correct because the value …
TEXT FUNCTIONS in ExcelExcel has many functions to offer when it comes to manipulating text strings.Join StringsTo join strings, use the & operator.Note: to insert a space, use " "LeftTo extract the leftmost characters from a string, use the LEFT function.RightTo extract the rightmost characters from a string, use the RIG…