// Questions by mikec 
// Created by cybertrain.info 
// load  arrays with a set of questions and  answers 
  title='Excel Functions'; 
questions=new Array(); 
questions[1] ='An inbuilt formula is called a ~Function~Range Name~Status bar~value~A~'; 
questions[2] ='What is the value of =sum(b2:b4) ~21~10.5~16~none  of these~A~'; 
questions[3] ='What is the value of =average(b2,b4) ~6~10~16~none  of these~A~'; 
questions[4] ='What is the value of =int(average(b2:b4)) ~7~10~21~none  of these~A~'; 
questions[5] =' =IF functions are an example of a ~logical~database~financial~statistical~A~function'; 
questions[6] =' In correct order what are the arguments in an =IF function~none  of these~condition, false result, true result~true result, false result, condition~condition 1, condition 2, condition 3~A~'; 
questions[7] ='Select the function which displays the word "Correct" when A1 is greater than 10 or less than 5 ~=IF(Or(A1 10,A1 5),"Correct","Incorrect")~IF(A1 10,IF(A1 5,"Correct","Incorrect"), "Incorrect")~IF(A1 10 and A1 5,"Correct","Incorrect")~=And(A1 10,A1 5~A~'; 
questions[8] =' In correct order what arguments are used in a Lookup function~lookup_value,table range, offset~offset,selector, lookup_value~lookup_value, table range, selector~offset, lookup_value, table range~A~'; 
questions[9] ='When the lookup value in the function does not match the one in the table, which value is used ~next lowest in the lookup_value range~next highest in the offset range~next lowest in the offset range~next lowest in the table range~A~'; 
questions[10] =' To total the values of cells B2 on worksheets named, Week1, Week2 and Week3, the formula is ~=Sum(Week1!B2,Week2!B2, Week3!B2)~=Sumall(B2)~=Total(Week(x)B2)~Excel cant add cells on different sheets~A~'; 
questions[11] =' The Rand() function returns a value in the range ~0 -.9999~1 - 10~1 - 100~-10 to 10~A~'; 
questions[12] =' The function =int(Rand()*7+1) returns a value in the range ~1 to 7~0 to 8~0 to 7~1 to 8~A~';