1. Getting to know Excel

2 Topics | 1 Quiz
2. Working with Cells

3 Topics | 1 Quiz
3. Modifying Columns, Rows, and Cells

2 Topics | 1 Quiz
4. Formatting Cell

5 Topics | 1 Quiz
5. Understanding Number format in Excel

5 Topics | 1 Quiz
6. Using Find & Replace

2 Topics | 1 Quiz
7. Formulas and Functions

6 Topics | 1 Quiz
The IF function checks whether a condition is met, and returns one value if true and another value if false.

Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. Remember, to quickly copy this formula to the other cells, click on the lower right corner of cell C2 and drag it down to cell C6.