Qualification > Miscellaneous

All ICT doubts here!

<< < (3/103) > >>

haris94:
yea got it
those notes r great By the way
Thanks again

haris94:
NEED HELP IN THIS QUESTION FROM M/J 2007 PAPER 3 -- MS EXCEL

Search this data to find all the items where Quantity is greater than or equal to 60
and Price is greater than £2

PLS TELL ME HOW TO DO IN EXCEL 2003

Vin:
for this u need to apply filter options...i think in 2003 this option should be in "Tools"..first select the data u wanna filter (here its the "quantity"...dont forget to select the whole column of the field) go to tools and select autofilter and u'll get a drop down menu on the field name..
in the drop down menu there should be an option of "greater than or equal to" if not go to custom and select greater than or equal to "60"
now autofilter for price also...and select "greater than" and "2"   
u get it???
to remove the filter jus select the cells/column and remove the filter option..hope u get it...

haris94:

--- Quote from: sd7764 on April 09, 2010, 11:20:18 am ---for this u need to apply filter options...i think in 2003 this option should be in "Tools"..first select the data u wanna filter (here its the "quantity"...dont forget to select the whole column of the field) go to tools and select autofilter and u'll get a drop down menu on the field name..
in the drop down menu there should be an option of "greater than or equal to" if not go to custom and select greater than or equal to "60"
now autofilter for price also...and select "greater than" and "2"   
u get it???
to remove the filter jus select the cells/column and remove the filter option..hope u get it...

--- End quote ---

ok i got how to filter, Thanks for that
but the problem is i dont get how to filter 2 columns
eg. i filtered data for the column "quantity"
now i do the same procedure for "price" but it just removes the filter for "quantity"

pls help asap; hv boards on 15th

haris94:

--- Quote from: 7ood on April 09, 2010, 11:42:09 am ---wat email server should we use to send the emails dnt say hotmail cuz it doesnt contain bcc or cc

--- End quote ---

hotmail does hv bcc and cc
option is at the top right corner of the new email page "show cc and bcc"

Navigation

[0] Message Index

[#] Next page

[*] Previous page