1|Page
2025/2026 EXCEL CRASH COURSE EXAM FROM
WALL STREET PREP CURRENTLY TESTING
QUESTIONS AND DETAILED CORRECT ANSWERS
(VERIFED) GUARANTEED PASS ALREADY TOP-
RATED A+.
EXCEL
Ace the Wall Street Prep Excel Crash Course Exam with this targeted
guide, designed to master essential financial functions, modeling
techniques, and data analysis shortcuts. This resource delivers practical
exercises and simplified explanations for complex tasks like valuation,
scenario analysis, and advanced formatting. Validate your spreadsheet
proficiency and confidently apply in-demand Excel skills to real-world
finance roles.
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: ......
ANSWER ....... Alt h i w
What is a keyboard shortcut to open a file? ...... ANSWER
....... Ctrl o
What is the recommended workbook calculation setting for
Excel? ...... ANSWER ....... Automatic except for Data
Tables
, 2|Page
To add a cell reference from a different worksheet into an
existing formula with your keyboard, you should follow the
following steps: ...... 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 ...... ANSWER ....... exact column width
Alt h o w ...... ANSWER ....... identical column widths
Alt h o h ...... ANSWER ....... identical column height
Control + Space ...... ANSWER ....... highlight column
Shift + Space ...... ANSWER ....... highlight row
Command + B ...... ANSWER ....... bold
2025/2026 EXCEL CRASH COURSE EXAM FROM
WALL STREET PREP CURRENTLY TESTING
QUESTIONS AND DETAILED CORRECT ANSWERS
(VERIFED) GUARANTEED PASS ALREADY TOP-
RATED A+.
EXCEL
Ace the Wall Street Prep Excel Crash Course Exam with this targeted
guide, designed to master essential financial functions, modeling
techniques, and data analysis shortcuts. This resource delivers practical
exercises and simplified explanations for complex tasks like valuation,
scenario analysis, and advanced formatting. Validate your spreadsheet
proficiency and confidently apply in-demand Excel skills to real-world
finance roles.
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: ......
ANSWER ....... Alt h i w
What is a keyboard shortcut to open a file? ...... ANSWER
....... Ctrl o
What is the recommended workbook calculation setting for
Excel? ...... ANSWER ....... Automatic except for Data
Tables
, 2|Page
To add a cell reference from a different worksheet into an
existing formula with your keyboard, you should follow the
following steps: ...... 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 ...... ANSWER ....... exact column width
Alt h o w ...... ANSWER ....... identical column widths
Alt h o h ...... ANSWER ....... identical column height
Control + Space ...... ANSWER ....... highlight column
Shift + Space ...... ANSWER ....... highlight row
Command + B ...... ANSWER ....... bold
