MGMT 345 1st Edition Lecture 7Outline of Last Lecture I. Net Neutrality II. Business Process Modeling NotationIII. DefinitionsIV. The First WebpageV. Businesses and DataVI. 3 Technologies that could make the cloud betterOutline of Current Lecture I. Excel Lab #3II. Excel Lab #4Current LectureExcel Lab #3:Highlight the first row and add 5 blank rows before the first date. Using Yahoo Finance, find the ending dates for the previous 3 months and what the last trading value was. To search this, set the date parameters, check the box that says daily then click find prices. Sept 30th $27.23Oct 31st $27.69Nov 28th $28.68To get the new number of shares, click on the value box of the $ added/ subtracted and divide by the NAV box. After that box you can use the formula G3-0 and copy it down. For Monthly Changes highlight the correct boxes and then click the insert tab, select 3D chart. Retitle it and make the background light grey and the chart orange. Delete both legends. Do the same thing again, but select 2D Line chart this time. Take a Snapshot of the charts and submit to D2L.These notes represent a detailed interpretation of the professor’s lecture. GradeBuddy is best used as a supplement to your own notes, not as a substitute.Excel Lab #4:Copy and paste the monthly values into a new worksheet. Add a Row titled VIGRX under the MITTXSearch Yahoo Finance for the correlating values. Once the row has been filled in, highlight the information and click the insert tab. Then click create 3D Area Chart. Delete the bottom legend. Add the title “Comparative Performance”Do the same thing again, but this time select 2D Line Chart. Take a snapshot and submit to
View Full Document
Unlocking...