Study Set Exam for Excel Crash Course Latest Updates

Study Set Exam for Excel Crash Course Latest Updates move back and forth between the worksheets in a workbook - CORRECT ANSWER- *Ctrl PageUp* or *Ctrl PageDown* open a file - CORRECT ANSWER-*alt f o* *ctrl o* save a file - CORRECT ANSWER-*alt f s* *ctrl s* print a file - CORRECT ANSWER-*alt f p* *ctrl p* navigating to the toolbars without the mouse - CORRECT ANSWER-hit *Alt and the appropriate letter* (or use the right/left arrow keys) to get to the desired tab once there, use the Tab and Shift Tab keys to navigate around accessing settings - CORRECT ANSWER-File Options (*Alt f t*) *Alt t o* Disabling the Start Screen and adding more worksheets on startup - CORRECT ANSWER-click on 'Blank worksheet' Hit *Alt f t* go go to Excel options (you can also get there by clicking the file tab) Under 'General' unselect "Show the Start screen when this application starts" password protecting files - CORRECT ANSWER-File Info password protect files: "Encrypt with Password" password protect individual worksheet (so that people can't see or edit formulas): "Protect Current Sheet" highlighting columns and rows - CORRECT ANSWER-columns: *Ctrl Spacebar* rows: *Shift Spacebar* widening columns and rows - CORRECT ANSWER-highlight column by pressing *Ctrl Spacebar* *Alt h o i* to auto-fit the column width -if you want a column to have a certain width, press *Alt h o w* and enter the desired width highlight row by pressing Shift Spacebar *Alt h o a* to auto-fit the row height -if you want a row to have a certain height, press *Alt h o h* and enter the desired height format cells - CORRECT ANSWER-*Ctrl 1* pulls up the 'Format Cells' menu navigating the 'Format Cells' menu - CORRECT ANSWER-after hitting Ctrl 1 to pull up the 'Format Cells' menu, you can navigate around tabs by hitting *Ctrl tab* each category within a tab can be accessed by pressing *Alt* and the appropriate underlined letter, or by hitting *tab* to move clockwise and *shift tab* to move counter clockwise when on the desired tab, horizontal alignment can be accessed through *Alt h* and vertical alignment through *Alt v* paste special - CORRECT ANSWER-*Alt v s t* or *Alt e s t* changing zoom size - CORRECT ANSWER-*Alt w q* or *Alt v z* Move/copy a tab - CORRECT ANSWER-*Alt h o m* freezing panes - CORRECT ANSWER-click the cell BELOW the desired row and to the RIGHT of the desired column where you want to freeze panes and hit *Alt w f f* to unfreeze panes: press *Alt w f f* again splitting panes - CORRECT ANSWER-splitting panes allows users to scroll in both areas of the worksheet, while rows and columns in the non-scrolled area remain visible to split panes: -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* -to unspilt panes, click *Alt w s* again -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 manipula