When structuring a financial model in Excel, it is ideal that

Processing is broken down into simple steps

Processing is as detailed and complicated as possible

Inputs are entered more than once whenever needed

Outputs are kept at the very end of the model so they are not quickly accessible

Earnings Before Interest, Taxes, Depreciation and Amortization

Earnings Behalf of Interest, Taxes, Depreciation and Amortization

Earnings Before Income Taxes, Depreciation and Amortization

Earnings Between Interest, Taxes, Depreciation and Amortization

1) Which of the descriptions listed below best describe what a macro in Excel does?

c) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks.

a) It is a type of formatting you can apply to enlarge the worksheet area.

b) It is a file type that you save a workbook as.

d) It is a recording function that allows you to save worksheets, audio recordings and videos that are displayed on the screen.

2) Study the screenshot above. What is the appropriate action to take when a workbook displays this message ( Security Warning Macros have been disabled)?

b) Check where the file originates from, and if it is a trusted source or your own workbook, click Enable Content.

a) Close it immediately and delete the file.

c) Close the file then right-click and rename it before opening it again.

d) None of the options listed above are correct.

3) Study the screenshot above. Where will you find the option to launch the Macros dialog box?

c) Under the Developer tab on the Ribbon, in the Code group.

a) Under the Insert tab on the Ribbon, in the Macros group.

b) Under the Formulas tab on the Ribbon, in the Functions group.

d) Under the Developer tab on the Ribbon, in the Add-Ins group.

4) If you wanted to replace the INDEX-MATCH formula, used in question 3 above, with a VLOOKUP formula, which of the following would yield the same result as the INDEX-MATCH formula, when entered into the highlighted cell in the screenshot above question 3?

a) Format selected cells with bold, green font color, blue border lines.

b) Insert a formula into a selected cell.

c) Print a selected section of a worksheet.

6) Workbooks that contain macros must be saved in the following format:

d) Excel Macro-Enabled Workbook (.xlsm)

b) Microsoft Office Macro-Enabled File (.mef)

7) Study the screenshot above. Which part of the process of creating a macro is reflected in this image?

b) A macro recording is in progress.

a) No macro has been recorded yet.

c) A macro has already been recorded and is busy running.

8) How can you view and delete macros that have been created in a worksheet?

d) All of the options listed above are correct.

a) Press Alt+F8, select the macro to be deleted and click delete.

b) Under the Developer tab, click on the Macros button in the Code group. Select the macro to delete and click delete.

c) Press Alt+F11. Click on Tools and select Macros. Select the macro to delete and click delete.

9) Where do you assign a Macro to a button on the Ribbon?

a) In the Customize the Ribbon area of the Excel Options dialog box.

b) In the Record Macro dialog box.

d) Under the Insert tab on the Ribbon, select Insert Macro Icon.

10) While busy recording a macro, you made a mistake. What is the best course of action?

b) You should re-record the macro.

a) You can pause the macro and click Rewind to fix it.

d) None of the options listed above are correct.

What are the three main things that the financial manager can accomplish by building a long-term financial model for the firm?

Identify important linkages among the components of the firm's financial statements

Analyze the impact of a potential business plan

6) Workbooks that contain macros must be saved in the following format:

d) Excel Macro-Enabled Workbook (.xlsm)

b) Microsoft Office Macro-Enabled File (.mef)

What’s a Data Table?

Data table commands are powerful commands that make it possible to do complex sensitivity analyses.

Data table commands are powerful commands that help us to create tables in Excel.

Data table commands are powerful commands that help us to create charts in Excel.

How do you access Data Table command in Excel?

Data|What-if Analysis|Data Table

Data|Analysis Toolpak|Data Table

Excel data tables are array functions. What does it mean?

An array function is a formula that can perform multiple calculations on one or more items in an array

Multiple cells of excel are merged together to create one group.

An array is a group of excel cells.

An array function has multiple formula embedded inside one formula.

What is the difference between a One-Dimensional Data Table and a Two-Dimensional Data Table?

One-Dimensional performs sensitivity analysis by varying one formula using one parameter while Two-Dimensional does the same by changing two parameters.

One-Dimensional and Two-Dimensional are different in the number of formulas and parameters they can handle.

One-Dimensional performs sensitivity analysis by varying one formula using one parameter while Two-Dimensional varies two formula by changing two parameters.

One-Dimensional and Two-Dimensional are the same with a difference in the number of formulas they can handle.

Excel Data Tables Are Arrays. What does it mean?

This means that Excel data tables are dynamically linked to your initial example

This means that Excel data tables are static in nature.

This means that Excel data tables have multiple formulas linked together.

This means that Excel data tables are grouped together.

Financial Modeling MCQs

Quiz

•

Business

•

University

•

Practice Problem

•

Hard

Dr. Vadodara)

FREE Resource

47 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can activate a cell by

Pressing the Tab key

Clicking the cell

Pressing an arrow key

All of above

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A worksheet range is a

A command used for data modeling

A range of values such as from 23 to 234

A group of cells

A group of worksheets

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to generate values for a target output by changing multiple inputs and setting multiple constraints on the inputs, you should use the ______ function in Excel.

Solver

Scenario

Goal Seek

Data Table

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

which of the following VLOOKUP formulas should be entered in cell B2 to show the result "8.2%"

=VLOOKUP(B1,A5:C8,2,FALSE)

=VLOOKUP(B1,A5:C8,2,TRUE)

=VLOOKUP(B1,A5:C8,3,FALSE)

=VLOOKUP(B1,A5:C8,3,TRUE)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the keyboard shortcut keys to insert Excel function arguments automatically?*

Ctrl + A

Ctrl + F3

Ctrl + Shift + K

Ctrl + Shift + A

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A financial analyst wants to sensitize the gross profit of a company using two major inputs: gross margin (horizontal inputs) and sales growth percentage (vertical inputs). Given the screenshot below, what values should be entered for the row input cell and column input cell to generate the data table?*

Row input cell: B11; column input cell: A12

Row input cell: A12; column input cell: B11

Row input cell: B3; column input cell: B2

Row input cell: B2; column input cell: B3

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The best financial models should (choose the best option from below)

Keep things as simple as possible while provides sufficient detail for decision making

Offer users a high degree of detail and precision

Be easy to follow and audit

Be very simple and have the minimum level of detail

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Business Information Systems

Quiz

•

University

50 questions

NCC kopma Quiz

Quiz

•

University

50 questions

THC 1 - Macro Perspective of Tourism & Hospitality

Quiz

•

University

50 questions

Kuiz Perniagaan STPM Sem 1

Quiz

•

University

47 questions

Management Foundation

Quiz

•

University

45 questions

BSHM 50 - LONG QUIZ

Quiz

•

University

50 questions

Pemasaran dan STP - KEWIR ARSI GNP 23/24

Quiz

•

University

45 questions

Administrasi Pajak

Quiz

•

10th Grade - University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Business

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

Financial Modeling MCQs

47 questions

You can activate a cell by

A worksheet range is a

If you want to generate values for a target output by changing multiple inputs and setting multiple constraints on the inputs, you should use the ______ function in Excel.

which of the following VLOOKUP formulas should be entered in cell B2 to show the result "8.2%"

What are the keyboard shortcut keys to insert Excel function arguments automatically?*

The best financial models should (choose the best option from below)

When structuring a financial model in Excel, it is ideal that

Which of the following is not a core building block of a robust financial model?

1. --------------------- = total assets/common equity

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business