Excel Crash Course Exam from Wall
Street Prep-wall Street Prep Complete
Test , Practice Questions, Verified Answer
Key, and Study Guide for (Latest 2026
Edition)
All-of-the-following-are-keyboard-shortcut-that-allow-the-user-input-to-add-more-sheets-to-a-workbook-
EXCEPT:---correct-answer-Alt-h-i-w
What-is-a-keyboard-shortcut-to-open-a-file?---correct-answer-Ctrl-o
What-is-the-recommended-workbook-calculation-setting-for-Excel?---correct-answer-Automatic-except-
for-Data-Tables
To-add-a-cell-reference-from-a-different-worksheet-into-an-existing-formula-with-your-keyboard,-you-
should-follow-the-following-steps:---correct-answer-1.-Hit-F2-to-get-into-the-existing-formula;-delete-any-
incorrect-formulas-or-operators-2.-Hit-F2-again-to-enable-"Enter"-mode-on-the-bottom-left-corner-of-the-
Excel-sheet-3.-Holding-down-Ctrl,-use-PageUp-or-PageDown-to-find-the-desired-worksheet-4.-Let-go-of-
the-Ctrl-and-PageUp/Down-keys-5.-Use-the-arrow-keys-to-locate-the-desired-cell-reference-6.-Hit-Enter
Alt-h-o-i---correct-answer-exact-column-width
, Alt-h-o-w---correct-answer-identical-column-widths
Alt-h-o-h---correct-answer-identical-column-height
Control-+-Space---correct-answer-highlight-column
Shift-+-Space---correct-answer-highlight-row
Command-+-B---correct-answer-bold
Command-+-I---correct-answer-italicize
Alt-e-s-/-control-command-v---correct-answer-paste-special
What-is-the-keyboard-shortcut-to-move-sheets-within-a-workbook?---correct-answer-Alt-H-O-M
What-is-the-keyboard-shortcut-to-open-the-formatting-cells-dialog-box?---correct-answer-Ctrl-1
What-are-the-keyboard-shortcuts-for-auto-fitting-a-range-of-columns?---correct-answer-1)-Select-the-
columns-by-hitting-Ctrl-Spacebar.-2)-Hold-down-the-shift-key-and-use-left-and-right-arrow-keys-to-
highlight-the-range-of-columns.-3)-Hit-Alt-H-O-I-to-auto-fit-the-columns.
When-you-are-in-the-Format-Cells-dialog-(Ctrl-1):
What-is-the-keyboard-shortcut-for-moving-across-tabs-(Number,-Alignment,-Font-Border,-Fill,-
Protection)?
How-do-you-move-counter-clockwise-across-form-elements?
How-do-you-select-a-checkbox-(put-a-checkbox-next-to-it)---correct-answer-1)-Ctrl-Tab-
2)-Shift-Tab-
3)-Spacebar
Street Prep-wall Street Prep Complete
Test , Practice Questions, Verified Answer
Key, and Study Guide for (Latest 2026
Edition)
All-of-the-following-are-keyboard-shortcut-that-allow-the-user-input-to-add-more-sheets-to-a-workbook-
EXCEPT:---correct-answer-Alt-h-i-w
What-is-a-keyboard-shortcut-to-open-a-file?---correct-answer-Ctrl-o
What-is-the-recommended-workbook-calculation-setting-for-Excel?---correct-answer-Automatic-except-
for-Data-Tables
To-add-a-cell-reference-from-a-different-worksheet-into-an-existing-formula-with-your-keyboard,-you-
should-follow-the-following-steps:---correct-answer-1.-Hit-F2-to-get-into-the-existing-formula;-delete-any-
incorrect-formulas-or-operators-2.-Hit-F2-again-to-enable-"Enter"-mode-on-the-bottom-left-corner-of-the-
Excel-sheet-3.-Holding-down-Ctrl,-use-PageUp-or-PageDown-to-find-the-desired-worksheet-4.-Let-go-of-
the-Ctrl-and-PageUp/Down-keys-5.-Use-the-arrow-keys-to-locate-the-desired-cell-reference-6.-Hit-Enter
Alt-h-o-i---correct-answer-exact-column-width
, Alt-h-o-w---correct-answer-identical-column-widths
Alt-h-o-h---correct-answer-identical-column-height
Control-+-Space---correct-answer-highlight-column
Shift-+-Space---correct-answer-highlight-row
Command-+-B---correct-answer-bold
Command-+-I---correct-answer-italicize
Alt-e-s-/-control-command-v---correct-answer-paste-special
What-is-the-keyboard-shortcut-to-move-sheets-within-a-workbook?---correct-answer-Alt-H-O-M
What-is-the-keyboard-shortcut-to-open-the-formatting-cells-dialog-box?---correct-answer-Ctrl-1
What-are-the-keyboard-shortcuts-for-auto-fitting-a-range-of-columns?---correct-answer-1)-Select-the-
columns-by-hitting-Ctrl-Spacebar.-2)-Hold-down-the-shift-key-and-use-left-and-right-arrow-keys-to-
highlight-the-range-of-columns.-3)-Hit-Alt-H-O-I-to-auto-fit-the-columns.
When-you-are-in-the-Format-Cells-dialog-(Ctrl-1):
What-is-the-keyboard-shortcut-for-moving-across-tabs-(Number,-Alignment,-Font-Border,-Fill,-
Protection)?
How-do-you-move-counter-clockwise-across-form-elements?
How-do-you-select-a-checkbox-(put-a-checkbox-next-to-it)---correct-answer-1)-Ctrl-Tab-
2)-Shift-Tab-
3)-Spacebar
