tips for MS EXCEL test.. [ 9:36 PM ]

1) format -> cells -> alignment-> horizontal(center), vertical(center)
*make sure dere is a tick under wrap text*
[move the text to center]

2) format -> cells -> pattern -> choose color
[highlight a box with color]

3) format -> cells -> horizontal(fill), vertical(center) -> enter a "=" and press enter
[fill in the column with ==========]

4) total -> =sum(Drag from 1st to last)"enter"
highest -> =max(
lowest -> =min(
average -> =average(
[find the amount]

5) format -> cells -> border
***Choose the style & color 1st***
[outline the box wit color lines]

6) Overtime pay: =IF(D6>44,1.5*Rate of pay*hours worked-44),0)

Gross pay: IF(D6>44,44*Rate of pay+Overtime)

Gross pay w/out CPF : IF(D6>44,44,Rate of pay*hours worked)

impt.. IF(HOURS WORKED>44,

Lynn`
Wawa`
Izzah`
Waheeda`
Ina`
Tasha`
Fang yi`
Donkie`
Sze ling`
Fiona`
Cally`
Khairul`
Nizam`
Zhide`
Jonjon`
Sebas`
Kailun`
Danial`
Abang`
Ijat`
Gideon`
MR.Dino`
MR.Upside Down`
The Revivals`