Wall Street Prep: Excel Crash Course Study Guide Rated A+

Deleting Rows and Columns {Ans: Row: Alt+H+D+R Column: Alt+H+D+C OR Highlight the row/column and press Ctrl -}The Insert Tab {Ans: Important Features: Pivot Table, Charts, Header & Footer}Round Functions {Ans: =ROUND(number,number of digits) rounds the number to the specified number of decimal places =ROUNDUP rounds up =ROUNDDOWN rounds down}SUBSTITUTE {Ans: =SUBSTITUTE(text, old text, new text, [instance number]) replaces old text within a string of text ("text") with new text If there are several instances of the old text, you can identify which instance with instance number}Assign Row Height Command {Ans: Alt H O H (Home > Format > Row Height)}XNPV Function {Ans: An improvement on NPV for when the timing of cash flows is uneven =XNPV(rate, values, dates) returns the net present value for a set of cash flows that do not necessarily occur at equal time intervals Unlike NPV, the first cash flow is not discounted, while dates of subsequent cash flows can be included in the formula in any order}