Excel Basics - Wall Street Prep
Study online at https://quizlet.com/_bkxy58
1. Create new sheet ctrl i w
2. switch between sheets ctrl page up / ctrl page down
3. access anything on the rib- atl
bon
4. toggle between excel books ctrl tab
5. open new file ctrl o
6. bold ctrl b
7. options alt f t
8. auto size cell alt h o i
9. designate width of box alt h o w
10. highlight column ctrl space
11. highlight row shift space
12. undo ctrl z
13. redo ctrl y
14. formatting ctrl 1
15. highlight all columns next ctrl shift > / <
16. paste special alt e s
17. zoom in / out alt v z
18. freeze pane
1/7
, Excel Basics - Wall Street Prep
Study online at https://quizlet.com/_bkxy58
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 alt w s
20. hop between panes F6
21. go inside cell to see functions F2
22. go inside cell to clear specific ALT h e
info
23. input comment Shift F2
24. Fill Highlighted Area Right / ctrl r / ctrl d
Down
25. Input New Row ALT i r
26. input new column alt i c
27. deleting columns / rows ALT H D R / ALT H D C
28. Paste Special Formatting ALT E S T
29. Trace Precedents ATL M P / (delete it ALT M A A) allows you to see which cells are
referenced in a particular formula or function
30. Trace Dependents ALT M D
31. find and replace ctrl h
32. IF criteria, output if true, output if false
33. IF(AND( IF(AND(first test, 2nd test), output is true, output if false)
2/7
Study online at https://quizlet.com/_bkxy58
1. Create new sheet ctrl i w
2. switch between sheets ctrl page up / ctrl page down
3. access anything on the rib- atl
bon
4. toggle between excel books ctrl tab
5. open new file ctrl o
6. bold ctrl b
7. options alt f t
8. auto size cell alt h o i
9. designate width of box alt h o w
10. highlight column ctrl space
11. highlight row shift space
12. undo ctrl z
13. redo ctrl y
14. formatting ctrl 1
15. highlight all columns next ctrl shift > / <
16. paste special alt e s
17. zoom in / out alt v z
18. freeze pane
1/7
, Excel Basics - Wall Street Prep
Study online at https://quizlet.com/_bkxy58
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 alt w s
20. hop between panes F6
21. go inside cell to see functions F2
22. go inside cell to clear specific ALT h e
info
23. input comment Shift F2
24. Fill Highlighted Area Right / ctrl r / ctrl d
Down
25. Input New Row ALT i r
26. input new column alt i c
27. deleting columns / rows ALT H D R / ALT H D C
28. Paste Special Formatting ALT E S T
29. Trace Precedents ATL M P / (delete it ALT M A A) allows you to see which cells are
referenced in a particular formula or function
30. Trace Dependents ALT M D
31. find and replace ctrl h
32. IF criteria, output if true, output if false
33. IF(AND( IF(AND(first test, 2nd test), output is true, output if false)
2/7