Wall Street Prep: Excel Exam Questions with Correct Answers 2023

Add/delete sheets Correct Answer alt-i-w OR alt h-i-s Moving around task ribbon Correct Answer Tab and shift (to select) Auto fit cell Correct Answer alt-h-o-i Custom fit columns Correct Answer alt h-o-w Custom fit rows Correct Answer alt h-o-h Select entire column/row Correct Answer ctrl shift-arrow key Format cells Correct Answer ctrl 1 Paste special Correct Answer alt e-s Freeze panes Correct Answer alt w-f-f Split panes Correct Answer alt w-s Move between panes Correct Answer F6 Get in cell AND navigate to others while inside Correct Answer F2 Edit a cell from the outside Correct Answer alt h-e Add comments Correct Answer Shift F2 Right (and down) fill Correct Answer Ctrl (d) r Insert/delete row Correct Answer alt i-r/h-d-r Insert/delete column Correct Answer alt i-c/h-d-c Date formatting Correct