Wall Street Prep Excel Q & A 2023 with complete solution

1. Add/delete worksheets: alt i w 2. Move back and forth to different worksheets: ctrl page up and down 3. Open a new file: alt f n, ctrl n 4. open a file: alt f o, ctrl o 5. save a file: alt f s, ctrl s, alt f a(save as) 6. print a file: alt f p, ctrl p 7. Navigating to the toolbars without the mouse: Hit alt and the corresponding letter and then use tab and shift-tab to navigate 8. Access Excel options: alt f t, alt t o 9. Bold: Ctrl B 10. Highlight Column: ctrl spacebar 11. Auto fit column width: alt h o i, alt o c a 12. Enter column width: alt h o w, alt o c w 13. Highlight Row: Shift Spacebar 14. auto fit row height: alt h o a, alt o r a 15. Enter row height: alt h o h, alt o r e 16. Format cells menu: ctrl 1. has six tabs that include number, alignment, font, border, fill, protection. you can navigate around the tabs with ctrl-tab. each category within a tab can be accessed by pressing Alt and the appropriate underlined letter, or by hitting tab. 17. Paste Special: alt h v s , alt e s 18. Move to different sheet: ctrl tab 19. move the location of sheets: alt h o m 20. change zoom: alt w q, alt v z 21. Freeze Panes: 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. 22. Splitting 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 un-split 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. 23. undo/redo: ctrl z/ctrl y