For example if A2 is apples and B2 is Apples the formula EXACT A2 B2 will returns FALSE because they are not exact match. If you right-click on the worksheet the context menus will be prompted. For example A1A2A3 which finds the sum of the range of values from cell A1 to cell A3.
In Excel a formula is an expression that operates on values in a range of cells or a cell.
The AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90 else it returns FALSE. Sometimes we need to format or manipulate data the way what we want. If you right-click on the worksheet the context menus will be prompted. IF C2 1 then return Yes otherwise return No As you see the IF function can be used to evaluate both text and values.