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 hereto 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 Pearson VUE directly in order to confirm that a calculator will be available.  In the event that the test center cannot provide a standard four-function calculator, please contact AFP directly in order to 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 that this video reflects the exam format for the 2014 - 2019A exams.  A tutorial for the 2019B - 2024A exams will be posted in the upcoming weeks.  Screenshots of the 2019B-2024A tutorials can be found here:  Part I  Part II

A browser-version of the spreadsheet is available for candidates to familiarize themselves with the software. Please click here to access the practice spreadsheet.