EXCEL CRASH COURSE EXAM FROM
WALL STREET PREP EXAM QUESTIONS
AND ANSWERS GRADED A+ 2025/2026
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - ANS Alt h i w
What is a keyboard shortcut to open a file?` - ANS Ctrl o
What is the recommended workbook calculation setting for Excel? - ANS 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: - ANS 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
What is the keyboard shortcut to move sheets within a workbook? - ANS Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - ANS Ctrl 1
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
WALL STREET PREP EXAM QUESTIONS
AND ANSWERS GRADED A+ 2025/2026
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - ANS Alt h i w
What is a keyboard shortcut to open a file?` - ANS Ctrl o
What is the recommended workbook calculation setting for Excel? - ANS 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: - ANS 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
What is the keyboard shortcut to move sheets within a workbook? - ANS Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - ANS Ctrl 1
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.