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

Get Rid of Borders {Ans: Ctrl+Shift+-}Add Comment {Ans: Shift+F2 (Shift+Fn+F2) Esc twice to exit}Distinct Count {Ans: Prior to 2010, a challenge was capturing distinct counts of duplicate items presented in large data sets In Excel 2013, Distinct Count has been added under Value Field Settings in a Pivot Table}Functions {Ans: Pre-built combinations of operations in Excel that facilitate spreadsheet analysis}Grouping Worksheets {Ans: Helpful if you would like to format data in the same manner or enter the same data across multiple sheets By grouping multiple worksheets, any data and formatting that you would perform in one of the grouped worksheets would automatically be reflected in all of them Hold down Ctrl+Shift and press Page+Up/Down to reach the worksheets you would like to group (Shift+Click on the desired worksheets) All of the grouped worksheets are highlighted and the file name on top of the Excel screen should show [Group] are it To ungroup, press Ctrl+PageDown}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