Excel Crash Course Exam from Wall Street Prep - Wall Street Prep Questions And Answers Updated 2023 Add/delete worksheets - Correct Answer alt i w Move back and forth to different worksheets - Correct Answer ctrl page up and down Open a new file - Correct Answer alt f n, ctrl n open a file - Correct Answer alt f o, ctrl o save a file - Correct Answer alt f s, ctrl s, alt f a(save as) print a file - Correct Answer alt f p, ctrl p Navigating to the toolbars without the mouse - Correct Answer Hit alt and the corresponding letter and then use tab and shift-tab to navigate Access Excel options - Correct Answer alt f t, alt t o Bold - Correct Answer Ctrl B Highlight Column - Correct Answer ctrl spacebar Auto fit column width - Correct Answer alt h o i, alt o c a Enter column width - Correct Answer alt h o w, alt o c w Highlight Row - Correct Answer Shift Spacebar 1 / 2
auto fit row height - Correct Answer alt h o a, alt o r a Enter row height - Correct Answer alt h o h, alt o r e Format cells menu - Correct Answer ctrl 1. has six tabs that include number, alignment, font, border, fill, protection. you can navigate around the tabs with ctrl-tab. each category within a tab can be accessed by pressing Alt and the appropriate underlined letter, or by hitting tab.Paste Special - Correct Answer alt h v s , alt e s Move to different sheet - Correct Answer ctrl tab move the location of sheets - Correct Answer alt h o m change zoom - Correct Answer alt w q, alt v z Freeze Panes - Correct Answer Click the cell below the desired row and to the right of the desired column where you want to freeze panes and hit alt w f f. To unfreeze panes, press alt w f f again.Splitting Panes - Correct Answer Click the cell below the desired row and to the right of the desired column where you want to split panes and hit alt w s. To un-split panes, click alt w s again. Press F6 to move from pane to pane in a clockwise direction; press Shift F6 to move from pane to pane in a counter- clockwise direction.undo/redo - Correct Answer ctrl z/ctrl y highlight characters one at a time in a cell - Correct Answer Shift arrow-keys highlight a continuous range in a cell - Correct Answer Shift Ctrl arrow-keys Clears a cell - Correct Answer alt h e (a=all,f=format,c=content,m=comments)
- / 2