IT Apps - Exercise 5

1. Open a new workbook and develop a spread sheet shown below.
2. Linkup the two worksheet using VLOOKUP function.
3. Follow the following steps:
                                       i.      In worksheet 2, define the grade table.
                                     ii.      Name your table as ‘Grade’.
                                    iii.      Now, go to Worksheet 1, and click cell C5
                                   iv.      Then Fill in the blank, please refer to the notes on how to do so.
                                     v.      Click OK
4. The Cell C5 will be filling with the grade ‘P’, Use AUTOFILL to copy the formula to the other cells.

    Worksheet 1

Worksheet 2

http://mc.tt/a4KgCIv3QD