You may also be interested in:


FP&A Exam Tips: Worksheet Simulation Section

  • By Jim Morales, FP&A
  • Published: 4/27/2016
The following article was excerpted from the FP&A Exam Preparation Blog. Visit the blog for more helpful tips on preparing for the FP&A Exam.

After you get through the multiple choice section in part one of the FP&A Exam, it’s time to take on the worksheet simulation section. The following is my take on that section.

Worksheet simulation section

Time was more of a factor for me on this section, I did feel a bit rushed, but I was able to do two full passes.

First off, be sure to review the exam functionality tutorial before you take the test. The exam spreadsheet does not function exactly like Excel.  For example, there is no dragging of corners to pull formulas down either.

The problems were generally fair and also required synthesis of material, not just memorization/plugging and chugging of formulas. There were some stretch questions which I appreciated, but nothing totally unreasonable. I would say that some of the questions on my exam could have been multiple choice, since I didn’t think these were really testing your spreadsheet skills.

Overall, I think I did okay on this section. I think I had the right approach to some questions, but I may have messed up a calculation or two.

Final thoughts

The post exam functionality in the learning system allows you to cross out the answers you eliminated. This is something that I hope will eventually be included in the test taking software; it helps with the review and narrowing down choices.

Overall I thought exam experience was positive and enjoyable. I felt challenged and I definitely feel those who pass will represent the industry niche well. I am curious now to compare my experience to others. I can see why some may have been caught off guard but I didn't think the exam was unfair.

So now you’ve made it through all of part one. We’ll cover part two in my next posts.

Jim Morales, FP&A, is Manager of Business Planning & Strategy for U.S. Gas & Electric Inc.
Negotiation Skills for Finance and Treasury Professionals

Monday, December 16th and Wednesday, December 18th, 2019
10:00 AM - 12:00 PM ET
Attendees will learn to negotiate more effectively, prepare for negotiations more efficiently individually and as teams, and better understand the needs and interests of stakeholders and external parties.

Register Now

Copyright © 2019 Association for Financial Professionals, Inc.
All rights reserved.