Excel Crash Course Exam Prep from Wall Street| A
Review of 210 Questions with Solutions| Updated
2026|2027| Guaranteed Pass
1. Data Tab: ANS Important Features: Filter, Sort, Text to Columns, Flash
Fill, Data Validation, Data Tables (Goal Seek), Group/Ungroup
2. Review Tab: ANS Important Features: New Comment
3. View Tab: ANS Important Features: Zoom, Gridlines
4. Developer Tab: ANS Important Features: Record Macro, Add-Ins
5. Protection: ANS Go to File > Info > Password
Protecting Files (File > Passwords) Alt F T I
You can password protect files "Encrypt with Password"
You can also protect individual worksheets so that people can't see or edit
formulas "Protect Current Sheet"
6. Shortcuts to Allow the User Input to Add More Sheets to a Workbook:
ANS Alt i w Alt h i s
Shift F11 Alt Shift F1
7. Find or Find and Replace Shortcut: ANS Ctrl F (Cmnd F)
8. What is the recommended workbook calculation setting for Excel?:
ANS Automatic Except for Data Tables
9. Add a Cell Reference from a Different Worksheet into an Existing Formula-
: ANS Hit F2 to get into the existing formula; delete any incorrect formulas
or operators Hit F2 again to enable "Enter" mode on the bottom-left corner
, of the Excel sheet Holding down Ctrl, use Page Up or Page Down to find
the desired worksheet
Let go of the Ctrl and Page Up/Down keys
Use the arrow keys to located the desired cell reference Hit Enter
10. Autofit Row Height Command: ANS Alt H O A
11. Autofit Column Height Command: ANS Alt O C A
12. Assign Column Width
Command: ANS Alt H O W
(Home > Format > Column Width)
13. Assign Row Height Command: ANS Alt H O H (Home > Format > Row
Height)
14. Command to Change Zoom Size: ANS Alt+V+Z (Ctrl+Mouse Scroll)
15. Autofit the Column Width Command: ANS Alt H O I (Home > Format >
Autofit Column Width)
16. Save As Shortcut: ANS Alt F A
17. Alt Commands: ANS Most commands involving Alt are
shortcuts to the commands and functions inside the default eight Main
Tabs
18. Select Column & Range of Columns: ANS Ctrl Space Range: Ctrl Space
Shift+ Right Arrow
19. Select Row & Range of Rows: ANS Shift Space Range: Shift Space Shift+
Down Arrow
20. Undo: ANS Ctrl Z
, 21. Copying Across Formulas: ANS Ctrl + C to copy, Ctrl + V to paste
22. Open Format Cells Dialog: ANS Ctrl+1 (Cmnd+1)
23. Navigating Format Cells Dialog: ANS Using the
Arrow keys to get around the tab To get in a tab, either use
Tab key or use Alt and the relevant letter
Use Space to toggle check boxes
24. Combining Data in Two Sheets into Another Sheet: ANS (1)
Copy and paste the relevant headers into the third sheet
(2) Type "=" in the relevant column in the third sheet and then use Ctrl
Page Up/Down (Option Right/Left Arrow) to get to the first sheet and find
the right data
(3) Press "+" and then find the relevant data in the second sheet and press
"Enter"
(4) Ctrl +C to copy that formula and then apply it to the rest of the table
(5) Delete and retype any important formulas (ex. Net Profit)
(6) Add in formatting by Ctrl +C the table in sheet 1 or 2, moving to the
upper corner of the table in sheet 3 and using Paste Special and then format:
Alt+E+S+T or Ctrl+Alt+V+T (Ctrl+Cmnd+V+T)
25. Toggle Between Workbooks: ANS Ctrl+Tab (Cmnd~)
26. Referencing Cells from Other Workbooks: ANS (1) Hit "="
(2) Hit Ctrl+Tab (Cmnd ~) to go to the other workbook
(3) Find the relevant data and hit Enter
27. How to Autofit a Range of Columns: ANS (1) Select the columns by hitting
Ctrl+ Space Bar
(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 autofit the columns
28. Moving Around the Format Cells Dialog: ANS
Move across tabs with Ctrl+Tab Move counterclockwise
across form elements with Shift+Tab
Select a checkbox with Spacebar
29. To Freeze Panes: ANS Click the cell below the desired row and to
the right of the desired column where you want to freeze panes
Hit Alt+W+F+F to freeze
To unfreeze, hit Alt+W+F+F again
(View>Freeze Panes and then View>Unfreeze Panes)
*Note: To create a horizontal freeze, go to the leftmost column!
30. Moving Between Worksheets: ANS Ctrl + Page Down/Page Up (Option +
Right Arrow/Left Arrow)
31. Adding Worksheets: ANS (Fn Shift F11)
32. Open a New Workout: ANS Ctrl N Cmnd N
33. The File Tab: ANS Many Excel features (Open file,
save file, print file, etc.) are located in this tab Excel also has
alternative keyboard shortcuts (using Ctrl) for many of these
features
Open a File: Ctrl O (Cmnd O) Save a File: Ctrl S (Cmnd S) Print a File: Ctrl
P (Cmnd P)
Open a File: Ctrl O Cmnd O
34. The Home Tab: ANS Includes most formatting properties:
Font type, size, and color Background color Text/cell alignment
Changing currency, decimal, percent formats Inserting, deleting, and hiding rows
and columns Adjusting columns and rows width
Inserting, deleting, and renaming worksheets
Review of 210 Questions with Solutions| Updated
2026|2027| Guaranteed Pass
1. Data Tab: ANS Important Features: Filter, Sort, Text to Columns, Flash
Fill, Data Validation, Data Tables (Goal Seek), Group/Ungroup
2. Review Tab: ANS Important Features: New Comment
3. View Tab: ANS Important Features: Zoom, Gridlines
4. Developer Tab: ANS Important Features: Record Macro, Add-Ins
5. Protection: ANS Go to File > Info > Password
Protecting Files (File > Passwords) Alt F T I
You can password protect files "Encrypt with Password"
You can also protect individual worksheets so that people can't see or edit
formulas "Protect Current Sheet"
6. Shortcuts to Allow the User Input to Add More Sheets to a Workbook:
ANS Alt i w Alt h i s
Shift F11 Alt Shift F1
7. Find or Find and Replace Shortcut: ANS Ctrl F (Cmnd F)
8. What is the recommended workbook calculation setting for Excel?:
ANS Automatic Except for Data Tables
9. Add a Cell Reference from a Different Worksheet into an Existing Formula-
: ANS Hit F2 to get into the existing formula; delete any incorrect formulas
or operators Hit F2 again to enable "Enter" mode on the bottom-left corner
, of the Excel sheet Holding down Ctrl, use Page Up or Page Down to find
the desired worksheet
Let go of the Ctrl and Page Up/Down keys
Use the arrow keys to located the desired cell reference Hit Enter
10. Autofit Row Height Command: ANS Alt H O A
11. Autofit Column Height Command: ANS Alt O C A
12. Assign Column Width
Command: ANS Alt H O W
(Home > Format > Column Width)
13. Assign Row Height Command: ANS Alt H O H (Home > Format > Row
Height)
14. Command to Change Zoom Size: ANS Alt+V+Z (Ctrl+Mouse Scroll)
15. Autofit the Column Width Command: ANS Alt H O I (Home > Format >
Autofit Column Width)
16. Save As Shortcut: ANS Alt F A
17. Alt Commands: ANS Most commands involving Alt are
shortcuts to the commands and functions inside the default eight Main
Tabs
18. Select Column & Range of Columns: ANS Ctrl Space Range: Ctrl Space
Shift+ Right Arrow
19. Select Row & Range of Rows: ANS Shift Space Range: Shift Space Shift+
Down Arrow
20. Undo: ANS Ctrl Z
, 21. Copying Across Formulas: ANS Ctrl + C to copy, Ctrl + V to paste
22. Open Format Cells Dialog: ANS Ctrl+1 (Cmnd+1)
23. Navigating Format Cells Dialog: ANS Using the
Arrow keys to get around the tab To get in a tab, either use
Tab key or use Alt and the relevant letter
Use Space to toggle check boxes
24. Combining Data in Two Sheets into Another Sheet: ANS (1)
Copy and paste the relevant headers into the third sheet
(2) Type "=" in the relevant column in the third sheet and then use Ctrl
Page Up/Down (Option Right/Left Arrow) to get to the first sheet and find
the right data
(3) Press "+" and then find the relevant data in the second sheet and press
"Enter"
(4) Ctrl +C to copy that formula and then apply it to the rest of the table
(5) Delete and retype any important formulas (ex. Net Profit)
(6) Add in formatting by Ctrl +C the table in sheet 1 or 2, moving to the
upper corner of the table in sheet 3 and using Paste Special and then format:
Alt+E+S+T or Ctrl+Alt+V+T (Ctrl+Cmnd+V+T)
25. Toggle Between Workbooks: ANS Ctrl+Tab (Cmnd~)
26. Referencing Cells from Other Workbooks: ANS (1) Hit "="
(2) Hit Ctrl+Tab (Cmnd ~) to go to the other workbook
(3) Find the relevant data and hit Enter
27. How to Autofit a Range of Columns: ANS (1) Select the columns by hitting
Ctrl+ Space Bar
(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 autofit the columns
28. Moving Around the Format Cells Dialog: ANS
Move across tabs with Ctrl+Tab Move counterclockwise
across form elements with Shift+Tab
Select a checkbox with Spacebar
29. To Freeze Panes: ANS Click the cell below the desired row and to
the right of the desired column where you want to freeze panes
Hit Alt+W+F+F to freeze
To unfreeze, hit Alt+W+F+F again
(View>Freeze Panes and then View>Unfreeze Panes)
*Note: To create a horizontal freeze, go to the leftmost column!
30. Moving Between Worksheets: ANS Ctrl + Page Down/Page Up (Option +
Right Arrow/Left Arrow)
31. Adding Worksheets: ANS (Fn Shift F11)
32. Open a New Workout: ANS Ctrl N Cmnd N
33. The File Tab: ANS Many Excel features (Open file,
save file, print file, etc.) are located in this tab Excel also has
alternative keyboard shortcuts (using Ctrl) for many of these
features
Open a File: Ctrl O (Cmnd O) Save a File: Ctrl S (Cmnd S) Print a File: Ctrl
P (Cmnd P)
Open a File: Ctrl O Cmnd O
34. The Home Tab: ANS Includes most formatting properties:
Font type, size, and color Background color Text/cell alignment
Changing currency, decimal, percent formats Inserting, deleting, and hiding rows
and columns Adjusting columns and rows width
Inserting, deleting, and renaming worksheets
