Wall Street Prep: Excel Crash Course Exam Study Guide with complete solutions | Latest 2025/2026 Update.

Wall Street Prep: Excel Crash Course
i,- i,- i,- i,- i,- i,-




Exam Study Guide with complete i,- i,- i,- i,- i,-




solutions | Latest 2025/2026 Update. i,- i,- i,- i,-




The Home Tab
i,- i,- i,-i,- i,- Includes most formatting properties:
i,- i,- i,-




Font type, size, and color
i,- i,- i,- i,-




Background color i,-




Text/cell alignment i,-




Changing currency, decimal, percent formats
i,- i,- i,- i,-




Inserting, deleting, and hiding rows and columns
i,- i,- i,- i,- i,- i,-




Adjusting columns and rows width
i,- i,- i,- i,-




Inserting, deleting, and renaming worksheets
i,- i,- i,- i,-




The Insert Tab
i,- i,- i,-i,- i,- Important Features: Pivot Table, Charts, Header
i,- i,- i,- i,- i,- i,-



& Footer
i,-




Page Layout Tab
i,- i,- i,-i,- i,- Important Features: Print Area, Fonts,
i,- i,- i,- i,- i,-



Gridlines

,Formulas Tab Important Features: Insert Function, Function
i,- i,-i,- i,- i,- i,- i,- i,- i,-



Library, Name Manager, Formula Auditing Tools (Trace
i,- i,- i,- i,- i,- i,- i,-



Precedents, Trace Dependents) i,- i,-




Data Tabi,- Important Features: Filter, Sort, Text to Columns,
i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-



Flash Fill, Data Validation, Data Tables (Goal Seek), Group/Ungroup
i,- i,- i,- i,- i,- i,- i,- i,-




Review Tab i,- i,-i,- i,- Important Features: New Comment i,- i,- i,-




View Tab i,- i,-i,- i,- Important Features: Zoom, Gridlines i,- i,- i,-




Developer Tab i,- i,-i,- i,- Important Features: Record Macro, Add-Ins i,- i,- i,- i,-




Accessing Settings (Excel Options) i,- i,- i,- i,-i,- i,- File > Options (Alt F T or
i,- i,- i,- i,- i,- i,- i,-



Alt T O)
i,- i,-




MAC: Excel > Preferences
i,- i,- i,-




Excel Settings Changes
i,- i,- i,-i,- i,- General: i,-




Change "Sheets in New Workbook" to 3
i,- i,- i,- i,- i,- i,-




Uncheck "Show Workbook Gallery when opening Excel"
i,- i,- i,- i,- i,- i,-




Calculation/Functions:

,Change Calculation Options to "Automatic except for data tables"
i,- i,- i,- i,- i,- i,- i,- i,-




Check "Enable iterative calculation"
i,- i,- i,-




Edit/Advanced:
Uncheck "After pressing Enter, move selection"
i,- i,- i,- i,- i,-




*Optional - Check "Automatically insert a decimal point"
i,- i,- i,- i,- i,- i,- i,-




Protection Go to File > Info > Password Protecting Files (File
i,-i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



> Passwords)
i,-




Alt F T I
i,- i,- i,-




You can password protect files "Encrypt with Password"
i,- i,- i,- i,- i,- i,- i,-




You can also protect individual worksheets so that people can't
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



see or edit formulas "Protect Current Sheet"
i,- i,- i,- i,- i,- i,-




Shortcuts to Allow the User Input to Add More Sheets to a
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Workbook Alt i w i,-i,- i,- i,- i,-




Alt h i s
i,- i,- i,-




Shift F11 i,-




Alt Shift F1
i,- i,-




Find or Find and Replace Shortcut
i,- i,- i,- i,- i,- i,-i,- i,- Ctrl F i,-




(Cmnd F) i,-

, What is the recommended workbook calculation setting for
i,- i,- i,- i,- i,- i,- i,- i,-



Excel? Automatic Except for Data Tables
i,-i,- i,- i,- i,- i,- i,-




Add a Cell Reference From a Different Worksheet into an Existing
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Formula Hit F2 to get into the existing formula; delete any
i,-i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



incorrect formulas or operators i,- i,- i,-




Hit F2 again to enable "Enter" mode on the bottom-left corner of
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



the Excel sheet
i,- i,-




Holding down Ctrl, use PageUp or PageDown to find the desired
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



worksheet
Let go of the Ctrl and PageUp/Down keys
i,- i,- i,- i,- i,- i,- i,-




Use the arrow keys to located the desired cell reference
i,- i,- i,- i,- i,- i,- i,- i,- i,-




Hit Enter
i,-




Autofit Row Height Command i,- i,- i,- i,-i,- i,- Alt H O A i,- i,- i,-




Autofit Column Height Command
i,- i,- i,- i,-i,- i,- Alt O C A i,- i,- i,-




Assign Column Width Command
i,- i,- i,- i,-i,- i,- Alt H O W i,- i,- i,-




(Home > Format > Column Width)
i,- i,- i,- i,- i,-