Introduction to IF AND Functions

First: Download/Open the IF AND Function Task Sheet

Second: Watch the video tutorials

Third: Download the BONUS datafile and the MY FIRST CAR data file

Fourth: Complete the two tasks and email the two spreadsheets to your ICT FS tutor


Activity 1 BONUS Entering the IF AND Function






Activity 1 BONUS Formulas View and Printing






Activity 2 MY FIRST CAR Getting External Data






Activity 2 MY FIRST CAR Entering the IF AND Function






Activity 2 MY FIRST CAR Filtering, Sorting, Fit Sheet on One Page