Financial Modeling with Excel
Exam Answer Key
Course Introduction
Financial Modeling with Excel introduces students to the fundamental techniques and best practices for building robust financial models using Microsoft Excel. The course covers essential topics such as forecasting financial statements, valuing investment projects, performing sensitivity and scenario analysis, and constructing dynamic models for decision-making purposes. Through hands-on exercises and real-world case studies, students will develop practical skills in leveraging advanced Excel functions, data visualization tools, and automation features to analyze financial data, assess business performance, and support strategic financial planning. By the end of the course, participants will be equipped to create professional, error-free models tailored to a variety of corporate finance and investment contexts.
Recommended Textbook
New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st Edition by June Jamrich
Available Study Resources on Quizplus
13 Chapters
935 Verified Questions
935 Flashcards
Source URL: https://quizplus.com/study-set/2189 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43584
Sample Questions
Q1) Ctrl + G is used to access the ____.
A) Go to Next worksheet command
B) G column
C) Go to a location in the worksheet command
D) formula view
Answer: C
Q2) AutoFit changes the column width or row height to display the longest or tallest entry within the column or row._________________________
A)True
B)False
Answer: True
Q3) A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
Answer: planning analysis sheet
Q4) A(n)____________________ is a grouping of text and numbers in a rectangular grid or table.
Answer: spreadsheet
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin._________________________
A)True
B)False
Answer: False
Q2) In Excel,dates are _____-aligned in the cell by default,regardless of date format.
A) right
B) left
C) center
D) top
Answer: A
Q3) Information that prints on each page,like a company name or logo,may be set as a
A) print setup
B) copied text
C) text header
D) print title
Answer: D
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43586
Sample Questions
Q1) Excel functions are organized into ____ categories.
A) 8
B) 10
C) 11
D) 13
Answer: D
Q2) A constant is a value in a formula that doesn't change._______________
A)True
B)False
Answer: True
Q3) Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.
A) #####
B) #Value
C) #N/A
D) Value not found
Answer: C
Q4) The ____________________ is the middle value from a sample.
Answer: median
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43587
Sample Questions
Q1) Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.
A) select the chart
B) hold down the SHIFT key
C) adjust the sizing handles
D) move the mouse pointer to the center of the chart.
Q2) A chart that compares three set of values in a three-dimensional chart is _____.
A) Stock
B) Radar
C) Surface
D) Scatter
Q3) By default,Excel inserts a chart as an embedded chart._________________________
A)True
B)False
Q4) Each slice in a pie chart represents a single value from a data series.____________
A)True
B)False
Q5) Each value from a data series is represented by a ________.
Q6) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Excel Tables, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43588
Sample Questions
Q1) You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.
A) Filtering
B) Formatting
C) Editing
D) Text
Q2) The second sort field in a sort is called the ____________________ field.
Q3) When you create a table,if your data does not contain column headers,Excel adds headers with default names.
A)True
B)False
Q4) You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.
A) Home
B) View
C) Table Tools Design
D) PivotTable
Q5) A(n)____________________ list indicates the sequence in which you want data ordered.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) Which of the following statements about hyperlinks in Excel workbooks is correct?
A) They are usually represented by bold faced words with underlines or images.
B) They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook.
C) They cannot be used to jump to other types of files or sites on the Web.
D) To use a hyperlink, you can click anywhere in the cell that contains the link, including white space in the cell or any text that flows into an adjacent cell.
Q2) Hyperlinks are usually represented by words with colored letters and underlines or images._________________________
A)True B)False
Q3) After you have saved a template,you can access the template from the New screen in ____________________ view.
Q4) A(n)template is a workbook with labels,formats,and formulas already built into it with data removed._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) Range names can be up to _____ characters.
A) 15
B) 27
C) 56
D) 255
Q2) Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.
A)True
B)False
Q3) Every cell in a workbook has a(n)locked property that determines whether or not changes can be made to that cell._________________________
A)True
B)False
Q4) The Excel data _____ feature restricts data entry to follow a defined set of rules.
A) error-checking
B) rule-based
C) validation
D) contingent
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
Sample Questions
Q1) An error value begins with a(n)_____ followed by an error name that indicates the type of error.
A) number sign
B) asterisk
C) exclamation point
D) plus sign
Q2) The ORERROR function can determine if a cell contains an error value and then display the message you choose.
A)True
B)False
Q3) The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.
A) THIS
B) IF
C) WHEN
D) NOT
Q4) The IF function evaluates a(n)single condition._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43592
Sample Questions
Q1) A(n)_______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.
A) tracer
B) outline
C) index
D) key
Q2) An interest rate that compares the value of current dollars to future dollars from a series of cash flows
A)PPMT function
B)rate of return
C)IPMT function
D)IRR
E)PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function
Q3) How do you determine which method of depreciation is most appropriate?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) Binding constraints always show a slack of _______.
A) -0.01
B) 0
C) 0.01
D) 1
Q2) Places limits on a problem's solution,in Solver
A)Solver
B)changing
C)constraint
D)add-in
E)answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result
Q3) Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Analyzing Data With Business Intelligence
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43594
Sample Questions
Q1) To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.
A)True
B)False
Q2) Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.
A)True
B)False
Q3) Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.
A)True
B)False
Q4) You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.
A) Data
B) Diagram
C) Database
D) None of the above
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43595
Sample Questions
Q1) In a shared workbook,all edits are stored in a tracking log for 60 days.
A)True
B)False
Q2) A _______ Excel workbook tracks the changes made by different people so everyone can examine when and where each change was made.
A) merged
B) shared
C) saved
D) combined
Q3) _______ displays an object in the destination file,but only stores the location of the source file.
A) Copy and Paste
B) Linking
C) Embedding
D) Inserting
Q4) Excel tracks the changes made to a shared workbook,recording the name of the user who made the changes and when the changes were saved.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Working With Text Functions
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/43583
Sample Questions
Q1) The Search text function returns the number of characters at which the locate_character is first found reading from left to right.
A)True
B)False
Q2) The PROPER function replaces existing text with new text.
A)True
B)False
Q3) You can separate data with a:
A) Tab
B) Semicolon or comma
C) Space
D) All of the above
Q4) To help users edit and correct the text values in their workbooks,Excel provides _____ functions.
A) Text
B) Proof
C) Design
D) Symbol
To view all questions and flashcards with answers, click on the resource link above.
Page 15