WALL STREET PREP:EXCEL CRASH COURSE /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE.

WALL STREE T PREP:EXCEL CRASH COURS /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE . Excel Formulas - ANSWER -Start with the = sign The = sign tells Excel that the info that will follow the = sign should be treated as a formula and not as plain text Once you type in the = sign, use the arrow keys to navigate around the Excel workbook to find the cells you need for your formula Operations in Excel - ANSWER - Copying Across Formulas - ANSWER -Ctrl + C to copy, Ctrl + V to paste Open Format Cells Dialog - ANSWER -Ctrl+1 (Cmnd+1) Navigating Format Cells Dialog - ANSWER -Using the Arrow keys to get around the tab To get in a tab, either use Tab key or use Alt and the relevant letter Use Space to toggle check boxes Highlight a Contiguous Range - ANSWER -Ctrl + Shift + Arrows (Cmnd + Shift + Arrows) Combining Data in Two Sheets into Another Sheet - ANSWER -(1) Copy and paste the relevant headers into the third sheet (2) Type "=" in the relevant column in the third sheet and then use Ctrl PageUp/Down (Option Right/LeftArrow) to get to the first sheet and find the right data (3) Press "+" and then find the relevant data in the second sheet and press "Enter" (4) Ctrl+C to copy that formula and then apply it to the rest of the table (5) Delete and retype any important formulas (ex. Net Profit) (6) Add in formatting by Ctrl+C the table in sheet 1 or 2, moving to the upper corner of the table in sheet 3 and using Paste Special and then format: Alt+E+S+T or Ctrl+Alt+V+T (Ctrl+Cmnd+V+T) Paste Special - ANSWER -Alt+E+S (Ctrl+Cmnd+V+T) Let's the user dictate the specific attributes of a cell or highlighted region that should be pasted Open a New Workbook - ANSWER -Ctrl+N Toggle Between Workbooks - ANSWER -Ctrl+Tab (Cmnd ~) Referencing Cells from Other Workbooks - ANSWER -(1) Hit "=" (2) Hit Ctrl+Tab (Cmnd ~) to go to the other workbook (3) Find the relevant data and hit Enter How to Autofit a Range of Columns - ANSWER -(1) Select the columns by hitting Ctrl+SpaceBar (2) Hold down the shift key and use left and right arrow keys to highlight the range of columns (3) Hit Alt+H+O+I to autofit the columns Moving Around the Format Cells Dialog - ANSWER -Move across tabs with Ctrl+Tab Move counterclockwise across form elements with Shift+Tab Select a checkbox with Spacebar Freezing and Splitting Panes - ANSWER -Excel worksheets often become too large to allow users to view all of their contents on one screen 'Freezing Panes' and 'Splitting Panes' options provide users with the flexibility to select specific rows and columns that always remain visible when scrolling in the worksheet Panes - ANSWER -Portions of the worksheet that are bounded and separated by vertical and/or horizontal bars To Freeze Panes - ANSWER -Click the cell below the desired row and to the right of the desired column where you want to freeze panes Hit Alt+W+F+F to freeze To unfreeze, hit Alt+W+F+F again (View>Freeze Panes and then View>Unfreeze Panes) *Note: To create a horizontal freeze, go to the leftmost column! Splitting Panes - ANSWER -Allows users to scroll in both areas of the worksheet, while rows and columns in the non -scrolled area remain visible Directions: (1) Click the cell below the desired row and to the right of the desired column where you want to split panes and hit Alt+W+S (2) To un -split, click Alt+W+S again (3) Press F6 to move from pane to pane in a clockwise direction; press Shift+F6 to move from pane to pane in a counter -clockwise direction (View>Split) *Note: To create a horizontal split, go to the leftmost column! Redo - ANSWER -Ctrl+Y Entering an Active Cell - ANSWER -F2 (Fn+F2) Go to the Beginning of an Active Cell Formula - ANSWER -Ctrl+Home