Excel Crash Course Exam Questions And Answers. Verified And Updated

EXAM STUDY MATERIALS July 24, 2024 1:33:58 PM Excel Crash Course Exam Questions And Answers. Verified and Updated. Move back and forth between the worksheets in a workbook - answer✔✔*Ctrl PageUp* or *Ctrl PageDown* open a file - answe r✔✔*alt f o* *ctrl o* save a file - answer✔✔*alt f s* *ctrl s* print a file - answer✔✔*alt f p* *ctrl p* navigating to the toolbars without the mouse - answer✔✔hit *Alt and the appropriate letter* (or use the right/left arrow keys) to get to the desire d tab once there, use the Tab and Shift Tab keys to navigate around accessing settings - answer✔✔File > Options (*Alt f t*) *Alt t o* Disabling the Start Screen and adding more worksheets on startup - answer✔✔click on 'Blank worksheet' Hit *Alt f t* go go to Excel options (you can also get there by clicking the file tab) EXAM STUDY MATERIALS July 24, 2024 1:33:58 PM Under 'General' unselect "Show the Start screen when this application starts" password protecting files - answer✔✔File Info password protect files: "Encrypt with Passw ord" password protect individual worksheet (so that people can't see or edit formulas): "Protect Current Sheet" highlighting columns and rows - answer✔✔columns: *Ctrl Spacebar* rows: *Shift Spacebar* widening columns and rows - 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 - answer✔✔*Ctrl 1* pulls up the 'Format Cells' menu navigating the 'Format Cells' menu - answer✔✔after hitting Ctrl 1 to pull up the 'Format Cells' menu, you can nav igate 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, horizonta l alignment can be accessed through *Alt h* and vertical alignment through *Alt v* paste special - answer✔✔*Alt v s t* or *Alt e s t* changing zoom size - answer✔✔*Alt w q* or *Alt v z* EXAM STUDY MATERIALS July 24, 2024 1:33:58 PM Move/copy a tab - answer✔✔*Alt h o m* freezing panes - 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 - answer✔✔splitting panes allows users to sc roll 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 pa nes, 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 manipulating data inside a cell - answer✔✔*F2* is the command that puts you inside a cell : -pressing the F2 key once shows you the components of the formula you created earlier, puts you inside a cell and enables you to navigate through it to edit the existing cell data -pressing the F2 key twice activates the cursor and enables you to move to different cells, worksheets, and even other open Excel files *Shift arrow key* will highlight characters one at a time *Shift Ctrl arrow key* will highlight contiguous ranges of characters deleting and clearing cell data - answer✔✔hitting *Delete* does NOT delete the formatting in the cell to truly delete a cell: -*Alt h e* (Home tab > Clear) -from the drop -down, chose the appropriate actions *(Alt h e) a*: clears ALL contents of the cell