Wall Street Prep Excel Crash Course Final Review 2026–2027 Questions, Answers & Study Guide

Wall Street Prep Excel Crash Course Final Review
2026–2027 | Questions, Answers & Study Guide
1. Keyboard Versus the Mouse: AlmosteverythingthatcanbedoneinExcelusingamousecanalso bedone i i i i i i i i i i i i i i i i i i




usingthekeyboardshortcuts
i i i i




Bestwaytolearn istodisconnect themouse andwork throughExcelusing only thekeyboard
i i i i i i i i i i i i i i i i




2. Name Box: Tellsyouwhatcellyouarein(topleftbelowtheribbon)
i i i i i i i i i i i i i




3. Formula Bar: When you insert a formula into a cell and hit return, the cell will show you The
i i i i i i i i i i i i i i i i i i the output
i




formulabar,however,willshowyoutheformula
i i i i i i i i




Nextto"fx"rightbelowtheribbon
i i i i i i




4. Worksheets: AnExcelfileiscalledaworkbook; You i i i i i i i i




start with 1 worksheet but you can add/delete more The active
i i i i i i i i i i i




worksheet is highlighted in Excel
i i i i i




5. MovingBetween Worksheets: Ctrl+PageDown/PageUp i i i i i




(Option + RightArrow/LeftArrow)
i i i




6. AddingWorksheets: (FnShiftF11) i i i i




7. Columns: Alphabetically labeled (A, B, C, i i i i i




8. Rows: Numericallylabeled(1,2,3,etc.) i i i i i i




9. Main tabs: Although we focus on shortcuts, virtually all commands, functions, and Excel features can be accessed
i i i i i i i i i i i i i i i i




through the task-oriented tabs which organize them into nine logical categories:
i i i i i i i i i i i




(1) Home
(2) Insert
(3) Draw
(4) PageLayout i




(5) Formulas

i i

,(6) Data
(7) Review
(8) View
(9) Developer
10. How to Access Ribbon on Mac: CtrlFnF2 Use i i i i i i i i i




arrowkeystoperusetheMacribbon
i i i i i i i




11. Mac Settings to Disable: (1) Function Keys: Settings - Keyboard - Use F1, F2, etc. keys as standard function
i i i i i i i i i i i i i i i i i i




keys
i




(2) Mission Control: System Preferences - Keyboard -Shortcuts - Mission Control - Disable "Move a space left" and "Move a
i i i i i i i i i i i i i i i i i i i i




space right" to use Ctrl RightArrow or Ctrl LeftArrow
i i i i i i i i i




12. Using Function Keys: HitFnand thenthefunction keytousethe functionkeysthemselves ona Mac
i i i i i i i i i i i i i i i i i i




13. OpenaNewWorkout:CtrlN i i i i i




CmndN
i i




14. The File Tab: Many Excel features (Open file, Save file, Print file, etc.) are located in this tab Excelalso
i i i i i i i i i i i i i i i i i i i




hasalternativekeyboardshortcuts(usingCtrl)formanyofthesefeatures
i i i i i i i i i i i




OpenaFile:CtrlO(CmndO)Save
i i i i i i i




a File: Ctrl S (Cmnd S) Print a
i i i i i i i i




File: Ctrl P (Cmnd P)
i i i i i




15. SaveaFile:CtrlS i i i i




CmndS
i i




16. PrintaFile:CtrlP i i i i




CmndP
i i




17. Opena File: CtrlO i i i i




CmndO
i i




18. Toolbars: WithineachofthemaintabsyouwillfindallofExcel'sfeatures,groupedbycommands i i i i i i i i i i i i i i i i




19. NavigatingtotheToolbarsWithouttheMouse:HitAltandtheappropriateletter(oruse the i i i i i i i i i i i i i i i




right/leftarrowkeys)togettothedesiredtab
i i i i i i i i i




Oncethere,usetheTabandShiftTabkeystonavigatearound,theSpacetoopenadropdown,andEntertoselect
i i i i i i i i i i i i i i i i i i i i i i




20. Bold Command: CtrlB i i i




CmndB
i i




21. The HomeTab:Includesmostformattingproperties:
i i i i i i




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





i i

, Backgroundcolor i




Text/cellalignment
i i




Changing currency, decimal, percent formats Inserting, i i i i i




deleting, and hiding rows and columns Adjustingcolumns
i i i i i i i i




androwswidth
i i i




Inserting,deleting,andrenamingworksheets i i i i




22. TheInsertTab:ImportantFeatures:PivotTable,Charts,Header&Footer
i i i i i i i i i i




23. Page Layout Tab: ImportantFeatures:PrintArea,Fonts,Gridlines
i i i i i i i i




24. Formulas Tab: Important Features: Insert Function, Function Library, Name Manager, Formula Auditing Tools
i i i i i i i i i i i i




(Trace Precedents, Trace Dependents)
i i i i




25. DataTab: ImportantFeatures:Filter,Sort,TexttoColumns,FlashFill,DataValidation,DataTables(GoalSeek),
i i i i i i i i i i i i i i i i




Group/Ungroup
i




26. Review Tab: ImportantFeatures:NewComment i i i i i




27. View Tab: ImportantFeatures:Zoom,Gridlines i i i i i




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




29. Accessing Settings (Excel Options): File>Options(AltFTorAltTO) MAC: i i i i i i i i i i i i i i




Excel>Preferences
i i i




30. Excel Settings Changes: General: i i i




Change"SheetsinNewWorkbook"to3 i i i i i i




Uncheck"ShowWorkbookGallerywhenopeningExcel" i i i i i i




Calculation/Functions:
Change Calculation Options to "Automatic except for data tables" Check
i i i i i i i i i




"Enable iterative calculation"
i i i




Edit/Advanced:
Uncheck"AfterpressingEnter,moveselection"
i i i i i




*Optional- Check "Automatically insert a decimalpoint"
i i i i i i i




31. Protection: GotoFile>Info>PasswordProtectingFiles(File>Passwords) AltFTI i i i i i i i i i i i i i i i i




Youcanpasswordprotectfiles"EncryptwithPassword"
i i i i i i i




Youcanalsoprotectindividualworksheetssothatpeoplecan'tseeoreditformulas"ProtectCurrentSheet"
i i i i i i i i i i i i i i i i





i i