Excel Crash Course Exam - [Wall Street Prep] Questions & Answers (Scored 98%) Latest 2024

Identify the commands to insert a comment and delete a comment 1)Alt e m 2) Alt e m 1)Alt h e m 2) Alt I m 1)Shift F2 2) Alt h e m 1)Alt h e m 2) Alt I s {Ans: The correct answer is Shift F2, Alt h e m. Alt e m is a shortcut to open the menu to move or copy a selected sheet. Alt I s is the shortcut to insert a symbol.}What is the NPV of these cash flows, assuming end of period discounting? Round to nearest whole number and use comma separator, so if your answer is 1,578.6, input 1,579. Don't input currency symbols or any extra spaces {Ans: The correct answer is 4,648 Using the NPV formula: =NPV(D7,D6:H6). D7 is the "rate" argument for the NPV function; D6:H6 is the range containing the cash flows to be discounted.}Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "animal lover" for users who have at least 1 dog and at least one cat, and outputs "lonely person" when those conditions are not met. =IF(OR(B1>0,B2>0),"animal lover","lonely person") =IF(AND(B1>1,B2>1),"animal lover","lonely person") =IF(AND(B1>0,B2>0),"animal lover","lonely person") =AND(IF(B1>0,"animal lover","lonely