Wall Street Prep: Excel Crash Course Study Guide Questions And Correct Answers

And Functions {Ans: =and([first statement],[second statement)}Remove Duplicates {Ans: Data > Remove Duplicates Highlight the relevant data range and then click remove duplicates Select all columns to ensure true duplicates}Using Wildcards {Ans: When doing a COUNTIF function, you can use asterisks to find a word within a cell or array of cells Ex. To find cells with the word united somewhere in them, you can do: =COUNTIF(array,"*united*") For cells that start with the letter A, you only need one asterisk: =COUNTIF(array,"A*"}Open a New Workout {Ans: Ctrl N Cmnd N}Add a Cell Reference From a Different Worksheet into an Existing Formula {Ans: Hit F2 to get into the existing formula; delete any incorrect formulas or operators Hit F2 again to enable "Enter" mode on the bottom-left corner of the Excel sheet Holding down Ctrl, use PageUp or PageDown to find the desired worksheet Let go of the Ctrl and PageUp/Down keys Use the arrow keys to located the desired cell reference Hit Enter}LAMBDA for SHEETNAME {Ans: For Sheet Name: Grabs the name of the current worksheet LAMBDA for SHEETNAME: =LAMBDA(reference,RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))))(reference) New Function named TSM: =LAMBDA(reference,RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))) =SHEETNAME(reference) reference = any cell reference on the corresponding worksheet}