Wall Street Prep: Excel Test Questions with Correct Solutions| Rated A+

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e Add comments - Shift F2 Right (and down) fill - Ctrl (d) r Insert/delete row - alt i-r/h-d-r Insert/delete column - alt i-c/h-d-c Date formatting - Ctrl shift # Currency formatting - Ctrl shift $ Percentage formatting - Ctrl shift % Number formatting - Ctrl shift ! Anchoring a cell - F4 Group columns - Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - Ctrl [ = highlights precedent cell Ctrl ] highlights dependent cell alt m-p highlights precedent cell alt m-d highlights dependent cell alt m-a-a erases arrows Center across selection - Better than merge; effectively does same thing Go to special - F5 alt s Conditional Formatting - Custom: alt o-d Native: alt h-l Page breaks - alt enter