Adventis Financial Modeling Certification (FMC) Level 1
ADVENTIS FINANCIAL MODELING CERTIFICATION FMC LEVEL 1 |
COMPLETE EXAM QUESTIONS AND VERIFIED SOLUTIONS | LATEST
VERSION (PASS GUARANTEE)
ADVENTIS FINANCIAL MODELING CERTIFICATION
(FMC®) LEVEL 1
Page 1 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
1. Which sequence opens the “Go To Special” dialog in Excel (Windows)?
A. Ctrl+G
B. Ctrl+Shift+End
C. F5, then Alt+S
D. Ctrl+Alt+G
ANSWER : C. Pressing F5 opens the Go To dialog; clicking Special (Alt+S)
opens Go To Special, used to select formulas, constants, blanks, etc.
2. What is the primary purpose of using an absolute reference (e.g., $A$1) in a
formula?
A. To make the workbook print faster
B. To lock a cell reference so it does not shift when the formula is copied
C. To convert a value into a percentage
D. To hide the referenced column
ANSWER : B. The dollar signs freeze the row and/or column reference so it
stays fixed when the formula is copied to other cells.
3. Which shortcut selects the direct precedents of the active formula cell?
A. Ctrl+[
B. Ctrl+]
C. Ctrl+`
D. Ctrl+/
ANSWER : A. Ctrl+[ selects cells that are directly referenced by (precede)
the active formula; Ctrl+] does the reverse (dependents).
4. In standard financial-modeling color conventions, blue font typically indicates:
A. A formula
B. A hardcoded input or assumption
Page 2 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
C. A link to another worksheet
D. A formula error
ANSWER : B. Blue is the near-universal convention for hardcoded inputs so
that assumptions are instantly identifiable and auditable.
5. In standard financial-modeling color conventions, black font typically indicates:
A. A hardcoded input
B. A formula calculated within the same worksheet
C. A link to another workbook
D. An assumption to be updated
ANSWER : B. Black is conventionally reserved for formulas that calculate
using cells on the same sheet.
6. Green font is commonly used in modeling conventions to denote:
A. A formula error
B. A link pulling data from another worksheet within the same workbook
C. A hardcoded assumption
D. A rounding adjustment
ANSWER : B. Green typically flags a cell that references another tab,
alerting the reader that the value originates elsewhere in the workbook.
7. After selecting a cell reference inside a formula, pressing F4 repeatedly will:
A. Delete the reference
B. Cycle the reference through relative and absolute forms (A1, $A$1, A$1,
$A1)
C. Open the Format Cells dialog
D. Force a full workbook recalculation
ANSWER : B. F4 toggles the selected reference through its four
relative/absolute combinations, saving the need to type dollar signs manually.
8. Which function is typically used to suppress a formula's #N/A or #DIV/0! error
and return a cleaner result instead?
A. IFERROR
B. VLOOKUP
C. OFFSET
D. INDIRECT
Page 3 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
ANSWER : A. IFERROR wraps a formula and returns a specified value (e.g.,
0 or a blank) if the formula would otherwise return an error.
9. Best practice discourages typing a hardcoded number directly inside a formula
(e.g., =B5*1.03) mainly because:
A. It slows down Excel's calculation engine
B. It buries an assumption inside a formula, breaking the audit trail and making
updates error-prone
C. Excel does not allow constants in formulas
D. It always creates a circular reference
ANSWER : B. Hardcoding within a formula hides the assumption from view
and forces anyone updating it to hunt through formulas rather than a labeled
input cell.
10. Which pair of functions is commonly combined to look up a value using both
row and column criteria with more flexibility than VLOOKUP alone?
A. VLOOKUP and MATCH
B. INDEX and MATCH
C. SUMIF and COUNTIF
D. OFFSET and CHOOSE
ANSWER : B. INDEX/MATCH looks up a value's position with MATCH and
returns the corresponding value with INDEX, avoiding VLOOKUP's
requirement that the lookup column be leftmost.
11. A circular reference in Excel occurs when:
A. A formula directly or indirectly refers back to its own cell
B. A chart is linked to an empty range
C. A workbook references a file that has been renamed
D. A named range spans multiple sheets
ANSWER : A. A circular reference exists whenever a calculation chain loops
back to include the originating cell.
12. In a 3-statement or LBO model, circular references most commonly arise
because:
A. Depreciation is calculated on a straight-line basis
B. Interest expense depends on a revolver/cash sweep balance that is itself
affected by interest expense
C. The tax rate is assumed constant
Page 4 of 54
ADVENTIS FINANCIAL MODELING CERTIFICATION FMC LEVEL 1 |
COMPLETE EXAM QUESTIONS AND VERIFIED SOLUTIONS | LATEST
VERSION (PASS GUARANTEE)
ADVENTIS FINANCIAL MODELING CERTIFICATION
(FMC®) LEVEL 1
Page 1 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
1. Which sequence opens the “Go To Special” dialog in Excel (Windows)?
A. Ctrl+G
B. Ctrl+Shift+End
C. F5, then Alt+S
D. Ctrl+Alt+G
ANSWER : C. Pressing F5 opens the Go To dialog; clicking Special (Alt+S)
opens Go To Special, used to select formulas, constants, blanks, etc.
2. What is the primary purpose of using an absolute reference (e.g., $A$1) in a
formula?
A. To make the workbook print faster
B. To lock a cell reference so it does not shift when the formula is copied
C. To convert a value into a percentage
D. To hide the referenced column
ANSWER : B. The dollar signs freeze the row and/or column reference so it
stays fixed when the formula is copied to other cells.
3. Which shortcut selects the direct precedents of the active formula cell?
A. Ctrl+[
B. Ctrl+]
C. Ctrl+`
D. Ctrl+/
ANSWER : A. Ctrl+[ selects cells that are directly referenced by (precede)
the active formula; Ctrl+] does the reverse (dependents).
4. In standard financial-modeling color conventions, blue font typically indicates:
A. A formula
B. A hardcoded input or assumption
Page 2 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
C. A link to another worksheet
D. A formula error
ANSWER : B. Blue is the near-universal convention for hardcoded inputs so
that assumptions are instantly identifiable and auditable.
5. In standard financial-modeling color conventions, black font typically indicates:
A. A hardcoded input
B. A formula calculated within the same worksheet
C. A link to another workbook
D. An assumption to be updated
ANSWER : B. Black is conventionally reserved for formulas that calculate
using cells on the same sheet.
6. Green font is commonly used in modeling conventions to denote:
A. A formula error
B. A link pulling data from another worksheet within the same workbook
C. A hardcoded assumption
D. A rounding adjustment
ANSWER : B. Green typically flags a cell that references another tab,
alerting the reader that the value originates elsewhere in the workbook.
7. After selecting a cell reference inside a formula, pressing F4 repeatedly will:
A. Delete the reference
B. Cycle the reference through relative and absolute forms (A1, $A$1, A$1,
$A1)
C. Open the Format Cells dialog
D. Force a full workbook recalculation
ANSWER : B. F4 toggles the selected reference through its four
relative/absolute combinations, saving the need to type dollar signs manually.
8. Which function is typically used to suppress a formula's #N/A or #DIV/0! error
and return a cleaner result instead?
A. IFERROR
B. VLOOKUP
C. OFFSET
D. INDIRECT
Page 3 of 54
, Adventis Financial Modeling Certification (FMC) Level 1
ANSWER : A. IFERROR wraps a formula and returns a specified value (e.g.,
0 or a blank) if the formula would otherwise return an error.
9. Best practice discourages typing a hardcoded number directly inside a formula
(e.g., =B5*1.03) mainly because:
A. It slows down Excel's calculation engine
B. It buries an assumption inside a formula, breaking the audit trail and making
updates error-prone
C. Excel does not allow constants in formulas
D. It always creates a circular reference
ANSWER : B. Hardcoding within a formula hides the assumption from view
and forces anyone updating it to hunt through formulas rather than a labeled
input cell.
10. Which pair of functions is commonly combined to look up a value using both
row and column criteria with more flexibility than VLOOKUP alone?
A. VLOOKUP and MATCH
B. INDEX and MATCH
C. SUMIF and COUNTIF
D. OFFSET and CHOOSE
ANSWER : B. INDEX/MATCH looks up a value's position with MATCH and
returns the corresponding value with INDEX, avoiding VLOOKUP's
requirement that the lookup column be leftmost.
11. A circular reference in Excel occurs when:
A. A formula directly or indirectly refers back to its own cell
B. A chart is linked to an empty range
C. A workbook references a file that has been renamed
D. A named range spans multiple sheets
ANSWER : A. A circular reference exists whenever a calculation chain loops
back to include the originating cell.
12. In a 3-statement or LBO model, circular references most commonly arise
because:
A. Depreciation is calculated on a straight-line basis
B. Interest expense depends on a revolver/cash sweep balance that is itself
affected by interest expense
C. The tax rate is assumed constant
Page 4 of 54
