Wall Street Prep Excel Exam Questions with Latest Update

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 Right (and down) fill - Answer-Ctrl (d) r Insert/delete row - Answer-alt i-r/h-d-r Insert/delete column - Answer-alt i-c/h-d-c Date formatting - Answer-Ctrl shift # Currency formatting - Answer-Ctrl shift $ Percentage formatting - Answer-Ctrl shift % Number formatting - Answer-Ctrl shift !