Student ID: 21709822 Exam: 038229RR - Microsoft Excel When you have completed your exam and reviewed your answers‚ click Submit Exam. Answers will not be recorded until you hit Submit Exam. If you need to exit before completing the exam‚ click Cancel Exam. Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break‚ so be sure that you have seen the entire question and all the answers before choosing an answer. 1. The order of
Premium Spreadsheet Microsoft Excel
FIN 320 EXCEL SHEET Problems Please solve the problems below using an excel sheet and the excel functions. 1) (15 pts) A firm is considering a project with an initial investment of $170‚000 and required return of 12%. The following cash flows are expected over the 8year life span of the project: Year Cash flows 1 35‚300 2 46‚200 3 50‚000 4 22‚620 5 15‚100 6 5‚200 7 11‚740 8 89‚300 a) Calculate the Net Present Value (NPV) of the project. Should the
Premium Cash flow Cash
responsibility‚ they set their companies up for wasted investments and missed opportunities. Six IT Decisions Your IT People Shouldn’t Make by Jeanne W. Ross and Peter Weill Included with this full-text Harvard Business Review article: 1 Article Summary The Idea in Brief—the core idea The Idea in Practice—putting the idea to work 2 Six IT Decisions Your IT People Shouldn’t Make 10 Further Reading A list of related materials‚ with annotations to guide further exploration of the article’s ideas
Premium Management Strategic management
Is Nick carraway a reliable narrator? In the beginning of the book‚ The Great Gatsby‚ Nick could be described as the main character but as the book goes on Nick is having more of a secondary role‚ instead of the primary role which he was supposed to be. The Great Gatsby is shown through the eyes of one man. We as the readers don’t know whether or not whatever Nick says is correct or true. A good narrator doesn’t judge people but Nick does this a lot. We see how he changes at different points in
Premium F. Scott Fitzgerald The Great Gatsby
HARVARD BUSINESS SCHOOL EXCEL COURSE All Masters programs in the Lindner College of Business involve coursework that presumes facility with spreadsheets. In Statistics‚ Managerial Accounting‚ and Financial Tools‚ spreadsheets are indispensible tools. In a host of other classes they enable superior analysis‚ organization‚ communication‚ and planning as well. Therefore‚ before starting coursework in any Masters program‚ students must PASS the On-line Introduction to Spreadsheet Modeling Course available
Premium Microsoft Microsoft Excel Spreadsheet
CanDo Consulting Don’t let your Profits Walk out the Door… Memo To: Northwind Traders From: Tina Thompson CC: Professor Michael Jones Date: 6/5/2013 Re: Revenue Assessment Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided‚ which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore‚ our recommendations
Premium Sales Revenue Marketing
Financial Analysis using Excel Function Information requirements for function Dates Prices and par values Frequency‚ and related Yields and interest/ discount rates Discount Any amount paid at maturity ? Frequency of payme nts pa First coupon Redemption amount Investment amount # of periods Settlement Par/coupon Maturity COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT
Premium Spreadsheet
employers look for employees with the skills and knowledge to send email messages‚ create spreadsheets and graphs‚ to edit or put data information in a database and to create reports. Microsoft Excel is an electronic spreadsheet program that can be used for storing‚ organizing and manipulating data. Microsoft Excel is made up of little squares on the screen. You can also resize the columns in Microsoft Excel to adjust to the size you need them to be. You can put information such as data types that
Premium Spreadsheet Microsoft Office Microsoft
Overview of formulas Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example‚ the following formula multiplies 2 by 3 and then adds 5 to the result. =5+2*3 A formula can also contain any or all of the following: functions‚ references‚ operators‚ and constants. Parts of a formula Functions: The PI() function returns the value of pi: 3.142... References: A2 returns the value in cell A2. Constants: Numbers or text
Premium Algebra Mathematics Function
300 office tips • Special feature Microsoft Excel 75 tips and tricks for your favourite spreadsheet. You can convert rows to columns (and columns to rows) by highlighting the cells you want to switch around‚ clicking on Edit‚ Copy‚ selecting a new cell and then going to Edit‚ Paste Special… Finally‚ place a tick in the Transpose box on the dialog box and click on OK. 1 Convert rows to columns the running total of the figures in A1 to A5 in the adjacent column. Enter in a cell the formula
Premium Graphical user interface Spreadsheet Microsoft