Thursday, July 3, 2008

ICTL - F1 : SPREDSHEET - W/SHEET RENAME & GREDING

How to Rename Worksheet ?
1. Right click at taskbar Sheet 1, click Rename.
2. Type the new name wanted, enter.

Greding :
1. Make mark scale : 0-E, 50-D, 60-C, 70-B, 80-A.
2. Put the pointer at cell that we want to set gred.
3. Click fx (function wizard).
4. Click arrow, choose All.
5. Select function, choose VLookup, then OK.
6. At Lookup Value, click the first mark.
7. At Table Array, highlight mark scale, then press F4.
8. At Col.Index Num, type 2, then OK.
9. Copy the formulae to the other marks.

Labels