//adspread course
// this file is copyright - Mike Capstick
 // it adds the quiz questions and answers 
 // load  arrays with a set of questions and  answers 
 questions=new Array();
questions[1]='What submenu of the "Insert" menu do you use to name a range?~"Name"~"Chart"~"Macro"~None of these~A~1~1';
questions[2]='In which menu can you find the "Protection" submenu?~"Tools"~"Format"~"Insert"~"Data"~A~1~1';
questions[3]='An inbuilt formula is called a~a function~a range name~the status bar~a value~A~1~1';
questions[4]='What values are calculated from the following  =avg(b2..b4), =avg(b2,b4), =int(avg(b2:b4)) given B2=9,B3=5,B4=7~7, 8, 7~10.5, 10.5, 10~21, 16, 21~none of the these~A~1~1';
questions[5]='In correct order what are the arguments in an =IF function?~none of the these~condition, false result, true result~true result, false result, condition~condition 1, condition 2, condition 3~A~1~1';
questions[6]='What arguments are used in a Lookup function ?~offset, selector, table range~table range, offset, column~offset,selector, column~column, table range, selector~A~1~1';
questions[7]='What are the two types of Lookup function ?~horizontal and vertical~horizontal and selector~offset and vertical~choice and vertical~A~1~1';
questions[8]='When the lookup value in the function does not match the one in the table, which value is used ?~next lowest in the selector range~next lowest in the table range~next highest in the offset range~A~1~1';
questions[9]='How is the Choose function different from the Lookup function.~its data table is contained within the function~it isn\'t~it doesn"t use a selector value~it is limited to eight values~A~1~1';
questions[10]='In the  criterion range, setting criteria on different rows allows~OR conditions to be tested~AND conditions to be tested~NOR conditions to be tested~NOT conditions to be tested~A~1~1';
questions[11]='Which command puts the data in your list into alphabetical order?~"Sort"~"Filter"~"Form"~"Subtotal"~A~1~1';
questions[12]='After choosing DATA FORM which button lets you specify search criteria~"Criteria"~"New"~"Find Next"~"Close"~A~1~1';
questions[13]='What is a Macro ?~a series of stored keystrokes~a large micro computer~is short for macropod~none of the these~A~1~1';
questions[14]='In which programming language does Excel store your macros~Visual Basic for Applications~Fortran~Visual C~VAX BASIC~A~1~1';
questions[15]='You can use macros to:~All options are correct~Create custom functions.~Automate routine tasks.~Create menus and dialog boxes for custom applications.~A~1~1';
questions[16]='When using buttons on your worksheet you can~All options are correct~assign a macro to a button~format the text in a button~move or size a button.~A~1~1';
questions[17]='From which menu can you open the "Record Macro" submenu?~"Tools"~"Insert"~"Format"~"Data"~A~1~1';
questions[18]='With Excel you can~change the toolbars or create new toolbars~change the toolbars only~create new toolbars only~toolbars cannot be customized or created~A~1~1';