Exam Functionality Tutorial
The FP&A Examination will contain spreadsheet based items, as well as multiple-choice items. Below is a video of the exam tutorial, which demonstrates how the testing system works, as well as how to use the spreadsheets within the test. While this tutorial is available for candidates to view at the beginning of their test, it is recommended that candidates review the tutorial in advance of their exam date so that they can use more of the time allotted to the tutorial (20 minutes) to practice with the spreadsheet tool in the sample items provided at the end of the tutorial.
The spreadsheet tool 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 within the exam (in the Spreadsheet Functions tab in the Help window). The list provides information on the financial functions, statistical functions and math and trigonometry functions. Please click here to download a copy of this list. This list is provided for candidates who would like to view it in advance of their exam. Candidates are not required to study the entire list.
A built-in calculator is provided within the exam on all multiple choice items and has two available options: a standard four-function calculator and a scientific calculator. (A financial calculator is not available.) Candidates who prefer a handheld four-function calculator should contact AFP no later than one week before their testing appointment. AFP will submit a request to the testing site. No other calculators will be allowed in the testing room.
Viewers can open the PDF of the tutorial slides and follow along as needed. For the slides of the tutorial below, please click here.
To view in full screen, please click here.
*Please note: New spreadsheet software will be used beginning with the 2016B testing window. The new software is similar to the old software but offers increased reliability and some increase in functionality. An updated tutorial has been posted below.