ADVENTIS FINANCIAL MODELING CERTIFICATION FMC LEVEL 1 | COMPLETE EXAM QUESTIONS AND VERIFIED SOLUTIONS | LATEST VERSION

ADVENTIS FINANCIAL MODELING CERTIFICATION FMC
LEVEL 1 | COMPLETE EXAM QUESTIONS AND VERIFIED
SOLUTIONS | LATEST VERSION




Adventis Financial Modeling Certification (FMC) Level 1




1. What is the keyboard shortcut to "Edit Active Cell" in Excel?
A. F2
B. F4
C. F5
D. Alt + E
ANSWER : A


2. Which of the following is NOT a best practice for financial modeling?
A. Using hard-coded numbers directly in formulas
B. Keeping assumptions on a separate sheet
C. Using consistent formatting
D. Using error checks
ANSWER : A

,3. What does the keyboard shortcut Ctrl + Shift + Enter do in older
versions of Excel?
A. Enters a formula as an array
B. Closes the active workbook
C. Inserts a new row
D. Applies currency formatting
ANSWER : A


4. Which function is used to look up a value in a table by row?
A. VLOOKUP
B. HLOOKUP
C. INDEX MATCH
D. OFFSET
ANSWER : A (Though INDEX MATCH is often preferred, VLOOKUP is the
classic definition).


5. What is the result of =SUM("10", 20, TRUE)?
A. 30
B. 31
C. Error
D. 10
ANSWER : B (Text "10" converts to 10, TRUE converts to 1).


6. Which Excel tool is used to test different values for inputs without
changing the data permanently?
A. Scenario Manager
B. Goal Seek
C. Solver

,D. Data Table
ANSWER : D


7. What is the shortcut to toggle between absolute and relative references
(e.g., A1 to $A$1)?
A. F4
B. F2
C. F5
D. Alt + F4
ANSWER : A


8. Which of these is a volatile function?
A. SUM
B. IF
C. NOW()
D. VLOOKUP
ANSWER : C (Volatile functions recalculate every time the sheet changes).


9. What does the IFERROR function do?
A. Checks if a cell is an error and returns a specified value
B. Counts the number of errors
C. Highlights errors in red
D. Ignores errors in calculation
ANSWER : A


10. Which function returns the number of periods for an investment?
A. PV
B. NPER

, C. RATE
D. FV
ANSWER : B


11. In a circular reference, which Excel setting allows iterative
calculations?
A. File > Options > Formulas > Enable iterative calculation
B. Data > What-If Analysis
C. Review > Enable Iterations
D. Formulas > Calculation Options > Manual
ANSWER : A


12. What is the shortcut to insert a new worksheet?
A. Shift + F11
B. Alt + Insert
C. Ctrl + N
D. Ctrl + W
ANSWER : A


13. Which function combines text from multiple cells?
A. COMBINE
B. TEXTJOIN
C. CONCATENATE
D. Both B and C
ANSWER : D


14. What is the purpose of "Blue" font color in standard financial
modeling formatting?