Wall Street Prep: Excel Exam 2023 with complete solution Graded A

Add/delete sheets - CORRECT ANS alt-i-w OR alt h-i-s Moving around task ribbon - CORRECT ANS Tab and shift (to select) Auto fit cell - CORRECT ANS alt-h-o-i Custom fit columns - CORRECT ANS alt h-o-w Custom fit rows - CORRECT ANS alt h-o-h Select entire column/row - CORRECT ANS ctrl shift-arrow key Format cells - CORRECT ANS ctrl 1 Paste special - CORRECT ANS alt e-s Freeze panes - CORRECT ANS alt w-f-f Split panes - CORRECT ANS alt w-s Move between panes - CORRECT ANS F6 Get in cell AND navigate to others while inside - CORRECT ANS F2 Edit a cell from the outside - CORRECT ANS alt h-e Add comments - CORRECT ANS Shift F2 Right (and down) fill - CORRECT ANS Ctrl (d) r Insert/delete row - CORRECT ANS alt i-r/h-d-r Insert/delete column - CORRECT ANS alt i-c/h-d-c Date formatting - CORRECT ANS Ctrl shift # Currency formatting - CORRECT ANS Ctrl shift $ Percentage formatting - CORRECT ANS Ctrl shift % Number formatting - CORRECT ANS Ctrl shift ! Anchoring a cell - CORRECT ANS F4 Group columns - CORRECT ANS Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - CORRECT ANS Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - CORRECT ANS 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 - CORRECT ANS Better than merge; effectively does same thing Go to special - CORRECT ANS F5 alt s