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 Excel in Finance 1sx - Microsoft Excel Home nsert Page Layout formulas Data Revewew n Finance. Excel can be used in various | ways throughout the discipline. Times New R01-11 custom , Data depiction Cash flow analysis tyles ort& Find & Clipboard Ldtng Quantifying investor instinct Conducting advanced and complex H22 calculations COMPANY. INC Financial modeling ENTS OF INCOME Suppose you have been allocated the task af 9 Reweur validating the data given in the spreadsheet Excel_in_Finance 01.xlsx and you need to verify that the numbers match the source of Hindeses this document. Review the values shown in the spreadsht and verify if they are correct or nat Validation Yes No Marketing and sales expense in the year 2007 (cell F14) 926.61 Sum of all costs and expenses in the ear 2006 (cell E20) ,287 112 1.57 125 Net income value for year 2010 is located in K Sheet1 Sheet2Sheet3 roN 35 column I During the course of validating the information on the given spreadsheet with the source, yourealize that you need to make some modifications to the worksheet (specific sheet e.g. Sheet 1 in the workbook). Select the com mands/syntax that would help youmake the changes you desire in the Note: Remember, there may be more than one command or syntax that can help you make the modification. Check all that apply During the course of validating the information on the given spreadsheet with the source, yourealize that you need to make some modifications to the worksheet (specific sheet e.g. Sheet 1 in the workbook). Select the com mands/syntax that would help youmake the changes you desire in the Note: Remember, there may be more than one command or syntax that can help you make the modification. Check all that apply add anew expense under General and administrative expenses. select row 19 Right dick Select Insert Select row 18 Right dick; Select Insert cursor on A19 SpaceBar - Cursor anywhere on row 19; Right dick; Select Insert; Entire row Add data for year 2013 to the right of year 2012 data. Select column K Right dick Select Insert O cursor anywhere on column L Shift+SpaceBar - Caculating the sum of the revenues from year 2006 to 2010 Cursor at an empty cell-Enter++G9+H9+19 O cursor atJ9 Enter =SUM(E9:13) In Excel 2010, select cells ES:19, Sum shown at the battom right of the worksheet Cursor at an empty cell-Enter-SUM(E9:I9) If you were do the same validation and modification tasks for the balance sheet of the same com pany which supposedly has been provided in Sheet2 of the Workbook, you would use the synta:x AC2034 and you need to navigate back to the lacation where top of the page where the data resides, you would enter to navigate to the next worksheet. You realize that you accidently reached cell 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 lacation. Your goal is to make cell E9 an absolute reference, which means that if you copyn 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 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 Excel in Finance 1sx - Microsoft Excel Home nsert Page Layout formulas Data Revewew n Finance. Excel can be used in various | ways throughout the discipline. Times New R01-11 custom , Data depiction Cash flow analysis tyles ort& Find & Clipboard Ldtng Quantifying investor instinct Conducting advanced and complex H22 calculations COMPANY. INC Financial modeling ENTS OF INCOME Suppose you have been allocated the task af 9 Reweur validating the data given in the spreadsheet Excel_in_Finance 01.xlsx and you need to verify that the numbers match the source of Hindeses this document. Review the values shown in the spreadsht and verify if they are correct or nat Validation Yes No Marketing and sales expense in the year 2007 (cell F14) 926.61 Sum of all costs and expenses in the ear 2006 (cell E20) ,287 112 1.57 125 Net income value for year 2010 is located in K Sheet1 Sheet2Sheet3 roN 35 column I During the course of validating the information on the given spreadsheet with the source, yourealize that you need to make some modifications to the worksheet (specific sheet e.g. Sheet 1 in the workbook). Select the com mands/syntax that would help youmake the changes you desire in the Note: Remember, there may be more than one command or syntax that can help you make the modification. Check all that apply During the course of validating the information on the given spreadsheet with the source, yourealize that you need to make some modifications to the worksheet (specific sheet e.g. Sheet 1 in the workbook). Select the com mands/syntax that would help youmake the changes you desire in the Note: Remember, there may be more than one command or syntax that can help you make the modification. Check all that apply add anew expense under General and administrative expenses. select row 19 Right dick Select Insert Select row 18 Right dick; Select Insert cursor on A19 SpaceBar - Cursor anywhere on row 19; Right dick; Select Insert; Entire row Add data for year 2013 to the right of year 2012 data. Select column K Right dick Select Insert O cursor anywhere on column L Shift+SpaceBar - Caculating the sum of the revenues from year 2006 to 2010 Cursor at an empty cell-Enter++G9+H9+19 O cursor atJ9 Enter =SUM(E9:13) In Excel 2010, select cells ES:19, Sum shown at the battom right of the worksheet Cursor at an empty cell-Enter-SUM(E9:I9) If you were do the same validation and modification tasks for the balance sheet of the same com pany which supposedly has been provided in Sheet2 of the Workbook, you would use the synta:x AC2034 and you need to navigate back to the lacation where top of the page where the data resides, you would enter to navigate to the next worksheet. You realize that you accidently reached cell 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 lacation. Your goal is to make cell E9 an absolute reference, which means that if you copyn 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