Skip to content

Excel Formulas For Financial Analysts Practice Exam

Test yourself under real exam conditions: 50 timed questions, 60 on the clock, pass mark 70%%. Instant score with a full review of everything you got wrong. Free — no account needed.

📝 50 questions · ⏱ 60 minutes · 🎯 Pass mark 70% · 🆓 Free, no signup
Start Practice Exam → 🃏 View Flashcards 📚 Read the Textbook

Exam details

  • ✓50 questions drawn from 164 cards
  • ✓Countdown timer — auto-submits when time runs out
  • ✓Pass mark 70% (real certification threshold)
  • ✓Full review of wrong answers at the end
  • ✓No signup required — save your score with a free account

Sample Questions

5 shown

NPV formula in Excel?

Show ▼

=NPV(rate, value1, value2, ...) + initial_investment — NPV discounts from period 1; include the initial outflow (often negative) separately.

IRR formula?

Show ▼

=IRR(cashflows) — first cashflow usually negative (investment), then inflows.

XNPV vs NPV?

Show ▼

NPV: assumes equal-period intervals.
XNPV(rate, values, dates): handles irregular dates.

XIRR vs IRR?

Show ▼

IRR: equal periods.
XIRR(values, dates): irregular dates — used when actual cash flow timing varies.

INDEX/MATCH pattern?

Show ▼

=INDEX(returnRange, MATCH(lookupValue, lookupRange, 0)) — more flexible than VLOOKUP.

🎯 Take the Excel Formulas For Financial Analysts Practice Exam