Wall Street Prep Excel Exam Questions with 100% Correct Answers (Latest 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 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