excel formula and functions exercise
ckly identify data extremes. Exercise 4: Creating a Simple IF Statement Objective: Display "Pass" if a score is 50 or above, otherwise "Fail." Steps: Enter scores in cells D1 to D5: 45, 55, 60, 40, 70. In cell E1, type: `=IF(D1>=50, "Pass", "Fail")`. Drag the formul