Wall Street Prep: Excel Crash Course - Latest Questions & Answers Pdf

Recording Macros {Ans: Excel allows you to record a sequence of instructions, and assign a keyboard shortcut to invoke them as desired These instructions are called macros Go to File > Record Macro}Flash Fill {Ans: Excel 2013 has introduced a real improvement to working with large data sets in the form of Flash Fill Tries to guess at to what kind of data you're trying to get at Shortcut: Ctrl+E or Alt+A+F+F (Data > Flash Fill)}How to Use Lambdas Across Multiple Workbooks {Ans: To use lambdas across multiple workbooks, make a blank worksheet in the workbook with your lambdas Then, copy and paste it into another workbook to add the lambdas over}Command to Change Zoom Size {Ans: Alt+V+Z (Ctrl+MouseScroll)}Page Layout Tab {Ans: Important Features: Print Area, Fonts, Gridlines}COLUMN and ROW Functions {Ans: =COLUMN() gives you the current column and =ROW() gives you the current row =COLUMN(reference) and =ROW(reference) gives you the column and row of a reference point =COLUMNS(array) and =ROWS(array) gives you the number of columns and rows in an array}XNPV Function {Ans: An improvement on NPV for when the timing of cash flows is uneven =XNPV(rate, values, dates) returns the net