User:Pidpod1/sandbox

How to pass your iGCSE ICT exam....

For all the functions (eg VLOOKUP): To know wat function you need to use, then press the fx button and click on each function and see which one matches the question. Then from there on it tells you what every part of the bracket that it requires means.

To create a named Range: HIghlight the cells you want to name (not including the title) and then tpe into the white box in the top left corner what you want to name it. REMEMBER to use the exact name when you use them in a funciton.

To replicate a function: Drag the function that you have typed in down.

Stickies ($) Eg $A$2: Means when you drag a function down, the line that you are lets say, timsing, also goes down. It does not times it by the one cell. DONT FORGET to put the sticky before the letter AND the number.

How to make a drop down list (When it says INTERROGATE THE DATA it means to search it by using a filter): highlight the titles of the columns, clik on data/filter/autofilter. then to custom it, you click on the arrow and say (custom).