Exam Functionality Tutorial

In previous versions of the exams, data needed to answer a question was presented as an image of a table.  With a Data Set, calculations can be done on the spreadsheet itself or the calculator.  Any work performed in the Data Set spreadsheet will be retained with that question when the Data Set window is closed and/or when the candidate navigates to another question. However, it is important to note that you must click out of a cell to save your work.  If you are typing a number in a cell and you move the next question or close the data set without clicking out of that cell, it will not save. 

The Data Set window can be moved by clicking and holding the left mouse button on the top of the blue bar of the window and dragging the window to a new location.  The window can be resized by clicking and holding the left mouse button on the lower right or lower left corners and dragging the corner to the desired size.   

Click on the “X” or the Close button to close the Data Set window.  

The Data Set spreadsheet works like many commercially available spreadsheets and uses similar syntax for formulas. A searchable list of select spreadsheet functions and their related descriptions is provided here.  This list is provided for candidates who would like to view it.  Candidates are not required to study the list nor are candidates required to use the spreadsheet for calculations.  The standard calculator that has always been included on the CTP exam will still be included.