Qualification > Miscellaneous

Applied ICT paper 2 nov 2009

(1/2) > >>

annie_angel:
plz plz urgently help with step 27 and 32.......!!!!!!!!!!!!!!!!!!!!!
 :'(

annie_angel:
plzzz anyyoneeee .....!!!!:(

Saavya:
*phew* just finished with it :)

well in step 27

- in a new column (J) you have to insert the formula " =IF(I6>10,I6,0) " to find only the flights more than 10 minutes late , for All the flights in that sheet.

- then go to the new sheet you created (in which you copied and pasted all the airline names from cell a2 to a32)

-in column C , enter the formula " =SUMIF(N9Flight!$C$6:$C$131,A2,N9Flight!$J$6:$J$131) " (where the J column range was that extra column you created in N9flight worksheet)

in step 32 ? thats simple

-filter the number of flights greater than 6, ooh By the way place labels in a1 ( Airlines) b1 (No. of flights) and c1 (time delayed, or just
delayed) to make it clear for you !

-then u can continue with making a stacked bar chart !  using the chart wizard  ;D

Saavya:
if anyone knows any other simpler way of doing step 27 please do post the way of doing it here !

annie_angel:
omgosh!!!!!
thnak you soo soo much!!!:D :D :D
i really really appriciate tht!! :D

Navigation

[0] Message Index

[#] Next page