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