Wall Street Prep: Excel Crash Course 246 Correctly Answered Questions Latest Update

Dates in Excel as Serial Numbers {Ans: When using dates in general in Excel, understand that Excel stores dates as serial numbers - they must be formatted as dates (use Ctrl+1) in. order to look like recognizable dates to the user}MIN Function {Ans: =MIN(number 1, number 2, ...) returns the smallest number in a specified set of values}Text Functions {Ans: For professionals that have to work extracting data from large inconsistent and poorly formatted data sets, text functions can be absolutely critical We will cover:}Get Rid of Borders {Ans: Ctrl+Shift+-}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*"}Jumping from One Formula Element to the Next {Ans: Ctrl+Arrows (Cmnd+Arrows)}Shortcuts to Allow the User Input to Add More Sheets to a Workbook {Ans: Alt i w Alt h i s Shift F11 Alt Shift F1}MAX Function {Ans: =MAX(number 1, number 2, ...) returns the largest number in a specified set of