The world of finance involves a significant amount of number crunching along with the deep understanding of what these numbers mean and how the results of analysis can be used to make decisions. Human aptitude is key in most of finance roles and tools like Excel$$ spreadsheets are designed to assist professionals in performing critical tasks in their job role.

You will be using a lot of Excel in real world finance working with large data sets, financial models within strict deadlines. It is thus important to understand the basic functionality of the tool and learn how to use Excel efficiently.

First things first $-$ What do you think is the purpose of using Excel in Finance? Based on your knowledge of the tool, check all possible applications of Excel in finance from the list given.

$($Note: These options do not create a comprehensive list of how Excel can be used in Finance. Excel can be used in various ways throughout the discipline.$)$ Check all that apply.

Cash flow analysis

Financial planning

Valuation

Data Manipulation & Navigation

Forecasting

Suppose you have been allocated the task of validating the data given in the spreadsheet Excel$\_$in$\_$Finance$\_01.$xlsx and you need to verify that the numbers match the source of this document.

Review the values shown in the spreadsheet and verify if they are correct or not.

Validation

Yes

No

Marketing and sales expense in the year $2007($cell F$14)=926\mathrm{.}61$

Sum of all costs and expenses in the year $2006($cell E$20)=4,287$

Net income value for year $2010$ is located in row $35$ column I

Used with permission from Microsoft$$ Corporation. All rights reserved.

During the course of validating the information on the given spreadsheet with the source, you realize that you need to make some modifications to the worksheet $($specific sheet e$.$g$.$ Sheet $1$ in the workbook$).$ Select the commands$/$syntax that would help you make the changes you desire in the worksheet.

Note: Remember, there may be more than one command or syntax that can help you make the modification. Check all that apply.

Add a new expense under General and administrative expenses. Check all that apply.

Select row $18->$ Right click; Select Insert

Cursor anywhere on row $19$; Right click; Select Insert; Entire row

Cursor on A$19->$ SpaceBar $->-$

Select row $19->$ Right click $->$ Select Insert

Add data for year $2013$ to the right of year $2012$ data. Check all that apply.

Select column K $->$ Right click $->$ Select Insert

Select column L $->$ Right click $->$ Select Insert

Cursor anywhere on column L $->$ Shift$+$SpaceBar $->-$

Cursor on L$7->$ Right click; Select Insert; Entire column

Calculating the sum of the revenues from year $2006$ to $2010.$ Check all that apply.

Cursor at an empty cell $->$ Click on $$

AutoSum $->$ Change the cell selection to E$9$:I$9$

Cursor at an empty cell $->$ Enter $=$SUM$($E$9$:I$9)$

In Excel $2010,$ select cells E$9$:I$9,$ Sum shown at the bottom right of the worksheet

Cursor at an empty cell $->$ Enter $=$E$9+$F$9+$G$9+$H$9+$I$9$

If you were do the same validation and modification tasks for the balance sheet of the same company which supposedly has been provided in Sheet $2$ of the Workbook, you would use the syntax to navigate to the next worksheet. You realize that you accidently reached cell AC$2034$ and you need to navigate back to the location where top of the page where the data resides, you would enter $.$

While you were conducting some calculations, you realize that the values were being incorrectly calculated because the range of the cells would change when you dragged the cell or copied it to another location. Your goal is to make cell E$9$ an absolute reference, which means that if you copy or drag the function to another cell, it will still point to the same cell. You would thus add sign and refer to the cell as