Qualification > Miscellaneous

ICT june 2009 paper 2....help!!

(1/3) > >>

thepokerpro:
Hey guys,

I wasnt able to complete question 44 in the jun 09 ICT paper 2..!!

My exam is in 3 days!!!........so if any one can help me it will be much appreciated... ;D ;D ;D ;D ;D

Please complete the question and give me a guide to doing it myself..!!

The files are attatched with this post...!!!

Tanx a lot!!!!!!!! ;D ;D ;D ;D ;D ;D

P.S: if your date format is like the american format.......use the file "j9sales2.csv"

 ;D ;D ;D ;D ;D ;D ;D ;D ;D ;D

nid404:
OKay first

1) fit on single page
File
Page setup
potrait
fit in page width and height

note.....it won't fit on a page as yet....so go to the next part

2)filtering
select the field
go to data>filter

a drop down appears....for week you do 35
for date...click custom
you'll get a window
in the first drop down....put greater than...and to it's right 01/01/2009
and
in the second put less than...31/01/2009

thennn
3) select the field not require......go to format>column>hide

4) expand the columns so the field names are completely visible

5)click on the date field and staff field>data>sort>ascending order for date first..then by staff
6) view>header and footer>custom.....in the middle type mini tours and in the right tyoe ur name,centre,candidate no


DONE :D

thepokerpro:
Wait a second.....!!!

U r using Microsoft excel!!!

I have to use Microsoft access!!!

It shows in the marking scheme...

I can do it with excel but i dont think it is allowed!!!!
 ??? ??? ??? ;D ;D ;D ??? ??? ???

nid404:
oh i didn't know....no problem...will do it with access and tell you
Well i actually gave this paper...but i don't remember ::)

two minutes....i'll let you know

thepokerpro:
thanks a lot.. ;D ;D

Navigation

[0] Message Index

[#] Next page