Syllabus Detail

  • Create solutions using a spreadsheet application using:

    • functions
    • charts
    • lookup table
    • sorting
    11 ATAR, 12 GEN


1. Functions


2. Charts


3A. Learn
Make a solution with a Vlookup Example from a Teacher's Marks Book



3B vlookup (continued)


        Go to the our AIT website page HERE and make your own vlookup spreadsheet

3C Microsoft background details about Lookup HERE

3D Microsoft details about vLookup HERE


 4. Sorting



Further Research

Found an error or enhancement? Please fill out this contact us form.