Microsoft Excel Interview Preparation (Questions and Answers)
What is the IF function? It performs logical tests. Example: =IF(A1>50,”Pass”,”Fail”) What is nested IF? Using multiple IF functions within one formula. What is the AND function? Returns TRUE if…
