Wall Street Prep: Excel Crash Course/45 Questions And Answers

Sorting Data {Ans: Highlight an entire table or have the cursor in one of the cells in the table Hit Alt+D+S (Data Tab > Sort) to bring up the 'Sort' meenu You can choose to sort various columns by value, cell color, or font color, and in ascending or descending order Note: You can sort multiple levels, so if you wanted to sort by industry first and then by revenue within each industry, you just need to click 'add level'}Conditional Formatting {Ans: Allows you to create your own conditional formats or use a preset from Excel Alt+O+D or Home > Conditional Formatting > New Rule / Alt+H+L > New Rule for customs Alt+H+L or Home > Conditional Formatting > Highlight Cells Rules for presets}Booleans in Excel {Ans: When Excel spits out a TRUE or FALSE (see picture), you can convert them respectively into 1 or 0 by applying any operator on them Interestingly, multiplying a TRUE (or FALSE) by another TRUE (or FALSE) also has the effect of converting it into a 1 or 0, respectively}LEN {Ans: Identifies the length of the string of text or numbers =LEN(text)}CHOOSE {Ans: =CHOOSE(Index Number, Value 1, Value 2,