EXCEL CRASH COURSE EXAM FROM WALL
STREET PREP - WALL STREET PREP
QUESTIONS AND CORRECT ANSWERS
LATEST UPDATED 2026/2027
AlldofdthedfollowingdaredkeyboarddshortcutdthatdallowdtheduserdinputdtodadddmoredsheetsdtodadworkbookdE
XCEPT:d-dCORRECTdANSWER-Altdhdidw
Whatdisdadkeyboarddshortcutdtodopendadfile?d-dCORRECTdANSWER-Ctrldo
WhatdisdthedrecommendeddworkbookdcalculationdsettingdfordExcel?d-dCORRECTdANSWER-
AutomaticdexceptdfordDatadTables
Todadddadcelldreferencedfromdaddifferentdworksheetdintodandexistingdformuladwithdyourdkeyboard,dyoudsho
ulddfollowdthedfollowingdsteps:d-dCORRECTdANSWER-
1.dHitdF2dtodgetdintodthedexistingdformula;ddeletedanydincorrectdformulasdordoperatorsd2.dHitdF2dagaindtode
nabled"Enter"dmodedondthedbottom-
leftdcornerdofdthedExceldsheetd3.dHoldingddowndCtrl,dusedPageUpdordPageDowndtodfinddtheddesireddworksh
eetd4.dLetdgodofdthedCtrldanddPageUp/Downdkeysd5.dUsedthedarrowdkeysdtodlocatedtheddesireddcelldreferenc
ed6.dHitdEnter
Altdhdodid-dCORRECTdANSWER-exactdcolumndwidth
Altdhdodwd-dCORRECTdANSWER-identicaldcolumndwidths
Altdhdodhd-dCORRECTdANSWER-identicaldcolumndheight
Controld+dSpaced-dCORRECTdANSWER-highlightdcolumn
Shiftd+dSpaced-dCORRECTdANSWER-highlightdrow
, Commandd+dBd-dCORRECTdANSWER-bold
Commandd+dId-dCORRECTdANSWER-italicize
Altdedsd/dcontroldcommanddvd-dCORRECTdANSWER-pastedspecial
Whatdisdthedkeyboarddshortcutdtodmovedsheetsdwithindadworkbook?d-dCORRECTdANSWER-AltdHdOdM
Whatdisdthedkeyboarddshortcutdtodopendthedformattingdcellsddialogdbox?d-dCORRECTdANSWER-Ctrld1
Whatdaredthedkeyboarddshortcutsdfordauto-fittingdadrangedofdcolumns?d-dCORRECTdANSWER-
1)dSelectdthedcolumnsdbydhittingdCtrldSpacebar.d2)dHoldddowndthedshiftdkeydanddusedleftdanddrightdarrowdk
eysdtodhighlightdthedrangedofdcolumns.d3)dHitdAltdHdOdIdtodautodfitdthedcolumns.
WhendyoudaredindthedFormatdCellsddialogd(Ctrld1):
Whatdisdthedkeyboarddshortcutdfordmovingdacrossdtabsd(Number,dAlignment,dFontdBorder,dFill,dProtection)
?
Howddodyoudmovedcounterdclockwisedacrossdformdelements?
Howddodyoudselectdadcheckboxd(putdadcheckboxdnextdtodit)d-dCORRECTdANSWER-1)dCtrldTabd
2)dShiftdTabd
3)dSpacebar
altdwdfdfd-dCORRECTdANSWER-freezedpane
altdwdsd-dCORRECTdANSWER-splitdpane
F6d-dCORRECTdANSWER-jumpdbetweendpanes
AltdHdEdAd-dCORRECTdANSWER-deletedeverythingdaboutdadcell
STREET PREP - WALL STREET PREP
QUESTIONS AND CORRECT ANSWERS
LATEST UPDATED 2026/2027
AlldofdthedfollowingdaredkeyboarddshortcutdthatdallowdtheduserdinputdtodadddmoredsheetsdtodadworkbookdE
XCEPT:d-dCORRECTdANSWER-Altdhdidw
Whatdisdadkeyboarddshortcutdtodopendadfile?d-dCORRECTdANSWER-Ctrldo
WhatdisdthedrecommendeddworkbookdcalculationdsettingdfordExcel?d-dCORRECTdANSWER-
AutomaticdexceptdfordDatadTables
Todadddadcelldreferencedfromdaddifferentdworksheetdintodandexistingdformuladwithdyourdkeyboard,dyoudsho
ulddfollowdthedfollowingdsteps:d-dCORRECTdANSWER-
1.dHitdF2dtodgetdintodthedexistingdformula;ddeletedanydincorrectdformulasdordoperatorsd2.dHitdF2dagaindtode
nabled"Enter"dmodedondthedbottom-
leftdcornerdofdthedExceldsheetd3.dHoldingddowndCtrl,dusedPageUpdordPageDowndtodfinddtheddesireddworksh
eetd4.dLetdgodofdthedCtrldanddPageUp/Downdkeysd5.dUsedthedarrowdkeysdtodlocatedtheddesireddcelldreferenc
ed6.dHitdEnter
Altdhdodid-dCORRECTdANSWER-exactdcolumndwidth
Altdhdodwd-dCORRECTdANSWER-identicaldcolumndwidths
Altdhdodhd-dCORRECTdANSWER-identicaldcolumndheight
Controld+dSpaced-dCORRECTdANSWER-highlightdcolumn
Shiftd+dSpaced-dCORRECTdANSWER-highlightdrow
, Commandd+dBd-dCORRECTdANSWER-bold
Commandd+dId-dCORRECTdANSWER-italicize
Altdedsd/dcontroldcommanddvd-dCORRECTdANSWER-pastedspecial
Whatdisdthedkeyboarddshortcutdtodmovedsheetsdwithindadworkbook?d-dCORRECTdANSWER-AltdHdOdM
Whatdisdthedkeyboarddshortcutdtodopendthedformattingdcellsddialogdbox?d-dCORRECTdANSWER-Ctrld1
Whatdaredthedkeyboarddshortcutsdfordauto-fittingdadrangedofdcolumns?d-dCORRECTdANSWER-
1)dSelectdthedcolumnsdbydhittingdCtrldSpacebar.d2)dHoldddowndthedshiftdkeydanddusedleftdanddrightdarrowdk
eysdtodhighlightdthedrangedofdcolumns.d3)dHitdAltdHdOdIdtodautodfitdthedcolumns.
WhendyoudaredindthedFormatdCellsddialogd(Ctrld1):
Whatdisdthedkeyboarddshortcutdfordmovingdacrossdtabsd(Number,dAlignment,dFontdBorder,dFill,dProtection)
?
Howddodyoudmovedcounterdclockwisedacrossdformdelements?
Howddodyoudselectdadcheckboxd(putdadcheckboxdnextdtodit)d-dCORRECTdANSWER-1)dCtrldTabd
2)dShiftdTabd
3)dSpacebar
altdwdfdfd-dCORRECTdANSWER-freezedpane
altdwdsd-dCORRECTdANSWER-splitdpane
F6d-dCORRECTdANSWER-jumpdbetweendpanes
AltdHdEdAd-dCORRECTdANSWER-deletedeverythingdaboutdadcell