Wall Street Prep Excel Exam Test Bank Questions
And Correct Answers 2024 Update
Add/delete worksheets - answer alt i w
Move back and forth to different worksheets - answer ctrl page up and
down
Open a new file - answer alt f n, ctrl n
open a file - answer alt f o, ctrl o
save a file - answer alt f s, ctrl s, alt f a(save as)
print a file - answer alt f p, ctrl p
Navigating to the toolbars without the mouse - answer Hit alt and the
corresponding letter and then use tab and shift-tab to navigate
Access Excel options - answer alt f t, alt t o
Bold - answer Ctrl B
, Highlight Column - answer ctrl spacebar
Auto fit column width - answer alt h o i, alt o c a
Enter column width - answer alt h o w, alt o c w
Highlight Row - answer Shift Spacebar
auto fit row height - answer alt h o a, alt o r a
Enter row height - answer alt h o h, alt o r e
Format cells menu - 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 - answer alt h v s , alt e s
Move to different sheet - answer ctrl tab
And Correct Answers 2024 Update
Add/delete worksheets - answer alt i w
Move back and forth to different worksheets - answer ctrl page up and
down
Open a new file - answer alt f n, ctrl n
open a file - answer alt f o, ctrl o
save a file - answer alt f s, ctrl s, alt f a(save as)
print a file - answer alt f p, ctrl p
Navigating to the toolbars without the mouse - answer Hit alt and the
corresponding letter and then use tab and shift-tab to navigate
Access Excel options - answer alt f t, alt t o
Bold - answer Ctrl B
, Highlight Column - answer ctrl spacebar
Auto fit column width - answer alt h o i, alt o c a
Enter column width - answer alt h o w, alt o c w
Highlight Row - answer Shift Spacebar
auto fit row height - answer alt h o a, alt o r a
Enter row height - answer alt h o h, alt o r e
Format cells menu - 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 - answer alt h v s , alt e s
Move to different sheet - answer ctrl tab
