12 If cell A2 contains the formula =B2 + B3 and you select A2 and then drag the fill handle in the lower-right corner down several cells, what formula now appears in cell A3?

=B2 + B3

=A3=B2+B3

=B3 + B4

=B3 + B2

13 Which of the following is NOT one of the 4 basics of financial modeling that were introduced in this module?

A best practice for financial modeling is that formulas always contain both relative and absolute ($) references

To make models dynamic it is recommended to use separate assumption sections.

Input variables in the assumption section are best formatted with a color that is different from the outputs.

A best practice for financial modeling is to use annotations through comments or text boxes. This can help clarify the purpose or meaning of a model or a specific function/formula.

14 Which of the following is NOT true with regards to the Pivot Table function in Excel?

The Pivot Table function can be found on the Data tab.

A Pivot Table is one of Excels most powerful analytical tools and lets you create summary totals based on list-like data without any formulas.

The 'PivotTable Fields' area lets you add and remove fields to your report

When you work with 'Pivot Tables', this function keeps your source data and does not disrupt it.

15. To create a chart, you begin by

Selecting the column and row headings

Changing the color of your data

Selecting the data range

Determining if you rather want to use a 2 dimensional or 3 dimensional chart