Wall Street Prep: Excel Study Guide
Add/delete sheets - Answer✔✔-alt-i-w OR alt h-i-s
Moving around task ribbon - Answer✔✔-Tab and shift (to select)
Auto fit cell - Answer✔✔-alt-h-o-i
Custom fit columns - Answer✔✔-alt h-o-w
Custom fit rows - Answer✔✔-alt h-o-h
Select entire column/row - Answer✔✔-ctrl shift-arrow key
Format cells - Answer✔✔-ctrl 1
Paste special - Answer✔✔-alt e-s
Freeze panes - Answer✔✔-alt w-f-f
Split panes - Answer✔✔-alt w-s
Move between panes - Answer✔✔-F6
Get in cell AND navigate to others while inside - Answer✔✔-F2
Edit a cell from the outside - Answer✔✔-alt h-e
Add comments - Answer✔✔-Shift F2
Page 1/4