Description of this paper





Question;QUESTION 11.In Tab ?Question 1? name the ranges containing theCOGSfor Year 1, and Year 2 and calculate the Total COGS for those years using the formula:COGS_Yr1+COGS_Year21.Attach FileAttach Local File10 pointsQUESTION 21.In Tab ?Question 2? use the VLookup function to get theSalaryfor the following employees (copy the list below, paste it to the worksheet for question 2 and use Vlookup to get the Salary):Employee ID3921259465297276290976821281615798018824639128668413121.Attach FileAttach Local File10 pointsQUESTION 31.Answer question 3 in tab ?Question 3?.You are considering the followingtwo mutually exclusive projects. The required rate of return is 10.50 percent for projectAand 12.75 percent for projectB.Which project should you accept and why?Clearly demonstrate your knowledge of the NPV function in Excel in your answer.YearProject AProject B0-$100,000-$126,9001$50,400$ 69,7002$75,300$ 80,9003$11,700$ 01.Attach FileAttach Local File10 pointsQUESTION 41.Answer this question in the tab Question 4.Demonstrate your knowledge of the IF statement and calculate the total sales forPlanner BONEIL.1.Attach FileAttach Local File10 pointsQUESTION 51.Using the data in tab ?Question 5?, use conditional formatting in the following situations:a) Highlight in RED theStore Nameof each Store that was opened in the Year2010.b) Highlight in GREEN those COGSover$20,000.1.Attach FileAttach Local File10 pointsQUESTION 61.Answer this question in tab Question 6.UsingFiltersfind all stores that are inCENTRO NORTEand were opened in2003.1.Attach FileAttach Local File10 pointsQUESTION 71.Answer question 7 in the appropriate tab.You are entering in the cell range D5:D23 the dates of transactions that occurred during July 2012. Enter adata validationsetting that ensures that each date entered occurs inJuly 2012.1.Attach FileAttach Local File10 pointsQUESTION 81.Insert aPivot Tablein the Tab for Question 8 that shows theUnits SoldbyPlanner Code.What is the total Qty Sold inQuarter 1(Jan+Feb+Mar)for plannerKIANDERS?Hint: you must group by quarter.1.Attach FileAttach Local File10 pointsQUESTION 91.In tab Question 9Record a Macroto record the following actions:1- Call the Macro:question92- Sort the table byCustomer Name, then byDepartment3- Apply Filters to all the columns3- In Cell E3 type your name.Grading Criteria:- Getting the Macro to work - 100%1.Attach FileAttach Local File10 pointsQUESTION 101.In tab Question 10 - Use theSubtotal command for the following computation: Find the totalUnits Sold for theMonth of Sept 20121.Attach File


Paper#48230 | Written in 18-Jul-2015

Price : $31