1 / 8
Excel Basics - Wall Street Prep
1. Create new sheet Correct Answer(s) ctrl i w
2. switch between sheets Correct Answer(s) ctrl page up / ctrl page down
3. access anything on the ribbon Correct Answer(s) atl
4. toggle between excel books Correct Answer(s) ctrl tab
5. open new file Correct Answer(s) ctrl o
6. bold Correct Answer(s) ctrl b
7. options Correct Answer(s) alt f t
8. auto size cell Correct Answer(s) alt h o i
9. designate width of box Correct Answer(s) alt h o w
10. highlight column Correct Answer(s) ctrl space
11. highlight row Correct Answer(s) shift space
12. undo Correct Answer(s) ctrl z
13. redo Correct Answer(s) ctrl y
14. formatting Correct Answer(s) ctrl 1
15. highlight all columns next Correct Answer(s) ctrl shift > / <
16. paste special Correct Answer(s) alt e s
17. zoom in / out Correct Answer(s) alt v z
18. freeze pane Correct Answer(s) alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the
rest of the worksheet scrolls.
19. split pane Correct Answer(s) alt w s
20. hop between panes Correct Answer(s) F6
21. go inside cell to see functions Correct Answer(s) F2
