// this file is copyright - Mike Capstick // it adds the quiz questions and answers // load arrays with a set of questions and answers title='Spreadsheet Basics'; questions=new Array(); questions[1] ='In Excel which key provides HELP~F1~F2~F3~F4~A~.'; questions[2] ='The menu command used to save a worksheet under a new name is~Save as~Name~File Open~Edit Save~A~.'; questions[3] ='Which part of the Excel screen shows the name of your file?~The Status bar~Cell A1~The Title bar~The Toolbar~C~.'; questions[4] ='How do you check a document on the screen before you print it?~Choose \'Check\'~You can\'t~Choose Print Preview~Exit from Excel~C~.'; questions[5] ='The cell at the top-left corner of a worksheet is~zero~one~A1~A10~C~.'; questions[6] ='The Active cell is the cell~ containing a formula~ where the range is anchored~ containing the active macro~containing the cursor~D~.'; questions[7] ='By default Excel formats numbers by~ underlining them~right aligning them~ centering them~ none of the above~B~.'; questions[8] ='Which character precedes every Excel function ?~@~=~\\~*~A~.'; questions[9] ='You can change the orientation of a text entry~with Format Cells - Alignment~ by dragging the edge of the cell clockwise~ with Format Cells - Protection~ Excel cannot change Text alignment~A~.'; questions[10] ='Which character is used in absolute cell references~^~+~$~%~C~.'; questions[11] ='To enter numbers as text in Excel start the entry with a~ + ~\' ~ . ~ $~B~.'; questions[12] ='When a formatted number is longer than its cell Excel?~increases the column width~fills the cell with # symbols~sets the number to zero~crashes~B~.'; questions[13] ='The first Spreadsheet program was called~Visicalc ~Multiplan~Lotus123~Excel~A~.'; questions[14] ='Select an entire column with~Edit Select column~Click the column heading letter~Click anywhere in the column~Click the Ctrl and C keys~B~.'; questions[15] ='In Excel you can select~The entire worksheet~Rows~Columns~Worksheets, Rows or Columns~D~.'; questions[16] ='The default extension of Excel files is~Xls~Wk1~123~Exc~A~.';